Self-Managed Server 4.3

Download 4.3.0

Release notes

4.3.0 (Dec 31, 2023)

The following are the improvements in the Self-Managed Server version 4.3.0 compared to 4.2.0:

New features

• Duplicate record scan & record merging
• Draft records
• Aggregation of non-numeric measures
• Translation fields
• Record labels
• Compact selection of multiple-select items
• Form views (personal & shared)
• Offline collection links
• Multiple reference fields
• Custom lookups for reference fields
• Reader form view
• Default value population for imported records

All changes

Improvements

• AI-4278 Support defining section indentation levels when importing fields
• AI-3086 Save draft of partially filled forms locally on device
• AI-3702 Mobile interface support for drafts (online and offline)
• AI-4237 Aggregation of non-numeric measures in pivot tables/calculated measures
• AI-4241 Improve filtering by form or folder in audit log
• AI-4242 Show details of form schema change and allow recovery of deleted fields
• AI-4324 Record Deduplication 1.0
• AI-4443 Deduplication scan optimisation
• AI-4427 Allow form designers to specify a field as a translation of another field
• AI-4494 Translate lookup values when a form designer has specified translation fields
• AI-2313 Sort users in user management view
• AI-4541 Filter users in user management view
• AI-4441 Duplicate scan configuration interface improvements
• AI-3566 Allow form designers to specify a field as a record label for the form
• AI-4350 Allow users to add records on a form (as draft, pending or committed) without requiring view permissions
• AI-4539 Translate record labels when a form designer has specified translation fields
• AI-3464 Split column width formatting from column selection state
• AI-4577 Duplicate scan review interface improvements
• AI-3701 Draft record validation (Table View)
• AI-3908 Support referencing draft records in reference fields
• AI-4499 Support setting up the matching strength of duplicate searches in the UI
• AI-4345 Support multiple record selection in draft table view
• AI-4435 Indicate permission errors on draft records
• AI-4728 Compact selection of multiple-select items
• AI-4533 Local personal form views
• AI-4827 Allow display rename by pressing Enter key
• AI-4727 Synchronised personal form views
• AI-4535 Shared form views
• AI-4426 Use collection links offline
• AI-4558 [FreeW] Multiple reference fields
• AI-2777 Allow form designers to specify lookup field(s) for reference fields
• AI-4967 Database owners should exceptionally be able to set record serial numbers to any value
• AI-4719 Allow form designers to specify custom formulas as lookup field(s) for reference fields
• AI-2900 Reader mode for reviewing records in long form
• AI-4865 Default value population for imported records
• AI-4873 Allow users (with share views permission) to set a shared view as the default view for a form
• AI-4440 Deduplicator record merging
• AI-4493 Deduplication permissions
• AI-4932 [FreeW] Data entry support for multiple reference fields
• AI-5049 New sections should have default indentation equal to previous section

Bug fixes

• AI-3289 FIXED: Tableau connector does not display the record data
• AI-4156 FIXED: Audit log taking a long time to load on larger databases
• AI-4423 FIXED: Reference visibility resources that live in folders do not keep the same expected visibility behavior in collection links and grant-based roles
• AI-3343 FIXED: Reverting deletion of forms within folder fails if the folder has already been restored in another reversion
• AI-2228 FIXED: Border is not complete when form has only one field
• AI-4455 FIXED: Selecting non-populated areas in population density map will return a server error instead of not found
• AI-4469 FIXED: Notebooks do not display the pivot table data
• AI-4134 FIXED: Failed request to /resources/query/chunk does not update offline status
• AI-4475 FIXED: Counting calculated fields 2 layers deep will break the table view and data entry
• AI-4398 FIXED: Time stamp in audit log for form designer changes is incorrect
• AI-4448 FIXED: User cannot edit records if a hidden field entry is invalid
• AI-4466 FIXED: Edge browser autocomplete feature turns text input white in data entry
• AI-3817 FIXED: Pivot table containing multiple rows are cut off in the PDF export
• AI-4404 FIXED: Reauthentication window is not set to offline state when Wi-Fi connection is lost/cut-off
• AI-4318 FIXED: Incorrect or missing geodata references results in a 500 error, rather than a 400 error with details
• AI-4502 FIXED: Strings are truncated to 128 characters in calculated fields pointing to reference text or multi-line values when adding a record.
• AI-4544 FIXED: No scrollable navigation panel in Add record view.
• AI-4597 FIXED: The list of resources in manual translation mode is not displayed for roles with entire database grant
• AI-4477 FIXED: Having aggregated formulas based on subforms in the form settings will display duplicate cards of subrecords in parent data entry
• AI-4595 FIXED: Administrators are unable to manage users if a resource that was defined as a grant in a role was deleted from the database
• AI-4603 FIXED: Validation rule is not working properly for OR() function in a formula with multiple conditions set on reference fields
• AI-4632 FIXED: Data entry is blocked in forms that contain LAST() function with single select fields as argument
• AI-3210 FIXED: Side panel details are not always populated with information from selected record
• AI-4354 FIXED: Record Id is not displayed in the delete screen when deleting a record in a form without keys
• AI-4596 FIXED: Users are allowed to set invalid formulas on subform aggregations leading to duplicate records displayed in table view
• AI-4547 FIXED: Pivot table filter crashes when attempting to filter on a dimension with a large number of distinct values
• AI-4648 FIXED: Calculated fields using reference fields pointing to forms to which you only have add permission fail
• AI-2174 FIXED: Longitude's column cannot be properly resized in Table View
• AI-4678 FIXED: Exclude date values from the filter by updates
• AI-4663 FIXED: Unique pending sub-records are not checked for duplicates when adding a new parent record
• AI-4664 FIXED: Pending key records of the first parent record in a form are not checked for duplicates
• AI-4670 FIXED: Serial numbers hidden from entry are not allowing users to update records via importing
• AI-4689 FIXED: Two forms that reference each other are crashing data entry if a reference pointing to any of them is set as key in subforms
• AI-4691 FIXED: Data entry navigation box is overflowing
• AI-4692 FIXED: Self referenced forms are breaking details record panel view
• AI-4693 FIXED: Cyclic key references are not allowing users to delete records and throws maximum call stack error
• AI-4714 FIXED: Notebook view is not displaying pivot table values
• AI-4712 FIXED: Loading login page with empty email query parameter causes 500 http error
• AI-4715 FIXED: Quantities containing "0" as input are displayed as blank in table view
• AI-4717 FIXED: Subrecords of deleted parents are displayed in subfrom table view
• AI-4721 FIXED: Scrolling is not working in notebooks view mode
• AI-4725 FIXED: Sections containing irrelevant subrecords are displayed as invalid in data entry in certain conditions
• AI-4726 FIXED: Date functions YEAR, MONTH, DAY and DAYS are not displayed in the table view anymore
• AI-4718 FIXED: Unable to connect ActivityInfo to Tableau with the Web Data Connector
• AI-4729 FIXED: Inconsistent ordering for totals in report calculated measures
• AI-4730 FIXED: Subrecord cards are not displayed in data entry if the form contains any calculated fields that point two layers
• AI-4745 FIXED: Exposing orphaned grandchildren records in view all records screen if grandfather parent was previously deleted
• AI-4752 FIXED: Reference fields or any dropdowns cannot be selected with the mouse pointer due to a bug in Chrome Version 127.0.6533.100 (Official Build) (64-bit)
• AI-4755 FIXED: Fields with changed values that had default values set are repopulated with the default value every time a draft record is edited
• AI-4761 FIXED: Allow tablet users to navigate to and back from the mobile interface
• AI-4786 FIXED: Multi-line text is truncated when referenced by calculated fields in subforms
• AI-4793 FIXED: Users can assign duplicate grants via the API for grant based roles
• AI-4805 FIXED: Subforms are not displayed in collection links
• AI-3563 FIXED: Subform button is exposed when selecting the same subform in the select columns panel
• AI-4810 FIXED: Importer does not check for duplicate unique values
• AI-4812 FIXED: Three dots menu button does not work in Safari
• AI-4815 FIXED: Section header navigation is not scrollable
• AI-4523 FIXED: PDF Export fails with server error if the pivot report has only column measures
• AI-4818 FIXED: Accessing a collection link with a subform throws a 401 unauthorized error due to subrecords preview
• AI-4820 FIXED: Default values that contain space value are breaking data entry and user cannot save the record
• AI-4841 FIXED: Chained references with many paths are causing performance issues and slowness in table display and form designer
• AI-4809 FIXED: Records containing unique values cannot be edited
• AI-4819 FIXED: Deleted references set as default values in reference fields are causing the record panel to crash
• AI-4804 FIXED: Wrong display of the Ukrainian character 'ji'
• AI-4874 FIXED: Users are unable to submit a record when a calculated field's formula relies on the result of another calculated field within the same form.
• AI-4880 FIXED: Add new error string message for importer when reference record cannot be uniquely identified
• AI-4313 FIXED: DatabaseTree isResourcePresent() method causes a NullPointerException because resourceId is null.
• AI-4937 FIXED: Record history for a Multi-line text field causes a 500 server error
• AI-4915 FIXED: Prevent malformed database ids from being created via the API
• AI-4998 FIXED: Cannot import in subforms if reference points to a field with custom id set via API
• AI-4999 FIXED: Parent's user field does not display correctly in the subform table view
• AI-5005 FIXED: Dragging reference cards in reports is returning an error as formula is invalid
• AI-5013 FIXED: Records with newline characters in text fields cause long format exports to fail
• AI-5016 FIXED: Dragging reference cards in filter by section is returning an error and section is not displaying the card
• AI-5011 FIXED: Greta font file causes overlap with multiple diacritics for Ukrainian characters
• AI-5044 FIXED: Subforms set as reviewer only are displayed in collection link data entry
• AI-3352 FIXED: Logout button loses functionality in Safari mobile version after using the navigation buttons
• AI-4743 FIXED: The "Save record" buttons are not accessible on a 10" Android tablet screen when in portrait mode
• AI-5100 FIXED: Synchronization runs endlessly under certain rare circumstances
• AI-2492 FIXED: Report drop-down menu is cut after hiding one category from the list
• AI-5084 FIXED: Switching between languages in a web collection link is not changing properly the language without manually refreshing the web page
• AI-5123 FIXED: Invalid validation rules applied on irrelevant subforms are blocking data entry
• AI-5127 FIXED: Section header displayed as irrelevant when adding a new record if subform contains validation rules based on other fields in the form