Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago
Solved

Convert combined text email list to list user field

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 th...
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    5 years 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
    ------------------------------
MICHAELSARGENT's avatar
MICHAELSARGENT
Qrew Cadet
4 years ago
Mark, how can I make this work in a 1:M relationship?  I have an app in which I have a project table and then a related Assigned PMs table in which multiple PMs can be assigned to one project.  They are individual users versus a List-User field so each PM has autonomy to do their own updates for their child record.  Similar situation as above whereby I want to create a notification at the parent (project) table and sent it to all users related to that project.  As such, I need a user-list value at the parent level.

------------------------------
Michael Sargent
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
The post directly above explains the technique.  Did you try it?  Where did you get stuck?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • MICHAELSARGENT's avatar
    MICHAELSARGENT
    Qrew Cadet
    4 years ago
    I guess where i got stuck is the part of ToText([My List-User Field]).  I inferred that you were having us fill in the My List-User Field with whatever List-User field we had.  With my example, i don't have such a field as I'm just using a User field.   Should I follow the instructions without assuming we have such fields in our table?

    ------------------------------
    Michael Sargent
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      Yes, make a formula text field on the child table with this type of formula

      ToText([My User Field]).

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • MICHAELSARGENT's avatar
        MICHAELSARGENT
        Qrew Cadet
        4 years ago
        Worked perfectly, thank you!

        ------------------------------
        Michael Sargent
        ------------------------------