Releases

Bug fixes

• Duplicating a database now also duplicates translations and locks.
• Fixed an issue where the record label setting was silently dropped when creating a new form. The selected record label now persists correctly after saving.
• Fixed an issue where the "Merge records" and "Clear field values" buttons became disabled when selecting a large number of records in the interactive table.
• Fixed an issue where fill-down and pasting reference fields could produce "Invalid" values when the user's system language is not a database main language.

Improvements

• Added required rules, allowing fields to be required only when a specified condition is met (formula-based required fields).
• Form designers can now define translated error messages for validation rules, which are used across data entry, table view, and import/export.
• Cells hidden by relevance rules are now grayed out and cannot be edited in the interactive table.

Bug fixes

• Fixed an issue that could cause some valid records to incorrectly appear as invalid in the table view.
• Fixed PIVOTLONGER to preserve the original option order for select field values instead of sorting them alphabetically.
• Fixed missing totals in the pivot table when a row dimension with Totals is placed above measures.
• Fixed an issue that allowed users to configure forms with both a serial number field and another field marked as the key.
• Fixed a visual issue in the date pickers in the validation and relevance rule editors.
• Fixed an issue where adding a calculated column would deselect previously selected columns the table view editor.
• Fixed an issue where reference fields could be reset to blank when editing a record in the interactive table if the referenced form contained a record with a blank key.
• Fixed an issue where locked records could still be edited in the interactive table view.

Bug fixes

• Fixed an issue where the reference lookup dropdown did not show values in interactive tables when the reference field included a translation field and the table opened in a translated language.

Bug fixes

• The weekly risk report email now correctly excludes recently invited users from the dormant user count, aligning it with the database user management page.
• Calculated fields no longer inherit invalid states from referenced fields and will stay valid even if source fields are invalid due to relevance rules or required checks.

Improvements

Matrix View

• Fixed several issues in the matrix form view where cells with (Blank) dimensions could display missing data, update the wrong record, or create incorrect draft records.
• Fixed matrix form view facet selection options not cascading/filtering according to the defined order.
• Fixed background sync reverting unsaved matrix view changes and resetting to the default view.
• Fixed matrix form view column header pinning not being respected when scrolling horizontally.
• Fixed matrix form view dimension cards not respecting the drop order when rearranging them in the matrix view editor.
• Fixed matrix form view to allow incremental selection of row dimensions when adding a new row with required but blank dimensions.

Importer

• Importers now tolerate differences in whitespace and curly or straight apostrophes or quotes when matching text. Instead of requiring exact character matches, the importer searches for matching text despite extra spaces or incorrect apostrophe or quote usage.

Get billing account users API

• The get billing account users API request now accepts optional query parameters to return a full list of unique user accounts linked to a billing account.

• Invited users can be included in the returned list using the query parameter (GET https://www.activityinfo.org/resources/billingAccounts/{accountId}/users?owners=false).

• You can also filter results to users assigned to a specific database (GET https://www.activityinfo.org/resources/billingAccounts/{accountId}/users?owners=false&databaseId={databaseId}).

Performance improvements

• And additional performance optimizations that reduce form table loads.

Bug fixes

• Fixed the select dropdown not opening when adding a new relevance rule in the form designer.
• Fixed "Export all quantities" not including the values of reference fields from a reference form with a reverse reference.
• Fixed copy-paste from Excel in some cases adding an extra space in text.
• Fixed the uniqueness checks on subrecord fields that were incorrectly invalidating new records against previously deleted records.

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.