Discussions

Expand all | Collapse all

Filter report where Current User <> Me

David Knight08-10-2017 19:28

  • 1.  Filter report where Current User <> Me

    Posted 08-10-2017 19:28
    Filter report [Assigned to] <> Current User


  • 2.  RE: Filter report where Current User <> Me

    Top
    Contributor
    Posted 08-10-2017 19:36
    I don't think that is an option, but you could make a formula checkbox with the same logic, and then use that as a filter (or even a dynamic filter).


  • 3.  RE: Filter report where Current User <> Me

    Posted 08-10-2017 19:41
    Or make a formula user field called Current User with a formula of

    User()

    and filter against that field


  • 4.  RE: Filter report where Current User <> Me

    Posted 08-10-2017 20:02
    Thank you both. The Current User with formula did the trick.


  • 5.  RE: Filter report where Current User <> Me

    Posted 03-02-2018 21:33
    I"m not sure how that the current user formula field is supposed to filter a report.  How do you filter based on current user with nothing but a formula field that gives you the current user?


  • 6.  RE: Filter report where Current User <> Me

    Posted 03-02-2018 22:44
    You compare current user to another field in your table.

    For example where [record owner] equals current user.

    That would be a report of records that I created.


  • 7.  RE: Filter report where Current User <> Me

    Posted 03-03-2018 18:18
    I have reports where when some user field equals current user to create reports.  What I am trying to do is create a filter on a report for current user.  So that a user could go to say a table homepage report, use the current user filter and they would see their items.


  • 8.  RE: Filter report where Current User <> Me

    Posted 03-03-2018 20:41
    If you want to have a Dynamic Filter for where a User field on records is equal to the Current User, just make a formula checkbox field

    [My User field] = User()

    Then use that as a Dynamic Filter.


  • 9.  RE: Filter report where Current User <> Me

    Posted 03-05-2018 13:58
    Thanks.  Can a formula checkbox field have an IF formula?   Say if I have more than 1 field that I want to check is the current user?   In my scenario I have 2 user list fields, assigned to, and reported by.  I want to check if either field is the current user. 

    I'm trying to make it easier for people to find their items without having to go to a specific "my items" report. 


  • 10.  RE: Filter report where Current User <> Me

    Posted 03-05-2018 14:03
    An IF statement can be as simple or as complex as  you like. If you are able to express what you want in plain words, then there is always a way to get to the syntax for the formula.


    for example

    IF(
    [assigned to]  = User(), true,
    [reported by]  = User(), true)

    That will be true of either of the above are true.

    Mark


  • 11.  RE: Filter report where Current User <> Me

    Posted 03-05-2018 14:08
    Thanks Mark,

    I thought maybe I had missed something because I tried this, and was getting errors.
    Mine are userlist fields and says cannot be used with User()

    "The expression [Assigned To] on the left hand side of the operator "=" is of type userlist while the expression User() on the right hand side is of type user. The operator "=" cannot be used with these types of expressions.


  • 12.  RE: Filter report where Current User <> Me

    Posted 03-05-2018 14:11
    OK, I did not know they were userlist field types.

    Try this

    IF(
    Includes([assigned to], ToUserlist(User())), true,
    Includes([reported by], ToUserlist(User())))


  • 13.  RE: Filter report where Current User <> Me

    Posted 03-05-2018 14:15
    Awesome! Thanks Mark.  I always forget the ToUserlist...  Remembering formulas is not my strong suite.   That worked.  Thank you.