Forum Discussion
np
Just create a new table in your app. Perhaps Call it Admin Settings. Create a single record in the table and lock down anyone including you from adding another record. Obviously this will be record ID number one. Then make a relationship back to your details table where the report is and you can at least initially let the system create a field for you called related admin.
Then go to that field and change it to be a formula field with the value of 1 as the formula and change the field name to [link to admin settings].
Now go back to your admin settings table and make a User List Field and edit that Admin record to enter all the users which are excluded.
Then look that up down into your details table. Then add a filter and it should offer you the choice to exclude where that field does not contain the current user. I did not test if I would offer that current user filter but if that's a problem just post back and there's a workaround.
I think the field for users in a user list field is limited to 20. If you ever run out of slots then you just create a new field to create your second set and likewise look that up down to your details table and add it into the report filter
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------