Powertable provides multiple ways to add, import, copy, duplicate, and delete rows in a table. You can insert rows manually, import data from external files, duplicate existing records, or remove records as needed.
Powertable provides the following row management capabilities:
In this article, you learn how to insert, import, copy, duplicate, and delete rows in a powertable sheet.
Use the Insert Row option to manually add new rows to a table.
Use the Import option to insert or update rows by using data from an external file.
To insert a single row:
Select PowerTable > Insert Row.
A new blank row is added as the last row in the table.
Select each cell, enter a value, and press Enter.
After inserting the required row(s) and entering the data, select Save to Database to save the changes.
You can use Preview Changes to review the changes before saving or Discard Changes to remove the unsaved row(s).
To insert multiple rows:
Select Insert Multiple Rows.
Select Insert.
The specified number of rows is added to the table.
You can use Preview Changes to review the changes before saving or Discard Changes to remove the unsaved row(s).
You can also configure the form interface as the default method for adding rows.
To set up the insert using a form interface:
Select the dropdown next to PowerTable > Insert Row.
Enable the Insert Using Form By Default toggle.
Now when you select Insert Row, a new row is inserted, and the Form Editor opens automatically.
Use Customize Form to change the form fields and structure. The Form configuration interface lets you to add, edit, delete, and format form fields.
The new row is inserted into the table.
New rows can also be added using shareable PowerTable forms distributed via email or embedded in websites. When users submit a form, the submitted values are inserted as new records in the table.
For information about creating and sharing forms, see Create data entry forms.
PowerTable forms only support creating new records. Updating existing records through forms is not supported.
You can also import bulk data from Excel or CSV files to add new rows or update existing rows.
When you import data, PowerTable compares the primary key values in the imported file with the existing records in the table.
To import data:
Select PowerTable > Import.
The Import dialog box appears. Select the Excel or CSV option to specify the format of the file and then select Continue.
Browse or drop the file in the selected format and select Upload.
Review the uploaded data and the count of rows marked for insert and update operations, and then select Import. Any import errors, such as data type mismatches, are displayed under the Error tab.
The table is updated with the newly inserted rows and the modified values from the imported data.
You can populate a PowerTable sheet by copying rows from external applications, such as Microsoft Excel, and pasting them directly into the table. This is another way to add or update data, instead of an import, especially when there are only a few rows to insert.
The data is now imported from Excel to the PowerTable sheet using the copy-paste method.
You can also copy data from a PowerTable sheet and paste it into external applications such as Microsoft Excel, Word, or Notepad for further analysis, reporting, or sharing.
To copy rows:
Paste the data in the required application(s).
Duplicate existing records and then modify only the required fields.
To duplicate rows:
Select Duplicate option on the toolbar.
The selected rows are duplicated. Now, you can update the required fields.
Unique primary key values must be updated after duplication because the original primary key values are copied to the new records.
Delete one or more rows from a table.
To delete rows:
The selected rows are deleted.
Depending on the delete type configuration, rows are either soft-deleted or permanently deleted. To know more, see delete type in the delete section.
