Skip to main content
Question

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

  • May 27, 2021
  • 0 replies
  • 415 views

Forum|alt.badge.img+14
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
------------------------------

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • May 27, 2021
I think that is the way it do it as well.

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

Forum|alt.badge.img+2
  • Quickbase Alumni
  • December 10, 2024

Did you figure out a better way? I'm trying to do this now...


Forum|alt.badge.img+3
  • Quickbase Alumni
  • June 17, 2026

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