[SalesForce] Concatenating address field in formula

I don't know if the subject resume my problem . I would like to display in my HTML page the name of Supplier with adress .
on HTML something like that :

<span> Supplier Name <br/> Supplier Adress  </span>

when I try to create a field as a formula type and edit this as a formula .

Account__r.Name + BR()+ Account__r.BillingAddress

the result is an error message like this

Error: Incorrect parameter type for operator '+'. Expected Text, received Location

Note that the formula return type is text.

Best Answer

Try using 

Account__r.Name + BR()+ Account__r.BillingStreet+ BR() + Account__r.BillingCity + BR() +....

to build up the full address.

Address fields are a special case in Salesforce and are a concatenation of the underlying data fields. Selecting each individually can get around errors like this.

Related Topic