I have a field that auto-fills the associate to "current user." I am looking for an additional formula field that will auto-fill with their "title."

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I would also like a formula field that would auto-fill with their manager's name. Can you help me to write these formulas?

Photo of Becky

Becky

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Becky

Becky

  • 0 Points
I have started a formula that works, but so far for only one user. I would need the formula to work for all users.
Here is what I have that works:
If([Associate Name]=ToUser("name@domain.com"),("role title"))
I need to be able to do this for each associate. Can it be done in one formula?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
It sounds like a brute force solution which would be better done though a tavble lookup, but you can do

Case([Associate Name],

ToUser("name@domain.com"), "role title",

ToUser("othername@domain.com"), "role title2",

ToUser("YetOtherName@domain.com"), "role title3")
Photo of Becky

Becky

  • 0 Points
THANK YOU to the QB Gods!