Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 years ago

Help on a report filtering data based on a "Team"

I have an app with a structure where I have Tasks related to Team Members (A Team member can have many tasks). In this same App Team Members is related to Departments (A Department can have many team...
Relationships
AdamKeever1's avatar
AdamKeever1
Qrew Commander
6 years ago
You need to add that field as a lookup in your relationship. Then you can use it in the dynamic filters. Here is an example where[ID - Workstreams] is a lookup field that is used as a dynamic filter:





------------------------------
Adam Keever
------------------------------
  • IvanWeiss's avatar
    IvanWeiss
    Qrew Captain
    6 years ago
    Adam,

    I can see the Team name of the Assigned To user via lookups.  How do I gain access to the Team name of the current logged in user dynamically?  That is the part I cannot sort out

    ------------------------------
    Ivan Weiss
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      Ivan, do you have a table of users where the Key field is User?  If you have that then there is a way to do what you want.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      markshnier2@gmail.com
      ------------------------------
      • IvanWeiss's avatar
        IvanWeiss
        Qrew Captain
        6 years ago
        Yes my "Team Members" table has the user as the key field.  It is basically an Employees table

        ------------------------------
        Ivan Weiss
        ------------------------------