Hello,I have a table called Team Members which is all of my users in the app. The key field is the user field. I use this to keep other fields related to each user and one of them is their Team Name (each individual in our company works on a Team/design studio)We also have a few people that handle spillover if any team is too busy. So they float between teams to assist with work.I am trying to make a dashboard widget to show overdue tasks for a team lead so that they can see all overdue tasks on their team. I am using Mark's method for the Current User is on a team = 1 flag, but that doesnt work in this case as I am trying to get the "task" if it is on a team. Not a user.So what I need in my report is basically the ability to sayIf a task team name matches the current user team name show it on this report.Ideas?------------------------------Ivan Weiss------------------------------

:) just cooling off after a hot rollerblade, so back on line.If you make a field called [Current User] on tasks, then you can make a relationship back to Team Members and lookup the current User Team Name and then the filter the report where task team name matches the current user team name------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Hmm I think I am missing something.I made a field on the Tasks table called Current User as a formula user type. In the formula I put User()I created a relationship to my team members table. I set the default value to current user. As part of that relationship I looked up the team name. I renamed this relationship to Current User Team MemberI am not sure where I am supposed to be using that Current User field. I also added a lookup from Tasks to the Project table for the Team Name field. This way I have the team name for the Project.My reports are filtering by: Project Team Name is equal to the value in the field Current User Team Name AND Project Team Name is not equal to ""With testing it is not working so something is not quite right with the above.------------------------------Ivan Weiss------------------------------

It should work. When you look at an example task record what's in fields you are comparing?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

I through some fields on a report so I can see what is going on and it is The Current User Team Name that is the issue, it is blank. I checked the relationship and it is not determining who the current user is so that is the problem.How do I get the relationship between Tasks and Team Members to auto change based on the current user? This way I can pull back down the team members name------------------------------Ivan Weiss------------------------------

1. Are you in the Team Members Table?2. What do you see in an example record for the field [current user] on tasks.3. Is the user ID in the team members table the same as what you see in the current user field in tasks?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Get a field based on the current user

MarkShnier__You
Qrew Legend
5 years ago
:) just cooling off after a hot rollerblade, so back on line.
If you make a field called [Current User] on tasks, then you can make a relationship back to Team Members and lookup the current User Team Name and then the filter the report where

task team name matches the current user team name

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- IvanWeiss
  Qrew Captain
  5 years ago
  Hmm I think I am missing something.
  
  I made a field on the Tasks table called Current User as a formula user type. In the formula I put User()
  
  I created a relationship to my team members table. I set the default value to current user. As part of that relationship I looked up the team name. I renamed this relationship to Current User Team Member
  
  I am not sure where I am supposed to be using that Current User field. I also added a lookup from Tasks to the Project table for the Team Name field. This way I have the team name for the Project.
  
  My reports are filtering by:
  Project Team Name is equal to the value in the field Current User Team Name AND
  Project Team Name is not equal to ""
  
  With testing it is not working so something is not quite right with the above.
  
  ------------------------------
  Ivan Weiss
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years ago
    It should work. When you look at an example task record what's in fields you are comparing?
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
ChristineWhite
Qrew Assistant Captain
5 years ago
Can you tell me where you found "Mark's method for the Current User is on a team = 1 flag" I am trying to do something similar

------------------------------
Christine White
------------------------------
- MarkShnier__You
  Qrew Legend
  5 years ago
  Hi Christine,
  If you post a new question and reference this one I will watch for it.
  
  ------------------------------
  Mark Shnier (YQC)
  Quick Base Solution Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  mark.shnier@gmail.com
  ------------------------------
  - ChristineWhite
    Qrew Assistant Captain
    5 years ago
    Thank you, I think I found it: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=31230&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer

Forum Discussion

Get a field based on the current user

Related Content

Color Code Date Field based on Formula

Snapshot Fields

Pulling A date from anther form based on a text field name

Consolidate Field Types

Pipeline trigger(s) based on formula field changes