Choose Whether Users Can Insert, Update or Delete Rows

Prev Next

In the Settings tab of the SQL Spreads Designer, you decide for each table whether users can delete rows, insert new rows, or only add new rows. The settings are saved in the Excel document, so they apply wherever you share it.

The Settings tab in the SQL Spreads Designer, with Allow delete rows, Allow insert new rows and Only allow inserting new rows

You find the Designer Setting in the right most Settings tab in the SQL Spreads Designer.

Allow Delete Rows

Uncheck the Allow Delete Rows to prevent users from being able to delete rows in the table.

Allow Insert new rows

Uncheck the Allow Insert new rows to prevent users from being able to insert new rows in the table.

Only allow inserting new rows

To only allow users to insert new rows, check the Only allow inserting new rows checkbox.

This setting will clear the spreadsheet after new rows have been saved to the database, and will prevent users from modifying or deleting any existing rows in the table.

Related settings

To lock single columns, hide them, or set them to read-only in Setting up your columns. To decide which rows each user sees, see the fixed setup in Filtering rows, or Row-wise user access for a user access table. For an overview of both roles, see The Designer and Data Editor roles.