Forum Discussion

NatasaNedeljkov's avatar
NatasaNedeljkov
Qrew Member
5 years ago

Grouping users into groups and filtering based on group

Hi, 
I have an requirement to filter data based on user groups.
Initially we set up our filtering based on current user.
if Assignee equal to current user, show that report.

We now want to set up groups (multiple Users), and if Assignee (Group?) is equal to current user's group, show that report.  

Thank you.

------------------------------
Natasa Nedeljkovic
------------------------------
reports and charts
roles and permissions
  • OanaWhalen's avatar
    OanaWhalen
    Qrew Cadet
    5 years ago
    Natasa,

    If you don't already have one, set up a table for User Groups. Make the key field be the user and have a dropdown (text - multiple choice) field with the various groups (can be a parent table or just a pre-defined list in a field). Now in your Assignments table, create a Formula - User field called Current User with the formula just being User(). This will pull the current user value for whoever is logged in. Now you can do a lookup from your User Groups table to pull the user's assigned group down to the Assignments table as a Current User Group field. Use this field to compare against the Assignee Group field for your report filtering.

    ------------------------------
    Oana Toma
    ------------------------------