Discussions

Expand all | Collapse all

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

  • 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.