Is Current User Filter with User-List field?
Is it possible to create "Is Current User" report filter using a user-List field? ------------------------------ Christine White ------------------------------
Forum Discussion
Hi Michael,
The function User() returns the current user.
But Quick Base does not like comparing apples to oranges in a report filter and to Quick Base, a field of type List User cannot be compared with a field of type User in a report filter. So if the report does not natively offer up to company to "the current user", then a work around is to create a List User formula field which just has the current user in it, ie just 1 user ecven though it is a List User field type.
So to make that field we use
ToUserlist (User())
and call it like [Current User in List User format]
Then the report will be filtered where
[Project Managers] include the value in the field [Current User in List User format]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
The function User() returns the current user.
But Quick Base does not like comparing apples to oranges in a report filter and to Quick Base, a field of type List User cannot be compared with a field of type User in a report filter. So if the report does not natively offer up to company to "the current user", then a work around is to create a List User formula field which just has the current user in it, ie just 1 user ecven though it is a List User field type.
So to make that field we use
ToUserlist (User())
and call it like [Current User in List User format]
Then the report will be filtered where
[Project Managers] include the value in the field [Current User in List User format]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Hi Mark,
When there is only a single entry, this works for me, but if there are multiple people, it can't detect the current user that is listed. Any idea why?
------------------------------
Michael Naser
------------------------------
Michael,
can you post your formulas and screenshots of your report filter?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
