has a Writeback Settings menu to make changes to your writeback configuration quick to action 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 Reload section (Figure 5) 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 - App is reloaded when writeback is called (this is the default).
- Partial App Reload - App partially reloaded when writeback is called.
Figure 5: Reload