Skip to main content
Question

Create Formula User List with Combined Text field of email

  • August 12, 2021
  • 0 replies
  • 248 views
Hello,

I need to create a user list to send out email notifications.

We have projects, and on each project there are staff assigned. Project and Staff are two separate tables. On the staff table each staff has an email. I have many staff connected to one project. I've converted the staff emails to text and have rolled those up into a summary field on the projects table, so i have a combined text field of the emails.

Is it possible to create a user list of the emails in this fields? To somehow use the the touserlist() formula and take each email from the combined text field?

Appreciate any help!

------------------------------
Mackenzie Phillips
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+14
I've done exactly this. But you have to parse out each part of the combined text list. This works for up to 20 names and of course you can add on.

var text value = ToText([Combined Text of Emails Field]);

ToUserList(
ToUser(Trim(Part($value,1,";"))),
ToUser(Trim(Part($value,2,";"))),
ToUser(Trim(Part($value,3,";"))),
ToUser(Trim(Part($value,4,";"))),
ToUser(Trim(Part($value,5,";"))),
ToUser(Trim(Part($value,6,";"))),
ToUser(Trim(Part($value,7,";"))),
ToUser(Trim(Part($value,8,";"))),
ToUser(Trim(Part($value,9,";"))),
ToUser(Trim(Part($value,10,";"))),
ToUser(Trim(Part($value,11,";"))),
ToUser(Trim(Part($value,12,";"))),
ToUser(Trim(Part($value,13,";"))),
ToUser(Trim(Part($value,14,";"))),
ToUser(Trim(Part($value,15,";"))),
ToUser(Trim(Part($value,16,";"))),
ToUser(Trim(Part($value,17,";"))),
ToUser(Trim(Part($value,18,";"))),
ToUser(Trim(Part($value,19,";"))),
ToUser(Trim(Part($value,20,";"))))

------------------------------
Mike Tamoush
------------------------------
Terms & ConditionsAccessibility statement