This release is mostly about polishing the Matrix view — you can now sort rows and columns by measure values, required cells are clearly marked, and translated facet selections behave correctly across locales. We also fixed a handful of stability and display bugs in Matrix views, along with smaller fixes to formulas (TEXTJOIN), reports, the importer, form designer, and quantity exports. As always, let us know if you spot anything unexpected or if you have feedback on this release!
Improvements
-
Matrix views can now be sorted by measure columns and rows, in addition to dimension labels.
-
Facet selections saved to a matrix view now work correctly across different locales when the form uses field-level translations — filtering by a translated value returns the same results in every language the view is opened in.
Bug fixes:
-
Addressed an issue where SEARCH() formulas used in a reference field’s validation rule were not applied correctly in the interactive table, allowing invalid values to pass validation.
-
Fixed a server error that occurred when a reference field’s validation formula aggregated values through another reference field (for example TEXTJOIN combined with SEARCH).
Addressed an issue where the TEXTJOIN function ignored the specified delimiter for multiple-select fields and always joined values with a comma. -
Fixed an issue where adding an ad-hoc TEXTJOIN() formula directly in the table view failed, even though the same formula worked when added as a calculated field.
-
Fixed a crash that occurred when a report combined filters and lookups on a calculated table in certain conditions.
-
Fixed an issue where the importer did not refresh to show the new form’s records after switching to a different source form partway through an import.
-
Fixed an issue where a lookup field’s new name only appeared in the form designer once the mouse hovered over it, instead of updating immediately after a rename.
-
Fixed an issue where exported “all quantities” files omitted the referenced form’s name from column headers for reference fields inside subforms.
Matrix view:
-
Fixed a crash that occurred when opening a matrix view whose relevance rule referenced a field that had since been deleted.
-
Fixed an issue where clearing a cell’s value in a matrix view did not save a blank draft, leaving the cell empty.
-
Required cells are now visibly marked in matrix views, making it clear which records are still incomplete.
-
Fixed an issue where quantity measures disappeared — and drafts could no longer be entered.