The Little Guide to User Controls

When developing apps, there are certain actions that you want your User to be able to take. These User Controls are enabled/disabled in a number of different places in the AppSheet editor, depending on the action, the type of view & data and the permissions for the table where the data is stored.

This guide will be updated from time to time.

If you think something should be added to this list, let me know in the AppSheet User Community by tagging your post with “+oscar baruffa”.

If you want to be notified of major updates to this list, please sign up to the StepSheet newsletter.

I want my User to Add a record to a table

Go to Data > Tables and in “Are updates allowed?” drop-down menu select the relevant choice for the table, but it must have one of the “ADDS_…” or “ALL CHANGES” options selected.

add_records2

Now Users will be able to add new records to the table.

add_record_

I want my User to Edit a record

Go to Data > Tables and in “Are updates allowed?” drop-down menu select the relevant choice for the table, but it must have one of the “UPDATES…” or “ALL_CHANGES” options selected.

edit2

Now Users will be able to edit existing records in the table. In this example, the “Arches, Utah” entry was selected and now that row of data can be edited by clicking the pencil icon.

edit1

 

Is there a column entry that’s greyed-out and the User can’t edit it, even though you’ve set the Table to have one of the “UPDATE” options or the “ALL_CHANGES” option?

edit3

If so, then there’s some other restriction in that column. Most likely that column is either set a Key (that is, a unique identifier) or it is “Read Only” – both of which mean the User cannot edit it, even if the tables allows updates. To change that, you will need to specificity a new Key column or remove the Read Only restriction.

Go to Data > Column Structure and then for the Table in question, select “Show” to see the properties. In this example, the Name column that’s been greyed-out is set as a Key column. If you want Users to edit it, then you will need to select (or ideally create) a new column that can be be used to uniquely identify the record. If you un-tick this, AppSheet may restrict you from doing so until a new, suitable column is created or it may do its best to create an alternative.

edit4

I want my User to Delete a record

Go to Data > Tables and in “Are updates allowed?” drop-down menu select the relevant choice for the table, but it must have one of the “…_DELETES” or “ALL CHANGES” options selected.

delete1

Now Users will be able to delete existing records from the table. In this example, the “Badlands, South Dakota” entry was selected and now that row of data can be delete by clicking the trash icon.

delete2

Sign up to the StepSheet blog newsletter and be notified when new resources are released!
* = required field