Contact Card email address fo automation

07/19/21
Accepted

Hi All,

I have a sheet where customers send a submission and get automated emails with field data that they submitted. I want to provide details of the assignee of their submission but want to provide the assignees email address stated on their contact card - is there any way of doing this?

I currently grab field data by using double curly brackets but I assume that might not work here?

Thanks

Best Answer

  • Genevieve P.Genevieve P. admin
    Accepted Answer

    Hi @MHuggs

    You're correct - if you're storing the assignee as a Contact in a Contact Column, then the curly brackets would return the Name (the text on top of the email) versus the email address of the Contact. You'd need to have a separate column in your sheet set as a Text/Number column which identifies the email address in order to display that in your alert. Please let our Product team know about your specific use-case and request by filling in this form, here!

    One way to bring in that email address would be to have a second reference sheet which stores the Contact next to their email address. Then you can use an INDEX(MATCH formula to populate the email address automatically as soon as a Contact is assigned in the Assignee column. Would that work for you? Let me know if you need help building the formula and I'm happy to provide screen captures.

    Cheers,

    Genevieve

Answers

  • Genevieve P.Genevieve P. admin
    Accepted Answer

    Hi @MHuggs

    You're correct - if you're storing the assignee as a Contact in a Contact Column, then the curly brackets would return the Name (the text on top of the email) versus the email address of the Contact. You'd need to have a separate column in your sheet set as a Text/Number column which identifies the email address in order to display that in your alert. Please let our Product team know about your specific use-case and request by filling in this form, here!

    One way to bring in that email address would be to have a second reference sheet which stores the Contact next to their email address. Then you can use an INDEX(MATCH formula to populate the email address automatically as soon as a Contact is assigned in the Assignee column. Would that work for you? Let me know if you need help building the formula and I'm happy to provide screen captures.

    Cheers,

    Genevieve

Sign In or Register to comment.