Hello everyone,

In this release, we have added support for editable pivot tables and filtering multi-line type-domain controls. We have also fixed some minor issues and tasks.

Demo

As always, we have made a demo for you: try it here. Before trying it out, press 'Clear Cache' on the login screen.

Read the Universal GUI user interface guide to get familiar with the GUI.

Universal GUI version 2024.3.14 (release candidate)

For more information about setting up the Universal GUI, see the Universal GUI setup guide.

Note:

• Use a modern browser to access the Universal GUI, such as a recent version of Chrome, Firefox, Edge, or Safari mobile.
• Deploy the Universal GUI on the same server as Indicium or an allowed origin in appsettings.json.
• Run all hotfixes on IAM and the Software Factory instances you plan to use for the Universal GUI.
• Use the latest version of Indicium.

Download the Universal GUI version 2024.3.14 (release candidate) here

Contents

New and changed

Support for editable pivot tables

new

The Universal GUI now supports editable pivot tables. 'Editable' means that users can change the value of cells in the pivot table. They can navigate through the cells by using the arrow or tab keys. Pressing Enter brings the cursor into the editor to change the value. Changes are directly saved to the table behind the pivot table after leaving the cell by either using the mouse or the keyboard.

To make a pivot table editable, the following conditions must be met:

• The user must have permission to manipulate data in the table by selecting the option Update.
• The column type must be set to Editable.
• The summary type of the cube field must be min, max, avg, or sum.
• The count of the summary type must be 1 (exactly one row behind the aggregation). For example, the sum of Ben's (47) and Anna's (30) ages equals 77, with a count of 2 (derived from two rows, which cannot be changed). If you add "person" as a dimension, you get Ben (47, count = 1) and Anna (30, count = 1); these counts can be adjusted since they correspond to individual rows.

If a user edits a pivot table, the Universal GUI applies the setting for the refresh After update. However, it is advised not to set this to Document, as it may cause the pivot table to re-render.

It is not necessary to enable the subject to be editable by default, to enable autosave, or to show an action bar when no form is present for the subject behind the pivot table.

Support for filtering multi-line type domain controls

new

We have added support for filtering multi-line type domain controls. Both the filter pop-up and the inline filter form support this now.

Minor fixes and tasks

For grids and forms:

• When selecting multiple rows with conditional layouts in a grid, only the active row was highlighted as selected. The conditional layout would override the styles (row background color) of the other selected rows. This has been fixed.
• On a slow network, selecting a value for a lookup editor from a pop-up could occasionally cause a crash. This issue has now been fixed.
• Inserting records in a grouped grid subject was not working as expected. Grid columns are grouped when the checkbox Group until is selected in the Software Factory (menu User interface > Subjects > Default/Variants > tab Data > tab Sort). To insert the added record in the same group, the grouped columns should also be marked with the checkbox Include in insert (menu User interface > Subjects > Default/Variants > tab Columns). Previously, the group values were not filled in the form after pressing Add. This has now been fixed. Note that a form is required to insert a record (the grid itself cannot add a record).

For the date picker:

• The date picker would only show days belonging to the current month, leaving empty spaces before and after. These spaces will now be filled with adjacent days from the previous or next month.
• The date picker would always show Sunday as the first day of the week. It has now been updated to set the first day of the week based on your browser's locale language setting. For example, if the language is set to English US, the first day of the week will be Sunday; if set to English UK or Dutch, the first day of the week will be Monday.

Other:

• In some cases, the background of a cube field was not shown in the field selection panel. Now, it is always shown.
• The tooltip of an open document shows details about the selected record of the document. For a few releases, this tooltip has been showing details of the active document on inactive documents, which was confusing. For example, when 'Projects' was active and you hovered over 'Employee', the tooltip of 'Employee' would show the active project details. This has been fixed, so the 'Employees' tooltip shows the active employee again.

What we will be working on next sprint

The next sprint we will be working on:

• Support for the Thinkwise Platform version 2025.1
• Cell selection in pivot grids for task execution or showing detail data
• Maintenance

Questions or suggestions?