Lookup from Child Table
Good Day! I have 4 tables that talk to each other. Project Table Will update the Supervisor that manages the Account.
This filters down and updates our Project Session Table with that sup...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendNo problem,
You have the Supervisor Userid on the Employee Assignments record.
Make a text formula text field called [Supervisor in Text format])
Go to the relationships and make a combined text summary field of that field up to Employees.
Make a formula userlist like this with as many parts as you like.
var text AllSups = ToText([Combined Text Supervisor in text format]);
var User SuperOne = ToUser(Trim(Part($AllSups,1, ";")));
var User SuperTwo = ToUser(Trim(Part($AllSups,2, ";")));
var User SuperThree = ToUser(Trim(Part($AllSups,3, ";")));
ToUserList($SuperOne, $SuperTwo, $SuperThree)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
You have the Supervisor Userid on the Employee Assignments record.
Make a text formula text field called [Supervisor in Text format])
Go to the relationships and make a combined text summary field of that field up to Employees.
Make a formula userlist like this with as many parts as you like.
var text AllSups = ToText([Combined Text Supervisor in text format]);
var User SuperOne = ToUser(Trim(Part($AllSups,1, ";")));
var User SuperTwo = ToUser(Trim(Part($AllSups,2, ";")));
var User SuperThree = ToUser(Trim(Part($AllSups,3, ";")));
ToUserList($SuperOne, $SuperTwo, $SuperThree)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thank you so much Mark! That worked beautifully!
------------------------------
Amber Anderson
------------------------------
------------------------------
Amber Anderson
------------------------------