Report Filtered By User On A Different Table
The primary table on my app is 'Events'. The Events table has a child table 'Positions', which joins to another parent table called 'Staff Members'. Essentially, the Positions table is a middle tabl...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThis can be done as ling as it is being done as a report filter and not actual Role Permissions.
You can make a summary field on the relationship between Events and Positions to count up the # of Positions where the current user is the User on the Position record. Call this perhhaps [# of Positions for this Event for Current User]. I suggest make a formula user field on the Position table called [Current User] with a formula of
User()
That is just in case the summary field does not let you match on the current user, then you will be sure you have a field to match to.
Then you can filter an Events Report on where [# of Positions for this Event for Current User] > 1.
As an aside, if you tried to control Role Permission access to Events using this technique it will not work as you cannot control access Role Permission access to parents based on children - it's too circular for Quick Base to handle.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
You can make a summary field on the relationship between Events and Positions to count up the # of Positions where the current user is the User on the Position record. Call this perhhaps [# of Positions for this Event for Current User]. I suggest make a formula user field on the Position table called [Current User] with a formula of
User()
That is just in case the summary field does not let you match on the current user, then you will be sure you have a field to match to.
Then you can filter an Events Report on where [# of Positions for this Event for Current User] > 1.
As an aside, if you tried to control Role Permission access to Events using this technique it will not work as you cannot control access Role Permission access to parents based on children - it's too circular for Quick Base to handle.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark,
You rock. Very creative solution, and it appears it did not actually require the formula user field to work properly; just fyi. Put that one on my bill! :)
------------------------------
Joe Hargrave
------------------------------
You rock. Very creative solution, and it appears it did not actually require the formula user field to work properly; just fyi. Put that one on my bill! :)
------------------------------
Joe Hargrave
------------------------------