# Discussions

View Only

## Convert combined text email list to list user field #### Mike Tamoush24 days ago #### Mark Shnier (YQC)24 days agoBest Answer • #### 1.  Convert combined text email list to list user field

Posted 24 days ago
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
------------------------------

• #### 2.  RE: Convert combined text email list to list user field Best Answer

Posted 24 days ago
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
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

• #### 3.  RE: Convert combined text email list to list user field

Posted 24 days ago
Brilliant! Worked like a charm

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