Vizlib Writeback Table has a Writeback Settings menu to make changes to your writeback configuration quick and easy to manage. These settings are found in the right hand panel of the Writeback Table Editor (Figure 1), below the Columns menu.
Figure 1: Writeback Settings
There are 4 sections for Writeback settings.
- Destination contains configuration settings for writeback data output and writeback operations.
- Audit Trail contains settings to enable and customise an audit trail.
- Table Settings manages the formatting of the output table.
- Reload settings configure when writeback operations are performed.
In this article we're going to focus on the properties for the Audit Trail, Table Settings and Reload sections. If you need further information on the Destination section, you can find a link to the article here.
If you would like to build up a record of the changes you make to your writeback table, you can use the Audit Trail section to set this up. There is a Standard audit trail set as the default (Figure 2), or you can choose None to disable the function completely.
You can select the Timestamp format which you'd like to use from the dropdown, or use the Qlik Sense expression editor to customise the Timestamp label and User label.
Figure 2: Audit Trail
You can choose to customise the Timestamp format of your audit trail, by selecting the Custom option from the dropdown. The Timestamp custom format will be displayed, and you can use the Qlik Sense expression editor to enter the format you need. (Figure 2).
Figure 3: Audit Trail Custom
The Table Settings section (Figure 4) lets you set the Page size for the table.
The Show confirm dialog? dropdown adds a check to any actions requiring a full and/or locked data set. This setting is applied by clicking the Lock icon next to the Writeback data button, please see the data lock article for more details.
- No warnings - No dialog shown.
- Both - Show a dialog for locked and full data set.
- Lock data set - Show a dialog for locked data set.
- Full data set - Show a dialog for full data set.
Figure 4: Table Settings
The Allowed Row Actions setting controls permissions for deleting, adding or duplicating rows (Figure 5). If a 0 is added in the expression text box, the permission is granted, so in this example adding rows is permitted, but deleting or duplicating rows is not.
Figure 5: Allowed Row Actions
You can check these settings by right-clicking on the writeback table in Analysis mode (i.e. closed for editing). This will display the list of available row actions. Figure 6 shows an example where add, delete and duplicate are all permitted.
Figure 6: Allowed Actions List
The Reload section (Figure 7) contains settings relating to when a reload action is performed on the writeback table. You can choose from
- No reload - No reload when writeback is called.
- Reload app (default) - The app is reloaded when writeback is called, overwriting any existing data. A potential use case would be before generating the latest version of a report.
- Partial App Reload - The app is partially reloaded when writeback is called, so new values are added without overwriting any existing values. A potential use case would be for refreshing or reloading data in dashboards. If you'd like to learn more about partial reload functionality, please see the article here.
Figure 7: Reload