Vizlib Writeback Table & Input Form Changelog

Note: insightsoftware recommends that you log in to Vizlib Management Console using admin credentials.

Input Form: You can update data in the Input Form. By default the Form allows you only to insert new data. To change this, select theUpdate operation and enable the Affect Input Form checkbox available in the VMC > Destinations> Writeback Settings. This allows you to update data instead of inserting new data.

Vizlib Input Form/Writeback - Snowflake table has no columns error. If a column could not be added to a writeback destination, the error message conveyed incorrect information that the table definition does not contain any columns.

Vizlib Writeback - Export to Excel fails when trying on Virtual Proxy. The export of data to Excel failed to work virtual proxy as the export failed to add a prefix to the export.

Vizlib Writeback - copy and paste on Associated fields. When you copy and paste values on Associated fields, the cells are populated with blank values when pasting on multiple rows/cells.

Vizlib Writeback Table - Text Area Min/Max settings. In the WriteBack chart, the text area fields do not adjust and display the number of rows depending on the content.

Vizlib Writeback Table dropdown field for bottom rows. When you try to populate the dropdown option in the last rows of the extension, the options are hidden and not properly displayed.

Vizlib Writeback table displays no resource found error in a Proxy Environment.

Option to disable OCSP check in Snowflake integration. While integrating Snowflake, a new option to disable the Online Certificate Status Protocol (OCS`P) check is introduced in the VMC screen.

Vizlib Server Logs improvements. The vizlib server allows users to view all logs using operation IDs, context IDs, or search phrases.

Connect Qlik Cloud over a proxy connection. You can now connect to Qlik cloud using a proxy connection.

Support the new 'Full' user entitlement. The Full user entitlement now has all the requisite permissions.

Allow possibility to duplicate items in Form Wizard. In the Input Form wizard it is now possible to duplicate items. Duplicating a page or a group makes the design process smoother.

Improvements to duplicating columns - possibility to unlink column. In Writeback Table any data-driven columns can now be converted to columns. Non-data-driven columns can be converted to a dimension or a measure.

Formatted Export to Excel (Writeback Table)The data in the Writeback table can now be exported to Excel. The export is formatted but there are some limitations. For example we do not export images such as flags. The following rules are followed:Hidden columns are not exported.Expressions are exported as the expression (not the result) Ratings and Sliders export as the (numeric) value.Colors are exported as the underlying value. (Most likely a hex-code but does not have to be.)Check boxes are exported as Excel true/false. When using custom values in check boxes he custom value is exported.Null is exported as an empty string URLs are exported as URL =HYPERLINK("http://example.microsoft.com/report/budget report.xls", "Click for report")

New row is present on the Table after canceling Form View. After adding a new row and cancelling Form View there was a mismatch in the rows and the new (cancelled) row was added.

Flag component - Wrong flag is set to some countries. Some less frequently used countries accidentally had the wrong flag assigned.

Using non existing column in editable if on row level, breaks Form View if column is not visible on the form. When editable if on row level and not including that column in the Form View it does not work as expected.

Error message shows up when row has been touched but not changed. When we touch but not change a row that has a requirement. The error for the requirement would show up. It should only show if the row is changed when "validate only inserted and edited rows"-option is enabled.

Input Form - not possible to copy value for non editable cell. Copy cell value for non-editable cell should also be possible like it is in Writeback Table

Soft Delete operation is visible for Vizlib Server REST destination. This option should not be available for REST-destinations.

Increment column version error after changing Radio/MultipleChoice/Dropdown option label. Some console errors appeared when changing the option label for Radio Button, Multiple Choice and Dropdowns.

Changing some styling properties on a column level is causing entire table to reload data. Changes to the styling on a column level should not cause the entire table to refresh.

[Writeback Table] Modified rows badge displays incorrect number when using undo / redo.

After using undo/redo the badge with number of writeback items display the wrong number.

[Writeback Table & Input Form] - Long refresh after writeback operation in large tables. This issue affected objects created or modified starting from version v4.10.0. Additional list objects were attached for columns, even if they were not required. In order to fix the issue, Writeback Table or Input Form has to be modified (e.g. by adding and immediately removing a column) and application needs to be republished.

Writeback Table. Insert with Queue - Writeback button is disabled when it should not be.

Writeback Table. Data Inconsistency modal shows up when it shouldn't, after adding and deleting a row.

[Writeback Table & Input Form]. HTML tooltip closes when it shouldn't.

Calculated column based on floats gives either ERROR or ignores the decimal separator.

Writeback Table & Input Form] Date component - export value as dual. When using QVD destinations you can now select a value to be exported always as a dual value. Previously that was driven by the used output format and in some cases value was exported as a string.

[Writeback Table & Input Form] Associated Fields for Multiple Choice Dropdowns. We recently released the option to create Multiple Choice Dropdowns in our writeback extensions. Now we added possibility to combine that feature with the Associated Fields.

[Writeback Table] Engine Settings. We updated the property panel for both Writeback Table and Input Form with the new option named 'Out of sync Qlik app'. It protects your writeback data from being corrupted in case of a failing application reload. For writeback to function properly it's crucial to make sure that data that is loaded into the dashboard is synced with underlying data sources. It might be, that due to a failed application reload during writeback operation, your data source and Qlik's data model will be desynchronized. Further writebacks could corrupt the data. With this new setting Vizlib Server persists information about failed reloads and blocks users from writing back, until application is successfully reloaded and their data model is synced.

[Writeback Table]. Context menu "Fill Above" and "Fill Below" options work incorrectly in multipage tables.

[Writeback Table]. Misaligned positioning when using Frozen Columns and top Totals.

[Writeback Table]. Associated Fields glitch when using Clear All button

[Writeback Table & Input Form] Possibility to restrict non-server side destinations. In most enterprise-grade environments Writeback Tables and Input Forms should connect with Vizlib Server for maximum control. Serverless connections in those environments can be confusing and caus errors. For that reason there is now a possibility to remove the option to use server-less QVD destinations from being used. The option is found in the System Settings/Security section of the Vizlib Management Console.

[Writeback Table & Input Form] Reset global and custom colors in property panel. Use one click to easily revert to the default color setup without a need to manually change multiple settings.

[Writeback Table] Average function in Live Totals. A new aggregation function has been added for columns containing numerical values. It is now possible to use Average with Live Totals.

[Writeback Table] Wrap text on column header when using spreadsheet mode. For consistency, the text in the column header can be wrapped also in spreadsheet mode.

[Writeback Table] No filter icons in search tool in Qlik May 2023. In recent versions of Qlik Sense, filtering popover got changed and icons to apply / cancel selection were missing.

[Input Form] Submit button gets disabled when other user is saving data. In previous version we have added new behavior, that was causing submit button to get disabled when other users have changed the data model. This change was mainly intended for Writeback Table, in this version we reverted previous behavior for Input Form.

[Writeback Table & Input Form] Improvements for Qlik's multi node environment setup. Two new settings have been added in the Destination settings within Property Panel. Custom Computer Name allows you to enforce usage of a specific Qlik node when executing the writeback operation. Proper values are Qlik nodes machine names (you can verify that by executing =ComputerName() function inside a qlik app). For more information, see App Reloads On Rim Nodes.

Second new property - Skip 'Waiting for data model to refresh' loader - can be used in situations where users are frequently seeing that loader as there is a bottle neck within Qlik configuration and it takes more time before engines on different nodes are reloaded after the writeback. Selecting this option will not show this spinner, making table interactive for the end users. The difference will be that the Writeback button will be disabled, until the data model is refreshed, to prevent data corruption.

Important: These changes require server version 4.11.1

[Writeback Table & Input Form].Changing value inside slider component causes 'Cannot read properties of undefined (reading 'toString')' error

Multiple Choice Dropdowns. For more information, see Data Types and Columns

Data Refresh options. We added new option to allow to disable table from automatic data refresh. This feature might come handy when multiple users are working on a single app and application is reloaded frequently. Setting 'Refresh on data update' to Manual will change Writeback Table behavior and it will ignore data updates that comes from Qlik until user will make an attempt to Writeback Data. It's important to understand, that once user starts to edit data in table, it will freeze current dataset even if selections are being changed. User can then manually click on the button to force table to update visible rows.

Writeback using SQL triggers fails with "export failed" error. Issue has been resolved. Note: There is an important limitation, that using triggers on insert may have significant effect on performance when multiple records are inserted in a single writeback operation.

Calculated Column.Qlik Expression not working properly when using custom decimal separators The issue was that values were not evaluated properly when a calculation used values with swapped decimal and thousand separators (decimal - ',' and thousand - '.') In order to fix this issue we have decided to introduce additional, breaking changes. After the upgrade, end users will have to enter values that are compliant with used formatting, previously users could enter values in both formats, either with dot or comma acting as a decimal separator. Since this change might impact existing solutions, it has been extra carefully considered. In the long run it will prevent issues that could otherwise easily have been caused by inconsistent inputs.Change affects every column capable of handling numeric values.

To be precise, here is the video showing how it used to work before the change:

And here how it works after the change:

[Writeback Table & Input Form] Text Column - Issue when using calculations within Writeback extension. There could been issues when using Text Column and calculations that were based on the content of that Text column. In order to resolve it we changed when Text column is triggering value change. It will happen once user will select a different column or will click outside of an edited cell. Previously value change was triggered automatically during typing.

[Writeback Table] Row Locking [Server side only]. Option to lock rows has been added to enhance workflows when multiple users can work on the same data at the same time. Whenever the option is enabled inside a Vizlib Server destination, rows that are modified are automatically locked and become read-only for all remaining users. Table informs with nice avatars who and when locked particular row. Row Locking requires a key column to be defined on a table.

[Writeback Table] Data Conflicts Dialog. In some writeback scenarios, even if you will be using Row Locking, you still might get data conflicts - for instance when a user was in the middle of making changes and application was reloaded by a scheduled task and some rows that are edited changed. Starting from this version writeback will detect such scenarios and will display new dialog which allows user to pick which conflicted values they want to proceed with.

• This can be done in a several ways: pick cell by cell
• pick all changes in a given row
• pick all changes in a given column
• pick all conflicts

Conflicted cells are shown one under another, where the top one is user current change and one at the bottom is the current Qlik data source value. Feature requires Key Columns to be used in a table.

[Writeback Table & Input Form] Auto complete option for Text and Chips columns.This new option allows to configure Text and Chips columns to serve users suggestions for their entries - in a similar fashion to a dropdown - with the key difference, that users can also enter value outside of a list. List with options can be populated from a field or manually entered in Property Panel.

[Writeback Table] Delete row action is not displayed when the row condition is true on SaaS. Option to delete a row was not visible when it should.

[Writeback Table] Setup wizard column validation indicator fixes. Indicator was only shown for the first invalid column and also its position wasn't refreshed in case when column is reordered.

Writeback Table - Form View modal positioning. We added drag capability to the Form View modal window. Now users can move it to the side and double check underlying row without having to dismiss the modal. The position is remembered per Writeback Table object per user session.

Writeback Table - Form View - aggregations are not supported. Actually that's more an improvement than a bug fix, previously we were not supporting aggregations in combination with Form View and now we do!

Expression editor doesn't work with Single API or Mashup. Limitation is still there but it is handled in a better way to prevent user confusion.

Live Totals displays value from first row for invalidated Date column. We improved how the feature is handling invalid rows, they are being excluded from calculations.

Improve pasting multiline cells from Excel - Input form and Writeback Table. Pasting of values containing multiple lines from Excel has been improved.

Read-only components width issues. We improved how read-only components calculate width and also added tooltips for them in Input Form.

Writeback Table: Required option | Red asterisk / Red star stays when column type is changed. Label will be now only displayed for column types using this setting.

Visual improvements to the Multiple Choice column when using Spreadsheet Mode. Background color did not fill the entire cell.

Insert key columns and improved data conflicts. Key columns are now enabled also for Insert operations. Combining the two, you can create Writeback Table which allows editing of existing data and at the same time create a full audit history of every change made. This can be used even for scenarios where multiple users modify the same rows concurrently.

Deleting invalid columns breaks table. Deleting invalid columns now work as expected when using editor inside the extension and property panel buttons.

Frozen Columns did not always work. Frozen columns will now work properly also when extension loads for the first time.

Writeback REST destination - issues with basic authentication. Error occurred when using it in server side destination.

Custom Text Align options are not visible in Property Panel. Due to a bug, starting from version 4.8.0 these options were not visible and couldn't be changed.

Writeback Table and Input Form are still evolving in a quite fast pace and it might be hard to keep it up! We're aware of that, that's because our demo application for both have been updated with examples showcasing our newest features. Do not forget to check them out to get an inspiration on how to take your dashboard to the next level!

[Input Form] Label positioning options. Building perfect form might be challenging - we're aware of that. That's why we have added new setting to fully control each field label. Now you will be able to decide whether it should be positioned on top, left, right or should be hidden. This applies to labels and suffixes. Check out the new Form templates for some inspiration on how to use this new feature.

[Writeback Table & Input Form] HTML column tooltips. Good tooltips are a must for end users to fully understand what they are looking at. It is an essential way of presenting additional context. Having that in mind we made our tooltips not only more appealing, but we also now allow HTML based, dynamic content for them. Check out our updated demo app for some inspiration on how to use this new feature. For more information, see Vizlib Writeback Table Column Properties - HTML Tooltips.

[Writeback Table] Unique key. This feature enables users to specify unique constraint for data destinations which do not have such functionality by default (e.g. QVD files). With just few clicks your dashboard developer can configure it to protect your data from getting duplicated records.

[Writeback Table & Input Form] Add Qlik Expression validation to additional column types. Possibility to validate column's validity is now also enabled for: Numeric, Dropdown, Flag, Icon, Rating, Slider, Date.

[Writeback Table]. Sometimes when working on a table, column that was previously hidden is showed back again

[Writeback Table & Input Form]. Associated Fields doesn't work correctly if Options field contains " character

[Input Form]. Animation for the form expanding is trigger each time refresh happens

[Writeback Table & Input Form]. REST destination: Issue in Proper Error Capturing

[Vizlib Writeback Table] - Application reload and Qlik data model refresh issues. We improved user experience when writing back, depending on application size and your server spec, sometimes the data refresh was triggered with a significant delay which could confuse end users. Now, with clear loading indicators user will exactly now what's happening under the hood.

Important: This change requires latest version of Vizlib Server, which is 4.7.3.

Writeback Table - Improvements to queue handling when multiple users write to the destination at the same time. We introduced number of optimizations to queue handling which improve overall usability of the feature when app is being used at the same time by multiple users. This includes but not limits to improvements in messages displayed to the end user, extension waiting for the data model to be refreshed after the app reload and new setting in Vizlib Management Console `Reload Buffer`, which allows to bulk multiple writeback requests in one batch.

Copy & Paste styles do not work for color expressions and conditional formatting. Recently added functionality to copy & paste styles when building either Writeback Table or Input Form lacked support for using Qlik expressions for colors or conditional formatting.

[Writeback Table & Input Form] When columns are hidden, drop-down with associated fields fails.

[Writeback Table & Input Form] Conditional Formatting rules are not applied correctly everywhere.

[Writeback Table & Input Form] Property Panel issues when using data handling calculation condition.

[Writeback Table & Input Form] Text align options don't work with Text Area Settings are now affecting both Text and Text Area input types.

[Writeback Table & Input Form] Keyboard doesn't work as expected for Slider, Dropdown and Date.

File Name validation broken inside set up modal when using path. There was a bug which prevented set up from being used if the file name for QVD destinations was not pointing out to the root level. It affected server less destinations only.

[Writeback Table] Form View issues. Due to this bug form view modal window could be closed during a reload of an application.

[Writeback Table] Editable If on row level. Our previous implementation of Editable If was supporting Qlik's expressions to be used on a global level - e.g. specific cells could be editable only if specific selection was made. We added now support for expressions on row level that is supporting Column Syntax. This is a powerful feature which can unlock many new use cases for Writeback Table.

Note: Editable If on row level will have a negative impact on performance, therefore it's not recommended to use multiple Editable if expressions combined with large data sets.

[Writeback Table] Freeze Columns. For wider tables it is now possible to freeze one or few first columns so that they are always visible on the screen! Simply right-click on any column and select "Freeze columns" or use the setting in the property panel.

[Writeback Table] Dynamic URL Labels. For more information see Vizlib Writeback Table Column Properties - Dynamic URL Labels.

[Input Form and Writeback Table] Form View Wizard bugs There were a few bugs in the wizard that resulted in new fields not being added at proper places.

[Writeback Table & Input Form] Printing Issues. Although we still believe that printing Writeback Table or Input Form is not a typical use case for those tools, we spent some time to ensure that when they are printed, they are printed correctly. This includes printing instances using server side destination or ones with lots of calculated columns with Live Totals enabled.

[Writeback Table] Form View - Column width setting affects field width when opening form view. In the 4.2.0 release, unfortunately a bug was introduced which was causing issues inside form view. This could lead to a strange behavior in some configurations and part of the inputs being cut. Related to this issue please note that the setting to "Adjust Column Width" only changes the column width in the Writeback table. For Form View use these settings in the Form View Wizard to control the size.

[Writeback Table] Socket Disconnect Error while writeback to Google Big Query,

[Writeback Table] Key Columns. You are now able to specify which columns should be used to identify rows when updating / deleting rows. This makes it a lot easier to avoid unwanted duplicates and take full control of how data is connected.

[Writeback Table & Input Form] Make table or form read only when user has no access to the destination.

[Writeback Table] Writeback Table creates duplicates when using Date column and Update operation.

[Writeback Table & Input Form] Conditional Formatting. We already had plenty of formatting options but now it is also possible to set up rules for the formatting using expressions. Define one or many rules that will dynamically adjust the chosen formatting options of either individual cells or entire rows.

[Writeback Table & Input Form] Changing Column Type navigates up one level in property panel Small usability glitch that got fixed.

[Writeback Table & Input Form] File name input validation fixes. Some characters (e.g. single quote) were accepted by the input which could cause load script errors.

[Input Form] - Wizard overwrites expressions with evaluated values for field tooltip property. In some cases opening the wizard and changing properties of fields could result in loss of tooltip expression of different fields.

[Writeback Table] Date Column - Date restrictions setting is causing strange behavior when changing selections. Using date restrictions setting was causing an issue which could result in modified cells being applied to wrong rows. It could happen when changing data in the table first and then applying selections, but only when having some date cells empty.

[Writeback Table & Input Form] Date Column - strange positioning when opening for the first time. There was a visual glitch which could be especially visible in big applications or while using less performant devices. Date picker was first shown in the top left corner and only after a second moved to proper position.

[Input Form & Writeback Table] Minor performance improvements.

[Input Form] - New tooltip / help options for fields and groups.

[Writeback Table] Longer load time when page size is increased.

[Writeback Table & Input Form] Rewrite Radio button cells without Material Design.

[Writeback Table & Input Form] Rewrite Multiple choices cells without Material Design.

[Writeback Table & Input Form] Rewrite Dropdown column without Material.

[Writeback Table & Input Form] Rewrite Date cells without Material Design.

[Writeback Table & Input Form] Rewrite Checkbox cells without Material Design.

[Writeback Table & Input Form] Numeric Column - Issues with entering values in Qlik Expression evaluation type.

[Writeback Table & Input Form] Calculated Column - "Simple" evaluation not working for single column syntax.

[Writeback Table & Input Form] Calculated Columns - Improvements and Breaking Changes

[Input Form & Writeback Table] Numeric Format - formatting engine changed. Support for locale defined in the Load Script.

[Writeback Table & Input Form] Submit/Writeback button will be disabled when you click Cancel button in confirmation modal.

[Writeback Table] Bulk editing performance optimization.

[Writeback Table & Input Form] Improved performance for numeric and text columns / fields.

[Writeback Table] - CSS Error - Appearance Corrupted When Adding Vizlib Teamwork to a Sheet.

[Writeback Table & Input Form] Unlocking server side destination when task reload is used (admin attention required to unlock).

[Writeback Table & Input Form] Writeback destination - possibility to define as an expression.

[Writeback Table] Error while trying to writeback to a QVD when column headers include a new line character.

[Writeback Table & Input Form] Improved performance in some cases.

[Writeback Table] Improved performance when updating Appearance section properties.

[Writeback Table] Multi-lined Text Field in Writeback Table & Table Form View.

[Enterprise only] VMC integrations and destinations management improvements. A massive improvement has been introduced to the VMC. You can now manage integrations and writeback destinations without having restart the server. Changes are applied instantly and take effect without having to reload the Qlik Sense dashboard.

[Writeback Table] Set Up improvements. Writeback set up now has a new look & feel, and a search function to help you pick dimensions, measures and fields.

[Writeback Table & Input Form] Customizing field background and text colors for inputs. Do you need more advanced color options to apply your own corporate branding standards? Now, with just a few clicks, you can control the color for any input in your table or form!

[Writeback Table] Add option to have info icon next to header with tooltip.

[Writeback Table & Input Form] Custom options definition improvements when using expressions.

[Input Form & Writeback Table] Some property panel changes do not take an effect until data is loaded or page is refreshed.

[Input Form] Layout Wizard improvements. Field types can now be modified after the field has been added and field visibility can be set in the wizard.

[Writeback Table & Input Form] - Export to MS SQL fails when database table does not have primary key defined.

[Writeback Table] Default options values for dropdown, flags or icon columns get modified after first reload.