Configuration

The Writeback Table allows users to write or edit data directly within Qlik Sense applications and store those changes in configured destinations such as files or databases.

It provides a structured interface for data entry, modification, and submission, enabling operational workflows directly from Qlik Sense dashboards.

Accessing Writeback Table

1. Open Qlik Sense Application: Launch your Qlik Sense application where you want to work with the Writeback Table.
2. Enter Edit Mode: Navigate to an existing sheet or create a new sheet.
3. Access Custom Objects: In the left panel, click on "Custom Objects" to open the custom objects menu.
4. Select SenseOps Extension: Locate and select "SenseOps" from the custom objects menu.
5. Add SenseOps Writeback table: Find the "SenseOps Writeback table" extension within the SenseOps category. Click and hold the Writeback table, then drag and drop it onto the sheet canvas.

After completing the above steps, to access Writeback settings, click the highlighted icon or open the settings from the property panel as shown in the image below.

Writeback Configuration

Writeback configuration defines how data entered in the Writeback Table is captured, stored, and processed.

The configuration is completed through the following four steps:

1. Destination Selection

• Select the destination where the data should be stored. Choose from file-based, database, or REST API destinations.

• For file-based: Specify the file location, file name, and file type (e.g., CSV, QVD, Text). Check the custom path if you want to input the file path.

  

• For database: Select the Qlik connection, then select the data connection (created during config) and the owner. Now select the database and specify the table name for the destination.

  

• For REST API: Select destinations exposed through REST APIs.

Info

REST API will be coming soon

• Select the Action either to Upload, Insert, or Delete. Then click Next for further steps.

2. Define Columns

In the Writeback extension, the "Columns" section allows users to define the data structure for the writeback operation. This section offers flexibility in selecting columns from the existing data model or defining custom input columns according to specific data requirements.

• If the columns page is empty, click (+) Add column.

• Select either Select existing to add columns from existing data or Create custom to create new columns.

Existing Data Model Columns:

• Users can select columns directly from the existing data model within Qlik Sense, typically dimensions, measures, or other fields already present in the app's data model.

Custom Input Columns:

• Alternatively, users have the option to define custom input columns based on their data input needs. These custom columns enable users to specify additional data fields or parameters relevant to their writeback operation.
• Data types for custom input columns can include dropdown selections, checkboxes, review ratings, and other value types as needed.
• Click on Add columns to add to the columns list.

• Users can add extra columns, edit the column names, hide column visibility, or delete the column after adding it to the list.

3. Define Storage

The Define Storage step specifies how the configured columns are stored in the selected destination.
In this step, users can map columns to destination tables and define how data is written during the writeback operation.

1. Available columns: Users can add these columns to the tables.

2. Audit Columns: By selecting Audit columns, users automatically add CreatedBy and CreatedAt to the source.

3. Select Table: Select the table name from the database for adding destination columns.

4. Key: Users should select a unique ID as a key for respective tables.

5. Add table: Users can add multiple tables to the source.

• After all selections, click on Next to move to the next step.

4. Trigger Actions

The Trigger Actions step allows users to define actions that are executed based on the outcome of a writeback operation.

Users can configure actions to run when the writeback succeeds or fails, such as triggering Qlik actions for application refresh.

Once all configuration steps are completed, click Save to apply the settings and display the Writeback Table on the sheet.

Quick video - How to use the SenseOps Writeback ?

The following video demonstrates how to configure and use the SenseOps Writeback Table.