Forum Discussion

GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
9 months ago

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

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
------------------------------

10 Replies

  • 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's avatar
      GeorgeBramhall2
      Qrew Cadet

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



      ------------------------------
      George Bramhall
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        Does the source of the summary know the email addresses?



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