Discussions

Expand all | Collapse all

Report showing where current user is part of group

  • 1.  Report showing where current user is part of group

    Posted 10 days ago
    I have some users assigned to teams that travel. Team 1, Team 2, etc. I was thinking I could put them into user groups. 

    Then, I want to create a report that filters only to show projects if the current user is part of the team assigned to a project. Any way to do this? I figure there must be someway for me to have a formula field that checks if the current user is part of the assigned team, but I can't figure out that formula.

    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: Report showing where current user is part of group

    Posted 10 days ago
    One Team has many Users.  Summary field to count # of Users subject to the filters that [User field] is the current user.

    If you like you can also make a checkbox field called [Current User is on Team]

    [# of users which are current user] >=1

    Then Lookup that checkbox field from Teams down to Projects. 




    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------