Introduction
Writeback features in Astrato help users convert analytic apps into data apps, where they can perform interactive actions such as adding context to apps, creating new data assets, and enriching existing data assets.
The new update action allows users to update existing records in the tables. It simplifies complex what-if scenario editing, adjusting targets, and more.
Table Settings
Before an update action can be performed, A table visualization in Astrato is needed. The table visualization should include all the columns required for the update. There are two types of columns:
Key columns- the columns that will be used to identify the record that needs to be updated.
The combination of all the key column values in a row should be unique to ensure only the relevant record is updated.Editable columns- the columns that can be updated with new values.
Key Columns
Designating a column as a key column is simple: click on the three-dot menu on the right side of the field chip and select the option "Mark as key column."
Below is an example of a table with two columns defined as key columns.
Editable ColumnsEditable columns are those in which the user can edit their values and trigger an update.
When a cell is edited and approved, an update will be triggered.
A column is editable
Writeback Update Action
The writeback update action is where the definitions that need to be updated are set.
The trigger for an update is a change in the feedback_editing table.
These are the settings in the action block
Toast message- (optional) indicates to the user that an update is in progress.
Update- The target table that will be updated.
Columns- The columns that were changed by the user (Astrato automatically picks them up)
Values- The new values from the columns that changed
Key columns- The column that will be used to identify the record to
update.
Key values- The values on the key columns.
Updated by (optional) - if the table includes this column
Updated at (optional)- will be used to track changes for records
Toast message- (optional) indicates to the user that the update is complete.