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.
PowerTable stores your edits as pending changes until you commit them.
When you modify a cell:
Your changes aren't written to the Fabric SQL database until you select Save to Database. This behavior allows you to batch multiple edits into a single commit.
The Save Changes? prompt asks you to confirm that you want to commit all pending changes to the database.
If you select Don't show this again, PowerTable suppresses the confirmation dialog for future saves. Selecting Save to Database then commits the changes without prompting for confirmation.
After a successful commit:
Right-click the cell and select Clear Contents.
When you edit a single row, the Form Editor displays the existing values so that you can view and update the record.
When you edit multiple rows, the Form Editor updates only the fields that you modify. It leaves all other fields in each selected row unchanged. Multiple-row mode doesn't display existing values or allow you to clear a field.
The Offset Value action changes each row's existing value instead of replacing it with the same value.
You can use it to:
Because the action modifies each row's current value, the resulting value can differ from one row to another.
Yes. After you configure an action, select Add Action to add another one.
PowerTable applies all configured actions together when you select Apply.
Yes. Select Preview Changes to review pending changes across the following tabs:
You can then select one or more rows and choose Reset to revert only those pending changes.
No. Find and Replace searches only the column that you select in the Column dropdown.
If Match entire cell contents isn't selected, PowerTable replaces the matching text wherever it appears within a cell value instead of replacing only cells whose entire value matches the search text.
No. Replace All creates pending changes, just like other editing operations.
After you close the Find and Replace dialog, select Save to Database to commit the changes.
Choose the editing method based on the type of change that you want to make.
For example:
All five editing methods support Preview Changes and Discard Changes.
The Data tab records data changes, including insert, update, and delete operations. It also displays details such as:
The Access tab records changes to row-level and column-level access security settings.
