๏ผ. 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.
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!
Thank you!
Thanks for this neat trick! Will be using this in the near future ๐