Forum Discussion

VivekVishwanat2's avatar
VivekVishwanat2
Qrew Cadet
6 years ago

User List in the dynamic Filter?

Hi, 
How to show List User in the Dynamic filters?

My Experiment:-
I tried to create a formula field called "Developer Field" with the formula "ToText([Developer])"
where Developer is a List User.

I showed the "Developer Field" in the Filter Column and it works.

The problem here is, as Developer is a List User field, It may have multiple User information 

for the case, abc@gmail.com is different abc@gmail.com; xzy@gmail.com

When the User selects abc@gmail.com, it should show abc@gmail.com even though the list has other users(xyz@gmail.com).
reports and charts
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    I don't think that there is an easy way to do that, so typically we use the filter box at the top of the report to do that. But I do think that there is a Quick Base roadmap "todo" to make that easier in the future.

    I suggest including the names of the users as opposed to the email addresses  with a formula of

    UserListToNames (UserList ul, Text format)

    Description: Returns a semi-colon separated list of users' full names. Specify text format by including "FF" to return the full names with the first name first. Or, include "LF" to return the full names with the last name first.

    Example: UserListToNames([Volunteers], "LF"), returns "Smith, Michael; Jones, Nancy" where the Volunteers are the users Michael Smith and Nancy Jones.