Can I concat multiple related module records into one text area?

Hello

I am trying to create a text field which concatenates all names/emails from related records.

e.g. In the Accounts module I want a field that lists out each of the contacts related to the account and to concatenate the fields (Name) and (Email address).

I have managed to setup a test field that concatenates for 1 record but have been unable to do it for all existing related contacts. Can this be done?

As always help greatly appreciated.

Many Thanks

Jaymie

Parents

0 Jaymie Raymond over 1 year ago

Hi Chris Raffle

It's for a report for one of our teams, we can always manipulate the date when exported, so not the end of the world.

Thanks you very much for responding and confirming my suspicions.

Many thanks

Jaymie
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Jaymie Raymond over 1 year ago

Hi Chris Raffle

It's for a report for one of our teams, we can always manipulate the date when exported, so not the end of the world.

Thanks you very much for responding and confirming my suspicions.

Many thanks

Jaymie
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Lydia Manger over 1 year ago in reply to Jaymie Raymond

Hi Jaymie. If you are trying to have this in an external report (and not in a Sugar field), have you looked into whether Doc Merge would be of use? You could create a template that contains the information needed and then use the list view to select all the account records you want to include and use the Mass Actions menu to perform the Doc Merge.

Lydia Manger

Product Manager — Sugar Discover
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel