Is Current User Filter with User-List field?

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
------------------------------

You would make a formula called [Current User in List user format] with the formula I provided.

then filter your report where

[Report(s) To]  Includes the User 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
------------------------------