Powertable sheet allows you to edit and update the database directly from the table interface. Changes made to records are synced with the source in real time, enabling you to maintain accurate and up-to-date data.
Powertable provides the following editing and bulk editing capabilities:
Bulk editing in powertable helps maintain data consistency and reduces the time and effort required for repetitive data updates.
In this article, you learn how to edit individual records as well as perform bulk edits in powertable sheets.
To edit data directly in a table:
The Preview Changes window displays all pending changes, including added, updated, and deleted records.
You can also edit a row using the form interface.
To edit a row using a form:
Many applications allow only single-row operations, such as inserting, updating, or deleting one row at a time. Powertable sheet provides the bulk-edit feature that enables you to edit or delete common attributes across multiple records simultaneously.
To edit multiple cells:
Under Action,
For text fields, choose Append Value to add text before or after the existing value using Prefix or Suffix.
In this example below, the ProductSKU field is appended with the specified suffix.
For number fields, select Offset Value to increase, decrease, multiply, or divide the existing numeric value by a specified offset.
In this example, the ProductPrice field is multiplied by two for the selected rows.
Select Add Action to configure additional field updates, and then select Apply after configuring all required actions.
You can also perform bulk edits by using the form interface. This method allows you to update multiple fields across the selected rows at the same time.
Forms allow you to quickly edit multiple field attributes all at once. In Bulk Edit, you need to select Add Action for each field you want to change.
To perform a bulk edit using a form:
Select Apply to update the selected rows.
The values in the ModelName and ProductColor fields are updated to Racing Socks and Yellow, respectively.
Use Find and Replace to quickly locate specific values in a table and replace them with new values. This feature is useful when you need to update recurring values across multiple records.
To find and replace values:
Select Find and Replace option above the table.
The Find and Replace window opens, as shown below.
Optionally, select a specific column from the Column dropdown. To search across all columns, keep the default selection, All.
Select:
In the Replace With box, enter the replacement value.
Select Find All to view all matching results.
Use Find Next or Find Previous to navigate through the matching records.
Select Replace to replace the currently selected match, or Replace All to replace all matching values.
After the replacement is complete, the modified cells are highlighted. Select Save to Database to save the changes, Preview Changes to review them, or Discard Changes to revert them.
Use the Column dropdown to limit the search to a specific column and reduce the number of matching results.
Select the History tab in the form editor panel to view the history of changes made to the selected records. The history includes information about the type of change, the row and column names that changed, who made the change, when it was made, and the values that were modified.
The same information is also available in Audit Logs, which provide more detailed tracking information.
Filter logs by using the available filtering options:
Use All Users to view changes made by specific users.
Select a time range to view logs within a specific period.
Use the Filter pane to filter logs by Action, Approved By, Modified Column, and Transaction ID.
In addition to viewing and tracking the history of changes, you can export them by using the Export option. Audit logs are exported in Excel (.xlsx) format.
To export the change history for the selected rows:
Select History > Export.
The Export Audit Logs panel opens, where you can configure the export settings.
Choose the time period from which you want to export the logs. By default, Last 30 Days is selected. You can also select Custom Date Range from the dropdown list and specify the required start and end dates.
After the file link is generated, right-click the link and save it to your local system.
