Gallery
Share
Explore

How to Use

The People table represents a list of employee names. It should auto-populate your name in Row 1.
The Access List table shows a list of tables and access for people can be added or removed in the column Access List.
Based on your changes in step 2, Table 1 and Table 2 should update to either show “No results from filter” or “If you can see this, you are on the access list.”
The formula to add to tables to use this access control is:
IF([Access List].filter(Name.containstext("TABLE NAME", true, true)).[Access List].totext().containstext(User().Name), RowID(thisRow)>0, RowID(thisRow)=0)
Table 1
1
Name
If you can see this, you are on the access list.
There are no rows in this table
⁠
Table 2
Name
No results from filter
⁠
People
1
Name
Anonymous User
There are no rows in this table
⁠
Access List
1
2
Name
Access List
Table 1
Anonymous User
Table 2
​
There are no rows in this table
⁠


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.