Controlled data: Create Rows but not Edit OR Edit Rows but not Create

Trish Dillon

prevent accidental edits and maintain data integrity by allow users to create but not edit fields. or to stop duplicate fields from being created, grant users the ability to edit but stop them from creating new ones.

Genevieve P.

Hi @Trish Dillon

You can achieve the first permission setting by giving your users either View only or Commenter access to the sheet. Then you can provide them with a Form to insert new rows into the sheet, but be unable to edit them afterwards. I've personally done this where the Form is embedded on a Dashboard right next to a view of the sheet so they can see both at one time.

For the second permission setting, edit fields but not create rows, this can be achieved by either using the add-on Dynamic View, or a shared Report in a Workapp (depending on your plan type).

Cheers,

Genevieve