Howdy, I have Tables for Clubs, Members & Meetings. Need help with Security Filters.
I need to restrict Meetings Table to only display Meetings for the Club the Member/User is in.
I also need to restrict Members Table to only display Members who are in the same Club as the User/Member.
Thank you very much!!
How are the tables related?
Since you like the Visual explanation Steve, I’ll add this image in case I don’t explain it correctly. In fact, I’ve already screwed up my question above, sorry. The Clubs Table is not even added to the App yet. When I get this, I’ll be able to use same formula in Clubs Table.
So currently, I just have Meetings Table and Members Table. Members just have a [Club] column. In Meetings Table, I have Roles like President, Time Keeper, Greeter, etc that are each Ref’d to Members Table.
And I have a Meetings Slice set up, but I’m not sure that I need it. Sorry to confuse!
I would make use of a Current_User (Slice), then use that in your slice as the criteria.
[User_Club] = any(current_User[User_Club])
something like that.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |