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
Mark, that doesn't seem work. I have an existing List-User field with a list of project managers to whom an individual record may be assigned. I want to do the same thing as the other person, whereby I'm trying to have the report show a chart for only those projects assigned to the current user (current user = user selected in List-User field). The formula ToUserList(User([existing list-user field])) throws an error 'the field is not compatible with the parameter field type'. The report seemed to suggest i was able to display results for the current user in that field, but no results came back even though other conditions were met. Thoughts?
------------------------------
Michael Sargent
------------------------------
------------------------------
Michael Sargent
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendHi 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
------------------------------- MarkShnier__You
Michael,
can you post your formulas and screenshots of your report filter?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
