Working with Writeback
Properties of Writeback Extension
Table Properties
The Table Properties section offers flexible styling options that let you shape the look and feel of your writeback table, including its title, headers, rows, cells, and hover behavior.
Table Title
Enable Show overall title to add a title above the table and customize its text, height, background color, font color, font size, and text style to match your design.
Column Header Settings
You can show or hide the column header and customize its appearance by setting the background color, font color, and font size. These options help you create clear and visually consistent table headers.
Row Settings
Adjust the row height to control how compact or spacious your table looks. You can also enable Freeze first column to keep the first column fixed while scrolling horizontally.
Highlight Edited Data
Edited cells can be highlighted by assigning a custom background color and font color. This makes it easy for users to spot changes before saving.
Row Lock Settings
Set a row lock line color to visually indicate which rows are locked and cannot be edited.
Strips (Row Styling)
Enable Show strips to automatically apply alternating colors to odd and even rows. You can customize the strip colors further by setting separate background and font colors for both odd rows and even rows to match your dashboard theme.
Hover Effects
Enable Row hover to highlight a row when the cursor moves over it. You can customize the hover background and font color to make navigation more intuitive for users.
Pagination
The Pagination section allows you to set how users navigate through rows in the writeback table.
-
Show pagination: Toggle to enable or disable pagination.
-
Rows per page: Choose the number of rows displayed per page (e.g., 10, 20, 50).
-
Text color: Set the color for pagination text.
-
Active color: Color for the active page number.
-
Inactive color: Color for non-active page numbers.
-
Text style: Apply Bold, Italic, or Underline styling to pagination text.
-
Footer height: Define the height of the footer section.
-
Footer BG color: Set background color for the footer area.
Actions
- The Actions feature in the Writeback Extension allows users to perform key operations directly within the Writeback Table.
- These actions enhance interactivity by enabling users to save, add, or export data without leaving the Qlik Sense environment.
- Each action — Save, Add Row, and Export — can be fully customized in terms of appearance, functionality, and placement.
Add Actions
- Click Add Actions to create a new action.
- You can choose from the following predefined action types:
- Save
- Add Row
- Export
- Each action can be renamed and customized with various styling and behavior options.
Action Customization Options
Appearence
1. Enable Badge
Check the Enable Badge option to display the number of rows that have been changed or added.
2. Background Color
Use the Background color option to define the button’s background.
You can either select a color from the palette or use an expression to set a dynamic color.
3. Text Color
The Color property customizes the button text color.
This helps maintain contrast and visibility based on dashboard theme.
4. Font Size
Specify the text Font size (in pixels) to adjust button label readability.
You can use expressions to dynamically resize text if needed.
5. Show Label
Enable or disable the Show label option to display or hide the button’s text label.
This is useful when you want to show only icons to save space in the toolbar.
6. Icon Type and Name
- Icon Type: Choose from Solid or Brands icon styles available in Font Awesome.
- Icon Name: Enter the icon name using the FontAwesome convention (e.g.,
faAdd,faSave,faDownload).
You can reference available icons from the official FontAwesome icons list.
Note
Use the format faName (e.g., faAdd, faSave) when specifying the icon.
Functionality
Add Multiple Actions
- Within each primary button (such as Save, Add Row, or Export), users can define additional actions from the predefined action types to execute after the main action completes.
- For example, a user can configure the Save button to automatically save and export data in a single workflow.
Placement
Icon Position
Select the Icon position as Left or Right relative to the text label.
This allows better alignment and consistent visual flow across actions.
Delete Action
Click the Delete icon to remove a specific action from the toolbar.
Deleted actions can be re-added at any time using the Add Actions button.