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
  • Hi  

    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

  • 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

  • would this work for a form we wanted to capture out in the field also?  Meaning if the template was in "Sugar" could the team fill it out and it be stored in Sugar?

Reply Children
No Data