Forum Discussion

MrunaliKadam's avatar
MrunaliKadam
Qrew Trainee
3 years ago

Need to show the entire list of users in the report

Hi, I've a list-user type field which has around 16 items. In the report it shows only names of 2 names and only count of the remaining users. when I click on that count it shows a list of users in...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
you can make a formula text like this one.

var text MyListUsers = ToText([My List User Field]);

List("\n",
UserToName(ToUser(Part($MyListUsers,1,";"))),
UserToName(ToUser(Part($MyListUsers,2,";"))),
UserToName(ToUser(Part($MyListUsers,3,";"))),
UserToName(ToUser(Part($MyListUsers,4,";"))),
UserToName(ToUser(Part($MyListUsers,5,";"))),

etc ...
UserToName(ToUser(Part($MyListUsers,20,";"))))

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • MrunaliKadam's avatar
    MrunaliKadam
    Qrew Trainee
    3 years ago
    Great, It works! As always Thank you Mark for responding to this so quickly :)

    ------------------------------
    Mrunali Kadam
    ------------------------------