Discussions

 View Only
  • 1.  I want to make my user-list field a dynamic filter

    Posted 01-11-2017 21:17
    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?


  • 2.  RE: I want to make my user-list field a dynamic filter

    Posted 01-11-2017 21:30
    Try making a new field of type Formula-Text
    ToText(My List-User field])

    and see if that will be offered as a choice.


  • 3.  RE: I want to make my user-list field a dynamic filter

    Posted 04-11-2017 22:03
    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!


  • 4.  RE: I want to make my user-list field a dynamic filter

    Posted 04-12-2017 11:08
    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.


  • 5.  RE: I want to make my user-list field a dynamic filter

    Posted 04-12-2017 16:37

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

    Good to know, thank you!



  • 6.  RE: I want to make my user-list field a dynamic filter

    Posted 09-14-2018 18:02
    Reopening this thread in case a solution has been reached in the last year.


  • 7.  RE: I want to make my user-list field a dynamic filter

    Posted 12-20-2018 09:00
    is there a solution? i have the same problem of Amber!


  • 8.  RE: I want to make my user-list field a dynamic filter

    Posted 12-28-2018 16:24
    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.


  • 9.  RE: I want to make my user-list field a dynamic filter

    Posted 07-02-2020 12:44
    Is this resolved or figured out.  Using the new table view that is available to all and on a User-List field I cannot filter or search for two names at the same time.....

    ------------------------------
    Joshua Case
    ------------------------------



  • 10.  RE: I want to make my user-list field a dynamic filter

    Posted 07-02-2020 13:42
    I'm not an American but consider this as a July 4th gift from Canada.

    Multi select formula field.

    var text SemiDelimitedNames = UserListToNames([Specifiers in List User format]);
    Split($SemiDelimitedNames)

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------