Formula field to Convert a Muti-Select Text field to a User List field

Question

I have a list of names in a Multi-Select Text field that I would like to convert to a User-List. Is there a formula that will do this for me? If not any other ideas?

------------------------------
George Bramhall
------------------------------

markshnier__you · Answer

Do you have access to a list of emails as opposed to names? You cannot get to a userid from just a name. If not you would need to make a table of names and then enter their email addresses or userid, to make the translation via getting the email / userid from a lookup.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

georgebramhall2 · Answer

I am getting the list of names with a Summary field (or query field). This is my challenge.------------------------------George Bramhall------------------------------

markshnier__you · Answer

Does the source of the summary know the email addresses?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

georgebramhall2 · Answer

Yes------------------------------George Bramhall------------------------------

markshnier__you · Answer

if you make a formula field on the child table for the text value of the userid (or email) like this
ToText([My userid field])

Then you can roll that up to a combined text summary field and then convert it to a formula List User field.

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

------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Formula field to Convert a Muti-Select Text field to a User List field

10 Replies