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.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 08-06-2020 09:12
From: Michael Sargent
Subject: Is Current User Filter with User-List field?
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
Original Message:
Sent: 08-02-2020 20:24
From: Mark Shnier (YQC)
Subject: Is Current User Filter with User-List field?
The easiest way is to create a formula list user field
ToUserList(User())
and use that in the filter
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
Original Message:
Sent: 08-02-2020 20:10
From: Christine White
Subject: 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
------------------------------