Changelog

v2.20.1

2025-01-09

• Fixed missing default value for rule transformation TranslateNumber

v2.20.0

2024-12-16

• Added Swiss number language

v2.19.2

2024-12-06

• Fixed an issue that could cause the rule trigger for app reloads not to work properly in certain cloud implementations

v2.19.1

2024-11-26

• Changed Rule execution ordering for the unsaved data trigger to work properly with the totalData rule value

v2.19.0

2024-11-25

• Updated the simple dropdown with more options
  
• Added new rule action to set a custom totals value (no aggregation required)
• Added new rule trigger when a total value changes, this can be used for global state handling
• Added new rule value table.totalsData, which is available everywhere

v2.18.0

2024-10-29

• Added a wildcard search mode for the advanced dropdown
• Improved the advanced dropdown focus behaviour (you can tab focus the dropdown now and open it with space)

v2.17.0

2024-10-25

• Added new rule action Apply bookmark

v2.16.0

2024-10-14

• Added new rule action run automation (SaaS only)
• Added a calendar week display for the custom date picker
  

v2.15.2

2024-09-06

• Fixed an issue with HasChangedValue rule conditions not properly re-evaluating upon saving
• The rule action WriteValueToRowGroupChildren ignores disabled cells now, an option to include them has been added

v2.15.1

2024-08-28

• Copy cell data of multi select advanced dropdowns copies the actual value now (unless overwrite cell text is applied)

v2.15.0

2024-08-22

• Added a concurrent user display (Table styling->General->Concurrent user display) (Server v2.9.0 required)
  
• Added new rule action send table broadcast (Server v2.9.0 required)
• Added new rule trigger table info update (Server v2.9.0 required)
• Added an undo changes option in the rule editor
• Rule actions can be copied/pasted and moved with drag and drop now
• Added an option to display only one row, filling the available space
• Added new column type Comment history
• Added new rule action open comment history dialog
• Added new rule action add comment history entry
• Added new rule action trigger general row action and a matching trigger general row action, which allow to run row based rules based of static events
• Added new rule value cell.columnName
• Added row replace variable $#(rowId)

v2.14.0

2024-08-07

• The Data+ messages no longer require the target id to be selected, they are now solely based on the defined function name
• Data+ messages now support parameters
• Fixed an issue where the unsaved data display was not updated after saving
• Added the rule value row.identifier
• Improved the undo handling in combination with row groups
• Added a calculation evaluation option for text input fields
• Added rule transformation calculation evaluation
• Added rule action set row group value
• Rule action Distribute value to columns can be used with the trigger Set row group value now

v2.13.0

2024-07-23

• Added an option to display the default loading as overlay (Table styling->General->Loading display)
• Added new rule tranformation Regex replace
• Added new rule action to show a cell info icon with optional text
  
• Added an option to ignore external updates (this can be used avoid the loading process when working with large data sets)
• Added new Rule trigger External data update
• Added new Rule action to set a custom button style (event based)
• Fixed the info display for a rule disabled save button

v2.12.0

2024-07-18

• Added new rule action to enable/disable a loading overlay
• Improved loading performance for row group based tables with large data sets

v2.11.2

2024-07-11

• Fixed a display issue when selecting in row groups with same values
• Moved the column hidden setting to the display group

v2.11.1

2024-07-05

• Fixed a migration issue with rules created prior to version 2.0.0

v2.11.0

2024-07-04

• Added new rule actions Clear unsaved data, Custom button style
• Added an option to force custom buttons in a menu
• Added an option to place custom buttons in the context menu

v2.10.1

2024-06-26

• Added en-US language option for custom formatting

v2.10.0

2024-06-14

• Added an option for the rule action DownloadCsv to specify the columns
• Added new rule actions: Sleep & AwaitDataLoading, these can be used to avoid issues with simultaneous rule executions
  (e.g. running a bulk edit with a Data+ Message while changing the table data with variables )
  
  These changes reduce required rules for pivot styled tables drastically
• Most rules that have a column setting now allow multi selection, which will apply the rule for all selected columns
• Added an option for the rule action RowGroupTotalsValue to apply for all row group depths
• Added an option for the rule actions Distribute-/Write ValueToRowGroupChildren to use the trigger column as the write column

v2.9.0

2024-05-30

• Added rule action DistributeValueToColumns
• Added rule condition input.new.cellData and input.old.cellData
• Added an option to disable the auto update during entry

v2.8.1

2024-05-28

• Formatted view and linked cells no longer show close button if manual toggle is disabled
• Added rule DataPlusMessage trigger for BulkEditButton action

v2.8.0

2024-05-13

• Added a rule action to trigger a bulk edit on button columns
• Added rule transformation support for the action TriggerRowGroupChildrenButtons
• Added input data support for the bulk edit of button columns
• Added rule condition row.rowgroup.childCount
• Added option to disable the row group expand function, this allows to create a pivot view with different depths
  

v2.7.2

2024-05-02

• Rule action trigger row group buttons now checks for disabled buttons
  • Added option to include disabled cells

v2.7.1

2024-04-30

• Fixed an issue with existing Cell button clicked rules in combination with row groups
• Fixed the total calulation for text columns

v2.7.0

2024-04-29

• Added rule action/trigger to handle button clicks for row groups
• Added option to disable the default data export (context menu)

v2.6.0

2024-04-26

• Added a formatted view option for Data+ columns
  • This is a more convenient way to have custom formatting applied to an input field without creating a linked column
    
• Improved csv export handling for " character
• Csv export transformations now apply to each cell value indivually rather than the whole csv text

v2.5.5

2024-04-19

• Fixed duplicate function (context menu) for dimension/measure columns

v2.5.4

2024-04-04

• Fixed an update issue with server urls as expressions

v2.5.3

2024-03-28

• Simplified the server connection settings, a specific variable $(currentUrl) is now used to connect to the current protocol & hostname

v2.5.2

2024-03-14

• Added rule condition option trigger.rowGroupTriggered

v2.5.1

2024-03-13

• Fixed an issue with the rule action Write column filtered totals value not triggering set value rules for create db entries

v2.5.0

2024-03-07

• Added option to add exceptions for the row group default view
• Added rule action to apply a row group view (default/expanded/collapsed)

v2.4.3

2024-02-22

• Rule action Save data can now be used with the Data+ Message trigger

v2.4.2

2024-02-15

• Added object id to about section

v2.4.1

2024-02-14

• Fixed an issue with the confirm dialog in combination with bulk edit

v2.4.0

2024-02-13

• Added input dialog option for the button column and custom buttons. The value can be used in rules
• Added rule action to create a rule variable which can be used in the current running rule
• Added rule action & trigger for Data+ Messages which allow to communicate with other extension on the current sheet

v2.3.2

2024-02-02

• Added option for Api call action to properly handle JSON escape characters with variable replacement
• Added rule transformation to parse a JSON string (e.g. \n will be replaced with a proper new line character)
• Added rule transformation to JSON stringify a value (e.g. new line characters will be escaped)

v2.3.1

2024-01-23

• Added file name setting for download csv rule action

v2.3.0

2024-01-10

• Added formatted date rule tranformation

v2.2.3

2024-01-04

• Added support for line breaks in confirm dialog

v2.2.2

2023-12-20

• CSV export now supports line breaks

v2.2.1

2023-12-14

• Added partial option for cloud reloads
• Advanced dropdown display can now be overwritten
• Linked columns now work with unsaved data display as well

v2.2.0

2023-11-14

• Added custom buttons
  
• Added rule trigger: Custom button
• Added rule action: File upload
• Added rule action: Download CSV data

v2.1.4

2023-11-10

• Fixed an issue with the save data rule

v2.1.3

2023-10-25

• Added touch support for the search dialog

v2.1.2

2023-09-22

• Fixed an issue where db data accessed by rule conditions was not being loaded

v2.1.1

2023-09-18

• Fixed different value marker for linked columns not visible

v2.1.0

2023-09-12

• Added rule transformation: Split text

v2.0.0

2023-09-06

• All new rule editor
• Added a new message display type
• Added option to include disabled cells for bulk edits

v1.34.4

2023-07-27

• Fixed an issue with the column has value (static) trigger

v1.34.3

2023-07-05

• Fixed a loading issue

v1.34.2

2023-06-09

• Fixed an issue where older extensions would not load data
• Fixed rule set api result to column not handling number values properly

v1.34.1

2023-06-01

• Improved the color picker in the settings menu

v1.34.0

2023-05-26

• Added more data load options
  • It is now possible to load data that exceeds 10000 cells
  • Added option to disable automatic reload, a button allows to load new data on demand
  • Added option to wait for Data+ data before rendering (this improves performance for tables with large rule sets and removes potential flickering caused by rules)
• Disable input while loading can be disabled in default saving mode now
• Improved the back button behaviour
• Renamed the "update mode" setting to "save on entry"

v1.33.2

2023-04-03

• Fixed unselect handling in the selection dialog

v1.33.1

2023-03-29

• Fixed language handling for rule Overwrite filtered totals value to filtered row

v1.33.0

2023-03-28

• Added row groups - this feature offers design and functionality settings for a pivot table approach
  
• Added margin setting for cell content
• Added rule actions/triggers/conditions related to row groups
• Added linked column edit mode option cell
• Added linked column option to leave the edit mode on blur (unfocus)
• Added linked column option to hide the edit icon in edit mode cell
• Added option to show text/text input as a scrollable area
  
• Added option to disable selection in dimensions individually
• Bulk edit can be used on all columns now, settings and rules have been added to customize the behaviour
• Added option to enable Paste (ctrl+v) on linked columns
• Added option to ignore NaN & Infinity values for the rule calculation library
• The search dialog now supports selection with ctrl pressed
• Added option to set the output language of the rule calculation library
• Increaed maximum fixed columns to 10
• Added custom default text button option for Text field dialog
  
• Added option to show indicator for unsaved cells

v1.32.2

2023-01-27

• Fixed date picker for Firefox (v109)

v1.32.1

2022-10-11

• Fixed rule action Api call file download not working for non text files
• Fixed rule action Api call to properly handle urls starting with port or path only

v1.32.0

2022-09-23

• Added remove trailing zeros option for custom formatting
• Disabled mouse over text for hidden cells
• The color of slider, switches and checkboxes can be changed now
• Added new switch style basic
  
• Added number language setting to allow proper german/english number parsing
• Added rule trigger on bulk edit
• Columns can now be duplicated
• Added styling options for a disabled save button
• Color and icon value settings are now more user friendly
• Added position buttons to the Rule editor
• The Rule editor now keeps its scroll position after editing a rule
• Minor improvements to the rule action Api call
• Added option to toggle off the disabled style wile loading in on entry mode
• Added option to stretch the last column
• Updated Fontawesome to version 6.2.0
• Added rule trigger is not create entry row
• Added auto focus option for linked columns
• Added rule action toggle linked cell state
• Added option to highlight mouse hover row

v1.31.2

2022-05-20

• Added rule action to disable additional column buttons (link edit, expand)
• Added rule action to overwrite the column filtered totals value to a filtered row
• Fixed display type html not working properly
• Rule overwrite cell text now applies custom formatting of the column

v1.31.1

2022-05-19

• Added rule action to set column borders color
• Fixed confirmation dialog not applying for toggle bulk edit
• Fixed table font size not applying to buttons
• Fixed additional cell buttons (expand/edit) not applying font size/hide information
• Improved API call json parsing
• Changed row height to adjust automatically if the table space wouldn't be enough for 1 row

v1.30.1

2022-04-21

• Fixed color picker for multiple extensions on same sheet

v1.30.0

2022-04-19

• Changed versioning
• New column type: color picker
• Improved rule execution buffer
• Added rule action: bulk edit
• Added confirm dialog option for boolean column types
• Rearanged display/general column settings
• Added setting for disabled style
• Style rules now apply for input fields aswell
• Added header color setting
• Added text field (no input) formatting option
• Added rounding option for total value rules
• Added custom formatting setting for all advanced columns applying to totals value only
• Added cloud support
• Added option to open api call file download in browser
• Added support for automatic license assignment

v29

2022-01-14

• Added rule condition set value to column and check other column
• Added a fail safe for infinite loops, the threshold can be increased via
  settings->general->advanced->Overwrite rule execution buffer
• Set column filtered totals value none now writes the written column data
• Added rule action set filtered totals value to filtered row
• Added option to Set value rule actions to round a number value

v28

2022-01-10

• Improved/Added bulk editing functionality
  
• Added extended data handling, this feature allows to load up to 10.000 cell values initially. This allows bulk editing for more rows than displayable
• Added setting for advanced dropdown size
• Added number comparison rule condition
• Added more context menu settings
• Text display can now be viewed in an dialog (expandable)
• Additional dropdown additional value can now be text (without display)
• Added edh rule action to aggregate a column with a specific column filter
• Added setting to always show cell/header buttons in touch mode
• The rule action trigger task reload now allows to use the base settings task set for ondemand/listener
• Added rule action to set the linked column state
• Added setting to hide the linked column button

v27

2021-11-17

• Added custom html content as cell display type
  
• Added custom css setting
• Greatly increased maximum row height

v26

2021-11-11

• Added multi selection option for advanced dropdown
• Added rule conditions to check for rule triggered rule checks
• Added interceptor for qlik default file drop when a button file drop zone is active
• Added display type selection support for column type text(no input)
• Api call and web link url now allow port and/or path change only
• Added custom date picker (beta)
  
• Added rule trigger for multi selection count
• Added rule action to overwrite the cell alignment
• Added rule action to overwrite cell text size
• Added rule action to set cell text bold
• Added rule action to hide cell content
• Added rule editor search
• Added rule trigger is create entry row
• Added comment dialog display type clickable icon

v25

2021-09-22

• Added button action file input, which allows using the file via rules (e.g. api call with file upload)
• Added button action setting (default click)
• Added rule action to enable/disable the loading display
• Added option to hide the info bar
• Added setting to process null value for linked columns
• Added setting to always show changed linked cell value

v24

2021-09-09

• Added column linking, this feature allows additional columns to be linked to a dimension or measure. A small button allows to switch between them
  
• Added rule action: Overwrite cell text
• Added rule action: Set text color
• Added rule action: Set totals value
• Added rule trigger: On server data update
• Added Scroll speed setting
• Header button execution now blocks the save button while executing
• Added totals function setting for measures
• Changed dialog position to be on top (Added setting for some dialogs)
• Fixed settings migration for master objects
• Improved table and task selection dropdown

v23

2021-07-02

• Fixed search dialog position with horizontal scroll
• Fixed include null values migration error

v22

2021-06-15

• Improved rule editor design
• Added rule import/export functionality
• Disabled Copy/Paste functionality in edit mode
• Added new column type: Advanced dropdown - this is a Qlik based searchable list that allows additional image or icon display. The Qlik expression can be created with column values.

v21

2021-05-20

• Rule values variables now allow the column number with $c(columnNumber)
• Added support for server connection in combination with different proxy paths
• Bug fixes

v20

2021-05-12

• The settings data input has been changed and now feels much more like the Qlik default table
• Adding columns is now iFrame based using the server cookie (single login required for both server/extension)
• Total measure positioning is now based on general column alignment
• Added Calculated value option for rule data (this allows direct calculations based on input)
• Added Calculated value option for rule data with custom Qlik expression
• Added header tooltip option
• Added rule action "Disable row input" (All additional columns will be disabled)
• Added create db entry default value option (available in each column if entry creation is enabled)
• Added rule action navigate to sheet
• Added option to disable borders
• Several bug fixes, mostly minor visual errors

v19

2021-04-08

• API call rules are now able to handle line breaks
• Added sticky columns functionality
• Fixed pasting to date field value
• Added right click copy/paste functionality
• minor visual bug fixes