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.
- To insert a row after the last row in the table:
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.