Details about this thread
  • State Not Answered
  • Replies 7 replies
  • Subscribers 313 subscribers
  • Views 1515 views
  • Users 0 members are here
Related content from around SugarClub

Calculated field to concatenate Email fields

Freddy Jreisat

We have a field on the Opportunity module which concatenates the email and email2 field from related contact (it's a custom 1:M contacts_opportunities relationship:

concat(related($contacts_opportunities,"email1"),";",related($contacts_opportunities,"email2"))

After upgrading to Sugar 11, this no longer works. I don't think email2 is accepted anymore. I'm wondering what is another way we can do this? Ideally to concat as many email addresses as possible from the related contact?

Will greatly apppreciate any help. Thank you.

Parents
  • +1

    Hi ,

    So the opportunity has one contact and you want all the email addresses for that contact to be listed on the Opportunity as a semi-colon separated list.

    Do you want this to be a snapshot in time when the Opportunity is created or do you want that list to be updated every time you update either the Contact's email addresses or the Opportunity?

    What is the ultimate business purpose for this field?

    I'm asking so I might understand how to best achieve your goal without having to store such a list which may be error prone, I used to do that in a custom module back when I first started working with Sugar in v6 but ran into so many issues that I totally scrapped it and started over with a total redesign to meet our needs.

    FrancescaS

Reply
  • +1

    Hi ,

    So the opportunity has one contact and you want all the email addresses for that contact to be listed on the Opportunity as a semi-colon separated list.

    Do you want this to be a snapshot in time when the Opportunity is created or do you want that list to be updated every time you update either the Contact's email addresses or the Opportunity?

    What is the ultimate business purpose for this field?

    I'm asking so I might understand how to best achieve your goal without having to store such a list which may be error prone, I used to do that in a custom module back when I first started working with Sugar in v6 but ran into so many issues that I totally scrapped it and started over with a total redesign to meet our needs.

    FrancescaS

Children
  • 0 in reply to Francesca Shiekh
    Francesca Shiekh said:
    So the opportunity has one contact and you want all the email addresses for that contact to be listed on the Opportunity as a semi-colon separated list

    Precisely.

    Francesca Shiekh said:

    Do you want this to be a snapshot in time when the Opportunity is created or do you want that list to be updated every time you update either the Contact's email addresses or the Opportunity?

    The latter. We would like it to be updated along with the Contact and kept in sync with it.

    Francesca Shiekh said:

    What is the ultimate business purpose for this field?

    To allow sales reps to both easily see as well as copy/paste all of the customer's available email addresses instead of just the primary.

    Francesca Shiekh said:
    I'm asking so I might understand how to best achieve your goal without having to store such a list which may be error prone, I used to do that in a custom module back when I first started working with Sugar in v6 but ran into so many issues that I totally scrapped it and started over with a total redesign to meet our needs.

    Of course. :) Thank you so much.