Managing CRUD of data tables with AppSheet

[okutani_hayato]

I was troubled.

What is the best way to give user permissions to each table.
And I was able to do it with a very simple procedure.

How to achieve this

1. Create the user table and table name table.
2. Create the table CRUD setting table. 3.
3. table CRUD setting table has only table_name(Ref), user_id(Ref), crud_setting(Enum: READ_ONLY etc…) columns only.

４. Register the data. Since there are so many table names, it is better to write them directly in the spreadsheet at first.

5. Finally, go to data-> tables and set the following functions to “Are updates allowed?” in each table.

LOOKUP(CONCATENATE({tableName},": ",USEREMAIL()),"table_crud_settings","id","crud_setting")

This is the image on AppSheet.

You can immediately change the user’s permissions by changing crud_setting.

Sample Application

For a more user-friendly view, you can create YES/NO for Add, Delete, Update, and set the CRUD statement as a condition to make it easier to use.

Thanks for reading.

Have a good AppSheet life!

[Joseph_Seddik]

Thank you!

[anonymous]

Thanks for this neat trick! Will be using this in the near future