Convert combined text email list to list user field

Question

I am trying to take a summary field of users (which in reality is a text field of email addresses), and convert it to a user list field.

My attempt did not work and I am not sure why. I created this formula in a field we will call [Converted To Correct Format Formula]:

If(ToText([Combined Text Field])<>"","Touser(\"")
& SearchAndReplace(ToText([Combined Text Field]),";", "\"),touser(\"")
& If(ToText([Combined Text Field])<>"", "\")")

That yields a result such as:
Touser("email1@email.com), touser("email2@email.com")

I made a user list field and if I do the following, it works:

touserlist(Touser("email1@email.com), touser("email2@email.com"))

But if I try this, it fails
touserlist([Converted to Correct Format Formula])

It tells me it is expecting a userlist but it is text, which I guess makes sense as it doesnt know what my formula field yields. Is there an easier way and I am just over complicating?

------------------------------
Mike Tamoush
------------------------------

MarkShnierYou · Accepted Answer

I tested this and it works. make a field on the child table wth a formula of

ToText([My List-User field]) and then roll it up with a Combined Text summary field to the Parent.

var text value = ToText([Combined Text List-User(text format)]);

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,";"))))

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community