user26927

Should I do this with a calculation?

Discussion created by user26927 on May 15, 2016
Latest reply on May 16, 2016 by keywords

I would like to format an address for related records to put on the layout for displaying purposes only.

 

Example:  Accounts and Orders

On the order layout I would like to display the account shipping address. 

 

In the accounts table I have several fields that makeup the address.  Street, City, State, Zip, Country.

 

So....on the orders layout when I display the related address fields...the spacing isn't quite right. 

It would be nice to display the address in a way where regardless of the length of a city....there is always one space and then the state and zip are displayed. 

 

What is the best practice for handling this scenario? 

Merge fields?

Create a new calculation field on the account table that gets the info from the address fields and displays it in a concise form in one field that I can use whenever I need to display the address?

None of the above?

 

Thanks for the advice

Outcomes