Concatenate Formula in Sugar Logic using Relate Field Types

Hi Casey Henry 

Yes, it is possible to concatenate related fields.

The formula may look like this one:

concat(related($accounts,"name")," - ", $opportunity_type)

In the example above I created a formula for the field "name" at the module "Opportunities".

I hope this help you.

Kind regards

Hi, Thanks for the info above.

Ref concatenating related fields - don't suppose you know if it is possible to break the fields up with a carriage return somehow?  I am using this for an address to pop it all into one field but I don't want it on one long line.

I can get this:

Lukes street Lukes City Lukes County Lukes Postcode Lukes Country  (using a space or comma seperated between each line)

But would like this: (with a carriage return?)

Lukes street

Lukes City

Lukes County

Lukes Postcode

Lukes Country

Hi, Thanks for the info above.

Ref concatenating related fields - don't suppose you know if it is possible to break the fields up with a carriage return somehow?  I am using this for an address to pop it all into one field but I don't want it on one long line.

I can get this:

Lukes street Lukes City Lukes County Lukes Postcode Lukes Country  (using a space or comma seperated between each line)

But would like this: (with a carriage return?)

Lukes street

Lukes City

Lukes County

Lukes Postcode

Lukes Country

sugarLogic doesn't support such string replacement, so you may need to create a custom sugarLogic function for this purpose.

Regards