Skip to main content
Question

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

  • January 12, 2017
  • 0 replies
  • 189 views
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?
This topic has been closed for replies.

Try making a new field of type Formula-Text
ToText(My List-User field])

and see if that will be offered as a choice.
Forum|alt.badge.img+6
  • AmberPollard
  • Registered
  • April 12, 2017
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!
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.
Forum|alt.badge.img+6
  • AmberPollard
  • Registered
  • April 12, 2017

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

Good to know, thank you!

Forum|alt.badge.img+3
Reopening this thread in case a solution has been reached in the last year.
  • AlbertoNava
  • Registered
  • December 20, 2018
is there a solution? i have the same problem of Amber!
Forum|alt.badge.img+11
  • hhersch
  • Quickbase Staff
  • December 28, 2018
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.
Terms & ConditionsAccessibility statement