Control add, update, and delete operations

You control whether app users can Add, Delete, or Edit rows in a table. You can specify combinations of these options for each table in the Data > Tables tab of the app editor.

Are updates allowed? field enabling you to select Updates, Adds, Deletes, or Read-only, or click the flask icon to define an expression

Separate permissions can be chosen for table slices (Data > Slices tab), but they must be at least as strict as the permissions of the original table.

In advanced scenarios, you can use an expression to dynamically compute the update mode. Click on the flask icon to set up the expression. There are two common use cases for dynamic update modes:

  1. To allow some users to make updates but restrict this functionality for others
  2. To allow updates for some rows but restrict updates for other rows

The following are the allowed values when using expressions: ALL_CHANGES, ADDS_ONLYADDS_AND_UPDATESADDS_AND_DELETES,  ​​​​​​​UPDATES_ONLY, UPDATES_AND_DELETES, ​​​​​​​​​​​​​​DELETES_ONLY, and READ_ONLY

For example, allows user1@mydomain.com to update content and allows all other users read-only access.

SWITCH(USEREMAIL(), 
  "user1@mydomain.com", "UPDATES_ONLY", 
  "READ_ONLY")

Allow Adds but do not show existing rows

In some apps (like public apps that are used to collect data from anonymous users), you may want to capture new data (that is, allow Adds) but not show any existing data. There is a convenient Hide Existing Rows option to set this up. You can find this option in the Security section of the Table definition (Data > Tables tab). If you enable this option for a table, none of the existing rows are read.

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false