Restrict Editing Access in HS BC Table Based on User Manager Table

AppSheet AppSheet Q&A
1

I have two tables in Google AppSheet:

  1. User Manager: Contains user ID, name, station, role, etc.
  2. HS BC: Contains HSL and BSL columns with values matching User Manager’s station column.

How can I restrict editing access to specific rows in the HS BC table, allowing only users with matching stations (from User Manager) to edit corresponding rows?"

2

Add column email on the User manager, then LOOKUP the USEREMAIL with the matching role, put the formula on the EDITABLE.

ex: LOOKUP(USEREMAIL(),“user_role”,“Email”,“Role”)

3

In the Only if this condition is true setting for the Edit action of the HS BC table, try something like this:

IN([Station ID], SELECT(User Manager[Station ID], (USEREMAIL() = [Email])))