Populate based on Current User
I have multiple tables in my application. Listing the ones that are related to my query. Team, Owners, Calendar Entries and Staff table. The Staff table is nothing but a list of all staff members...
Forum Discussion
Ok, here goes. It's not that difficult.
Make a formula numeric field on the Owners table called [I am the current user (=1)]
Make the formula to be
IF([userid]=user(),1,0)
It will calculate to 1 if true.
Make a summary field for the maximum of that field up to the Team table. Call it
[I am the on this Team (=1)]
It will be 1 io I (the current user) is on this Team.
Lookup the field
[I am the on this Team (=1)]
down the Calendar entries table.
You can now filter your Calendar report where that field =1, or use it as a Dynamic filter if you make a new formula text field yes no type field called [My Team?] with an IF formula.
Make a formula numeric field on the Owners table called [I am the current user (=1)]
Make the formula to be
IF([userid]=user(),1,0)
It will calculate to 1 if true.
Make a summary field for the maximum of that field up to the Team table. Call it
[I am the on this Team (=1)]
It will be 1 io I (the current user) is on this Team.
Lookup the field
[I am the on this Team (=1)]
down the Calendar entries table.
You can now filter your Calendar report where that field =1, or use it as a Dynamic filter if you make a new formula text field yes no type field called [My Team?] with an IF formula.