5.0 Build 2231 Released!

We have released a new version that includes the following changes.

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 a 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.


Last Friday, we released a patch that fixes issues affecting large-table navigation in non-interactive mode and incorrect record display when sorting columns with duplicate values, among other bug fixes. The full list of changes is detailed below.

  • 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 correctly 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.