Sign in to submit new ideas and vote
Get Started

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

Trish Dillon
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.

1 votes

Idea Submitted · Last Updated


  • Genevieve P.
    Genevieve P. Employee Admin

    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).