I want to make my user-list field a dynamic filter

  • 1
  • 1
  • Question
  • Updated 3 months ago
  • Answered
I have a field type of "List-User". On a report, I wanted to filter by that field. So i looked at all available fields for dynamic filter, but it was not listed as an option...

I want to make that field into a dynamic filter. Any suggestions on what I should do?
Photo of Ja

Ja

  • 0 Points

Posted 2 years ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
Try making a new field of type Formula-Text
ToText(My List-User field])

and see if that will be offered as a choice.
Photo of Amber

Amber

  • 546 Points 500 badge 2x thumb
I'd love to do this as well. I created a ToText field for my User field which can operate as a dynamic filter, but not in the in the beautiful way that multiselect fields usually do--that is, to allow each option as it's own filter, rather than list all of the combinations as individual filters.

So, the list right now looks like, for example:

bob
bob;david
bob;david;susan
harry
harry;susan
susan

Any suggestions on how I can get a list that looks like:

Bob
David
Susan

Thanks!
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,438 Points 50k badge 2x thumb
There is no easy answer to this one, but you can use the Searxh box above the Report to search like Susan OR bob. The OR has to be in upper case.
Photo of Amber

Amber

  • 546 Points 500 badge 2x thumb

Ah, got it. If anyone could figure it out, you could!

Good to know, thank you!

Photo of Johnny DeVilla

Johnny DeVilla

  • 142 Points 100 badge 2x thumb
Reopening this thread in case a solution has been reached in the last year.
Photo of Alberto Nava

Alberto Nava

  • 60 Points
is there a solution? i have the same problem of Amber!
Photo of Harrison Hersch (QB)

Harrison Hersch (QB), Quick Base Sr. Product Manager (Platform)

  • 1,398 Points 1k badge 2x thumb
Hi all. As an FYI, we have some enhancements planned to improve the behavior of list-user and multi-select text fields as it relates to reporting. Stay tuned to our release notes throughout Q1 to keep informed.