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
0
Search
1
Name
If you can see this, you are on the access list.
There are no rows in this table
Table 2
0
Search
Name
No results from filter
People
0
1
Name
Anonymous User
There are no rows in this table
Access List
0
Search
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.