Releases

Improvement

• Reports now only load the analyses visible on screen instead of all analyses at the same time, so the result can be displayed faster.

Bug fixes

• Fixed an issue where importing records with multiple-reference values ending with a trailing comma caused a server error.
• When exporting a subform with "Include parent fields" enabled, non-key reference lookup fields from the parent form are now included correctly.

Bug fixes

• Fixed an incorrect error message that appeared when deleting records.
• Fixed an issue where a form field could not be exported when a default value formula pointed to a reference field.
• Fixed an issue where facets with blank values did not appear in the facet dropdown list.
• Fixed an issue where the "Reset to default" option in matrix form view did not show when "(Blank)" was selected on a facet selection.

Improvements

Matrix from view improvements:

• Pin row dimensions

Choose which row dimensions to pin left so they stay visible when scrolling columns. Before, all matrix row dimensions were pinned left, blocking horizontal scrolling on forms with many rows. Now, only the first row dimension is pinned by default, allowing horizontal scrolling on forms with many keys.

• Save facet selections as part of the view

Facet selections can be saved as the view’s default, so all users see those filters applied.

• Rename dimension and measure labels
  Give any dimension or measure a custom display label that overrides the default field name. Edit it on the card. Clear the label to revert to the original name.
• More consistent dimension cards
  Dimension cards now show the field type as a small heading above the name, matching measure cards' layout.
• Tell measure columns apart
  When showing several measures without column dimensions, each column is labelled with its measure's name instead of a generic "Value", so you can tell them apart at a glance.
• Hide facet dimensions you don't need
  Hide a facet from the facet bar while it continues filtering your data behind the scenes. This tidies the view without losing the filter.
• Dimensions that don't apply are set aside automatically
  When your facet selection makes a row or column dimension irrelevant, that dimension is removed from the table instead of showing empty columns. It remains visible, greyed out, in the view editor so you can see where it went and restore it by changing your selection.
• Blank values are now labelled
  Empty categories in column headers now read "(Blank)" instead of appearing as blank space, consistent with blank rows and facets.

Bug fix

• Fixed an issue in the record panel where drafts for reference fields with multiple lookups could only be discarded when the first lookup field was selected in the table. Drafts can now be discarded regardless of which lookup field is selected.

Improvements

• Importer data validation and record matching now run on the server instead of in the browser. Previously, these processes ran in the client, causing slowdowns or crashes with large or complex datasets. Moving them to the server should fix these issues. However, offline record import is no longer supported.
• You can now configure allowed file types for uploads in attachment fields.

Bug fixes

• Addressed a couple of visual issues with field cards in form designer.
• Fixed issues related to draft records not properly pointing to new primary reference record after a merge event on reference data.
• Addressed more filtering issues affecting static, interactive mode and filtered subform table display.
• Addressed an issue where clear field values option was available in static table display. Now, this option will only be available in interactive mode.
• Fixed an issue affecting matrix view where draft values could not be discarded via the record panel.

Bug fixes

• Fixed an issue where draft values could not be discarded through interactive table record panel when selecting the entire row
• Addressed a visual issues affecting form designer field cards where some config fields where pushed to the right of the card

Improvements

• Improved scale on the map report legend to use interger numbers.
• In the form designer, setting a field as read-only will now require adding a default value for it.
• Enhanced data integrity validation for locked subrecords by restricting parent record deletion.

Bug fixes

• Addressed an issue that was causing form export to fail if the table contained integer geographic values.
• Fixed a couple of bugs where filtering would cause the table to be displayed as empty after scrolling in large datasets or after filtering on specific field types.
• Addressed two other static table filtering issues affecting subform table display when scrolling and when using “Show all records“ button.
• Addressed an issue where Kurmanji (Badini) language locale was not properly set causing manual translations to not show up after switching the language.

Improvements

• Allow bulk deletion for roles with record level conditions. This permission will only be available in the operations list if the role contains at least view and delete permissions.
• Improved error messaging in the formula editor for CONCAT() and ISBLANK() functions. Hovering over an error now provides more precise feedback.

Bug fixes

• Addressed an issue that was causing the record panel to not properly load when selecting records in a map view.
• Fixed an issue with record panel details that were not displayed in matrix view.

Improvements

• Two new formula functions have been added: LEN, which returns the number of characters in a text value, and LENG, which returns the number of user-perceived characters (grapheme clusters) in a text value.

Bug fixes

• Long text values were not fully displayed in the record detail panel. This has been fixed so the full contents are now shown.
• Long text values were also truncated when exporting query results as JSON via short URL for selected columns. This has been fixed so exports now include complete text values.
• In the record detail view editor, the components list was missing when a navigation component pointed to a deleted subform. This has been fixed so the editor now loads correctly in these cases.
• Saving the form designer without any changes was incorrectly triggering an audit log event. This has been fixed so only actual changes generate audit entries.
• Manually entered date values were breaking relevance and validation rules. This has been fixed so date conditions now work correctly for both manual input and selection.
• The languages menu in the database translation interface was not fully visible on small screens. This has been fixed so the full menu is now accessible on smaller screens.

Bug fixes

• Fixed an issue where scrolling past the first 512 records in non-interactive tables displayed the same set of records repeatedly instead of loading additional results.
• Fixed an issue where the Record panel could display the wrong record when sorting by columns containing duplicate values, such as identical registration dates. The correct selected record is now shown consistently.
• Fixed an issue where applying filters after scrolling in non-interactive tables could leave the table blank. Filters now correctly reset the visible row range.
• Improved error handling for calculated tables in the record detail view. Invalid formulas now display a clear “formula could not be parsed” message instead of continuously retrying. Empty calculated table results also now show a clearer message.

Improvements

• Improved the performance of the table page for large forms when filtering and/or sorting is active.

Improvements

• Added support for Haitian Creole (Kreyòl ayisyen) and Rundi (Ikirundi).
• Improved the error message for languages that do not support automatic translation, informing users that translations must be added manually for those languages (e.g. Kurmanji).

Bug Fixes

• Fixed an issue where hidden whitespace and line breaks can be pasted in the table and could cause a matching issue in the reference field lookup.
• Fixed an issue where querying rows from pivot reports with MIN or MAX measures on non-numeric columns returned NULL values.
• Fixed an issue where exporting attachments caused a crash when a date field was used as a record label.
• Resolved a 500 error triggered when adding a new form via the API using a duplicate ID of a deleted form. The system now displays: "Form with the same ID previously created. Form IDs cannot be re-used, even if the original form has been deleted."
• Resolved timeout issues occurring on large table queries that prevented the endpoint from completing the request.

This release includes changes to infrastructure services.

Improvement

• We improved the security of authentication via Single-Sign On (SSO) by implementing the Proof Key for Code Exchange (PKCE) protocol which provides defense-in-depth against authentication code injection attacks.

Bug fix

• Fields that do not meet relevance rules no longer appear in the record print view.

Improvement

• We have made optimizations to improve table load performance when sorting and scrolling in the table.

Improvement

• We have improved the performance of the column matching in the importer. Importing forms with hundreds of columns now runs faster and completes reliably, without failing during automatic column matching.

Bug fixes

• We fixed an issue where navigating to related subrecords from a record detail view could cause the navigation history to be lost, preventing users from going back using the back button.
• We also fixed an issue where users could not edit geo field values because the cursor would jump to the end of the field.

Improvements

• We added translation support for Kurmanji (Badini), Lao, and Vietnamese.
• Please note that Kurmanji (Badini) is currently not supported by the translation service, so automatic translation is not available for this language in the database settings.
• The record print screen now includes calculated fields and shows the record label as the header.
• We made some optimisations to improve performance for forms with a large number of records and references.

Bug fixes

• We fixed an issue where toggling “View all records” in a subform table (static view) could sometimes display incorrect records.
• When no keys are defined, reference field lookups now default to the record label and text fields instead of the record ID.
• We fixed an issue where some decimal values were displayed with incorrect formatting in data entry and in the record detail panel when used as a record label in a subform.

Bug fixes

• We fixed an issue where the record detail panel could show the wrong record in a subform when the table was set to a static view.
• We also fixed an issue where draft values were not shown in the table when editing fields with a default value formula that references another form or the parent form.

Bug fixes

• We fixed an issue in views where it was possible to set more than one default view in a synced database. We also fixed a related issue where setting a view as default did not warn about unsaved changes when navigating away from the page, which could result in changes to other views being lost.
• We fixed an issue with the TEXTJOIN() function where the delimiter did not behave correctly when ignore_empty is set to FALSE.
• We addressed an issue in the importer where it was not possible to match a required multiple-reference field when importing records.
• We also fixed an issue in subforms where the “return to parent” button could lose the parent context when navigating back through multiple levels.

Bug fixes

• We have made a set of fixes to improve performance for forms with a high number of references and translations.

Improvement

• We removed the limit on key fields. You can now add any number of key fields to a form.

Bug fixes

• We fixed a performance issue for forms with a high number of related forms. This previously caused slower loading times for the table display and form settings page.
• We fixed an issue where single reference fields displayed "(Blank)" in the table when the value was invalidated by a relevance rule.
• The Alt + arrow keys shortcut for navigating back and forth in the browser should now work again.
• We added the "Add resources" button, which was previously missing from the billing account page for Solo subscriptions.