Forum Discussion

MichaelNaser's avatar
MichaelNaser
Qrew Trainee
2 years ago

How to Change Multi-select Text (summary) to user field

I am having issue creating a formula to convert Combined text Multi-select Text (summary) to a user field !

I saw Mark's post about how to change it, however it did not work for me

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

My issue is that I receive a syntax error saying "expecting user but found user list"



------------------------------
Michael Naser
------------------------------
  • RyanPflederer3's avatar
    RyanPflederer3
    Quickbase Staff
    2 years ago

    Hi Michael! 

    If you want to have multiple users displayed then you'll want to change the field type from User to List - User. After doing so the error should be resolved and you'll be all set.



    ------------------------------
    Ryan Pflederer
    ------------------------------

    • ChayceDuncan's avatar
      ChayceDuncan
      Qrew Captain
      2 years ago

      To add one more comment to Ryan's response - you won't be able to change your field to list-user given the special nature of that field, so you'll have to make a new list-user field but otherwise to echo the comment that will resolve the issue. 



      ------------------------------
      Chayce Duncan
      ------------------------------