Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago

Is there a better way? Report filter where user list includes current user

The way I solve the following issue, doesn't feel like the best way. It seems like there should be a simpler solution.

On my reports, often have scenarios where I have a user list field, and simply want a filter:

If the [User List] includes the current user.

This is not an option, so I end up making a formula list user field, that is: Touserlist(User())

Then my filter is: If the [User List] includes the users in the field [Current User List].

Is there an easier way?

------------------------------
Mike Tamoush
------------------------------

6 Replies

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      Actually I take that back.  There is a native option to filter on specific users and the first one listed is <the current user>

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      [email protected]
      ------------------------------
      • QuickBase_Admi1's avatar
        QuickBase_Admi1
        Qrew Trainee

        Hi Mark - this doesn't appear to be an option when the field is a list-user field

  • hiker85's avatar
    hiker85
    Qrew Trainee

    I had a parent table where users needed to view records where they were listed in a Combined User summary field.

    In the user role permissions I added a view filter where [the Combined User summary field] includes, then typed 

    _curuser_

    in the text box. So far this is working for me