Forum Discussion
EdGrandinetti
5 years agoQrew Member
That didn't work. Might help if I explain that the email formula is unique to each email.
ie.,
Trim(Part($EmailList, 1,";"))
Trim(Part($EmailList, 2,";")), etc.
corresponds to the
[Email 1]
[Email 2]
in the notification.
I have over 20 emails that a user can select from.
Thanks!
------------------------------
Ed
------------------------------
ie.,
Trim(Part($EmailList, 1,";"))
Trim(Part($EmailList, 2,";")), etc.
corresponds to the
[Email 1]
[Email 2]
in the notification.
I have over 20 emails that a user can select from.
Thanks!
------------------------------
Ed
------------------------------
BlakeHarrison
5 years agoQrew Captain
The formula should still work, but you would need to increment by 2 instead of by 1 for each email address that you need to pull out. So:
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Trim(Part(SearchAndReplace($EmailList,"-",";"), 2,";")) = [Email1]
Trim(Part(SearchAndReplace($EmailList,"-",";"), 4,";")) = [Email2]
etc
Without knowing how you're using these or how your application is structured, have you thought about having these Emails as a separate table? It would require another table to act as a Many to Many between the Emails and the existing table, but you would have more flexibility in the future. You could also still pull the email addresses up through a Summary field.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- EdGrandinetti5 years agoQrew MemberThanks Blake! That solved it. I considered a separate email address table but decided to keep it simple, since at this point I don't foresee a need for it. This particular list has non-user and distribution groups included. All other application requirements are for users only.
Thanks again!
------------------------------
Ed
------------------------------