Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

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

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?

9 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.
  • AmberPollard's avatar
    AmberPollard
    Qrew Assistant Captain
    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.
  • AmberPollard's avatar
    AmberPollard
    Qrew Assistant Captain

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

    Good to know, thank you!

  • hhersch's avatar
    hhersch
    Qrew Captain
    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.
    • JoshuaCase's avatar
      JoshuaCase
      Qrew Cadet
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------