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 a popup form. 

Is there a way I can show the entire list of users in the report (instead of +14). ? 



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

2 Replies

  • 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
      Great, It works! As always Thank you Mark for responding to this so quickly :)

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