Skip to main content
Question

Parse an email from multi select list for notification

  • October 7, 2020
  • 0 replies
  • 72 views

Need help parsing email address for a multi-select list. I would like the list to display name along with the email. 
Current list display:
jsmith@quickbase.com
j.doe@anotheremail.com

Desired list display:
John Smith - jsmith@quickbase.com
Jane Doe - j.doe@anotheremail.com

My email field formula is:

var text EmailList = ToText([Email select field test]);

Trim(Part($EmailList, 1,";"))

The formula works great for my notification emails but I'm stuck on parsing out the emails for the list to display.

Thanks!

This topic has been closed for replies.

  • Quickbase Alumni
  • October 7, 2020
Just to clarify, you have a Multi-Select Text field that you currently have showing email addresses and you would like it to show the Name and Email address instead. In addition, you would then like to modify your current formula to pull out the first email address from your newly formatted list. Is this correct?

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------