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.Value columns- the columns that can be updated with new values.
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.
The next phase is to add an action button to the table.
The action button maps a row's column value to variables used in the update action.A column mapping can look like this.
When a user clicks the update button in the table, the values in the row are mapped to the variables according to the above mapping definitions.
Input Form
The input form allows users to update the column values by presenting them in atomic input forms according to the variables' values.
Writeback Upate Action
The writeback update action is where the definitions that need to be updated are set.
These are the settings in the action block
Update- The target table that will be updated.
Columns- The columns that are going to be updated
Values- The updated values for each column. It's essential to make sure the list is ordered according to the fields' order in the columns cell
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