Manage the rows in a table

Manage the rows in a table as described in the following sections:

Add a row
Edit a row
Copy the contents of a cell in a row
Duplicate a row
View row history and restore a row
Get a link to a row record
Clear row values
Delete a row

Add a row

To add a row:

Open the database in the database editor.
Select the table tab.
Do one of the following:
- To insert a row after the last row in the table:
  - Click + Add row to add an empty row
  - Click to open the Create row dialog, enter the row contents, and click Save.
- To insert a row above a row, right-click the row and select Insert row above
- To insert a row after the currently selected row, click Shift-Enter.

A blank row is added to the table.

Edit a row

Edit a row directly in the table or by opening the row in the record view.

You can copy and paste directly from Google Sheets or Google Docs into a table in the grid layout. You'll need to create identical column names and types in the AppSheet database table before copying the data. Any tab-separated content can be pasted across multiple columns within a table. Note the following:

Pasting data over Lookup column data types is not supported
Pasting values that do not match the options in a drop-down column results in the values being removed

To open the row in the record view:

Open the database in the database editor.
Select the table tab.
Right-click the row and select Open in record view.
The Edit Row from tablename dialog opens.
Edit the row details.
Click Save.

Copy the contents of a cell in a row

To copy the contents of a cell in a row:

Open the database in the database editor.
Select the table tab.
Right-click the cell that you want to copy and select Copy.
Right-click the cell where you want to paste the content and select Paste.

Duplicate a row

To duplicate a row:

Open the database in the database editor.
Select the table tab.
Right-click the row and select Duplicate row.

The row is added immediately after the copied row.

View row history and restore a row

See View the change history and restore changes.

Get the link to a row

Get the link to a row to share with collaborators.

To get the link to a row:

Open the database in the database editor.
Select the table tab.
Right-click the row and select Get link to this row.
Share the link with collaborators.

Clear row values

To clear the values within a row:

Open the database in the database editor.
Select the table tab.
Right-click in the row in the first (numeric) column of the row.
Select Clear row values.

Delete a row

To delete a row:

Open the database in the database editor.
Select the table tab.
Right-click the row and select Delete.

Was this helpful?

How can we improve it?