Discussions

Expand all | Collapse all

Convert combined text email list to list user field

Jump to Best 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
    Your Quick Base Coach
    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
    ------------------------------