Self-Managed Server 4.2
The 4.2 release series is based on the SaaS Build 2874 from April 2024.
Download 4.2.0
| Windows MSI | Download | Installation instructions |
| Ubuntu/Debian | Download | Installation instructions |
| RedHat/CentOS | Download | Installation instructions |
| Self-contained JAR | Download | Installation instructions |
| Docker | Docker Hub | Installation instructions |
Release notes
4.2.0 (Apr 22, 2024)
Summary
- Importer enforces relevance, validation rules and locks
- Grant-based roles with condition editor
- Pivot table filters
- Calculated measures
- Calculated tables
- Reverse Reference Fields
- In-Place Reference Record Creation
- Relevance conditions for subforms
- Relevance conditions for section and sub-sections
- Unique constraints for fields
- Default values for fields
- New languages: Albanian, Georgian Macedonian, Pashto, Serbian, Slovak, Bulgarian
- Branding options with logo and login page text
Security
- AI-4005 Disable TLS 1.0 and 1.1 and weak ciphers vulnerable to LOGJAM
API
- AI-3231 FIXED: Importer and update APIs accept invalid dates
- AI-3232 FIXED: PowerBI API fails if results contains dates that are not well-formed
- AI-3277 FIXED: Import records job should provide feedback on invalid updates
- AI-3303 FIXED: R queryReportResults function is not reading in all field characters
- AI-3375 FIXED: The API should validate form schema updates
- AI-3491 FIXED: It should not be possible to create a role with a NULL ID though the API
- AI-3633 FIXED: Not providing the parameter range when updating via the API crashes the User management view
Audit log
- AI-3202 FIXED: If a user leaves a database or deletes himself from the user list, this event should be added to the audit log
- AI-3307 FIXED: Cannot revert deleted Roles in the audit log due to malformed request sent
- AI-3889 FIXED: Recovering records in audit log fails
Offline availability
- AI-3121 FIXED: Fix handling of deleted/updated records
- AI-3439 FIXED: In some cases, an outdated offline cache can prevent the application from loading
Collection links
- AI-3172 FIXED: Stack overflow when trying to access collection link in a form with circular reference
- AI-3362 FIXED: Collection link forms do not have a language selector
- AI-3682 FIXED: Referenced locked records cannot be selected in collection links
Dashboards
- AI-3093 FIXED: Incomplete rendering of dashboard maps
- AI-3131 FIXED: Cannot move dashboard reports in synced databases
- AI-3151 FIXED: Fix Dashboard centering in view mode
Data Entry
- AI-2844 In-Place Reference Record Creation
- AI-2588 FIXED: User is allowed to save edited record after entering incorrect option
- AI-3137 FIXED: Key fields longer than 130 characters are not updated/matched
- AI-3198 FIXED: Make database owners visible in user type fields
- AI-3204 FIXED: Cannot add records when having a calculated field with a longitude or latitude formula
- AI-3213 FIXED: Partners are unable to add data in 3rd layer subform that re-references the partner form
- AI-3233 FIXED: Referenced subforms that are not keys are not displayed in add record screen
- AI-3272 FIXED: Reference data is not correctly validated in data entry if the reference data is selected from bottom to top
- AI-3380 FIXED: Formula is not uglified for validation rules and can break data entry page
- AI-3435 FIXED: The API allows submission of duplicate serial numbers
- AI-3667 FIXED: Adding a second subrecord in a subform that contains a serial number field will break the subrecord card display
- AI-3735 FIXED: A hidden field with a validation error should not prevent a record from being saved
- AI-3923 FIXED: Users with explicit form grants do not have access to user form in data entry while offline
- AI-3998 FIXED: Subform relevance rules are incorrectly transformed when the relevance rule contains a reference to the parent record
- AI-3023 FIXED: Sections appear as completed even when having invalid fields
Database setup
- AI-3930 FIXED: Users can move away without saving changes made on permissions on role cards and extra user grants from database design page
- AI-3373 FIXED: Fix text color in different areas of AI
- AI-3490 FIXED: Missing loading indicator for database and folder pages
- AI-3868 FIXED: Exception when viewing database page of which contains a public form
- AI-3451 FIXED: Date range locks inactive functionality doesn't work when there are other active date locks present on the same form/folder
- AI-3869 FIXED: Duplicating databases with error in formula fails
Exporting
- AI-3551 Export reports as XLSX
- AI-3469 FIXED: Export all quantities fails with server error message
- AI-3475 FIXED: Export menu is cut off if a form with a high number of subforms
- AI-3517 FIXED: Export CSV option is not present in report view
- AI-3542 FIXED: Export all attachments fail if there is more than one file with the same name but no extension
Form designer
- AI-2457 Relevance conditions for subforms
- AI-2563 When selecting a reference Form, automatically scroll right
- AI-3250 Reverse Reference Fields
- AI-3251 Form Field Duplication
- AI-3786 Allow form designers to constrain attachment fields to a single type of upload (i.e. file upload, camera image upload, or signature)
- AI-2596 FIXED: Reference field should clearly state if a Form has been deleted or if user does not have access to the Referenced form
- AI-2861 FIXED: Formulas referencing complex calculated fields slow formula designer
- AI-2935 FIXED: Table view crashes if a form references itself or another form with circular reference
- AI-3142 FIXED: Two cards can be opened at the same time in form design
- AI-3176 FIXED: Combination of subform referencing and 3rd layer reference breaks the add records screen
- AI-3185 FIXED: Setting up relevance rules with empty value breaks the form designer
- AI-3186 FIXED: Add field button disappears in form design after deleting a field while the card selection is open
- AI-3240 FIXED: User can exceed field type limitations when pasting from spreadsheet
- AI-3242 FIXED: If a selection field has 2 options, where option 2 ("1.b") starts with a name of option 1 ("1"), then formula "selection.1" is invalid
- AI-3350 FIXED: Form designer breaks when setting a validation rule on a Single select field that refers to itself
- AI-3395 FIXED: Importing section headers with relevance rules breaks the form designer
- AI-3405 FIXED: Long field labels can cause spacing issues in the form designer
- AI-3421 FIXED: Fields cannot be set as key if they contain relevance rules
- AI-3423 FIXED: Form duplication feature duplicates the ID's of the options in select type fields
- AI-3424 FIXED: Error message displayed when reordering in keys with relevance rules in form designer
Formulas
- AI-3244 Add GREAT_CIRCLE function to compute distance between two lat/lng points
- AI-3427 Calculated tables
- AI-2497 Add help link in Formula Editor for ISBLANK
- AI-2806 Support dates for MIN() and MAX()
- AI-3591 FILTER() function for calculated measures
- AI-3631 LOOKUP function
- AI-3640 ADDCOLUMNS() function
- AI-3669 LAST function
- AI-3670 FIRST function
- AI-3187 FIXED: timestamp _lastEditTime cannot be added in formulas with reference forms
- AI-3209 FIXED: REGEX functions when multiple records are present
- AI-3574 FIXED: Include access to user email in formulas for user fields
- AI-3797 FIXED: Comparisons between select field types amongst parent and subform does not correctly filter the view for subform records
- AI-3857 FIXED: Calculated field with string formulas or simple calculations are not displayed in the data entry for both mobile and web versions
- AI-3917 FIXED: Subform aggregation formulas do not work with other formulas in relevance and validation when adding new record
Importer
- AI-2324 Importer enforces relevance and validation rules
- AI-3177 Remove fuzzy matching from the importer
- AI-3252 Support update of records based on serial number when importing records
- AI-3340 FIXED: Months in different format are not parsed correctly
- AI-3386 FIXED: Importer doesn't enforce Date range locks and Rule based locks
Localisation & Translation
- AI-3227 Add Pashto language
- AI-3413 Add Slovak Language
- AI-3736 Add Bulgarian language
- AI-3946 Add Balkan languages (Albanian, Macedonian, Serbian, Georgian)
- AI-3351 FIXED: "Forgot password" and "Change" buttons are not translated in any language for the login page
Login
- AI-2957 FIXED: Login screen freezes due to URL not being well constructed
- AI-3169 FIXED: URL is incorrectly constructed when accessing a bookmark following SSO-based login
- AI-3498 FIXED: The Switch account button doesn't re-direct the user to the previously accessed URL of the Report
- AI-3404 FIXED: Accessing an invalid application page doesn't display the "not found" page
Maps
- AI-3494 FIXED: Maps fail to load for certain versions of Safari when WebGL is disabled
Mobile app
- AI-2776 FIXED: Cannot refresh on the mobile app
- AI-3589 FIXED: Database list in mobile app has no empty state
- AI-3794 FIXED: Implement empty states for databases/forms which are not available due to no connection
- AI-3787 FIXED: When offline on a mobile device, databases which have not been downloaded are still selectable but show an empty screen when clicked
- AI-3801 FIXED: Implement missing non-ideal states for mobile app
- AI-3967 FIXED: Submit request should be sent only once when pressing submit on mobile
Permissions & User Management
- AI-3118 Grant-based roles
- AI-3486 Condition editor for roles in grants
- AI-2577 Include role parameters in user export
- AI-2826 FIXED: Permissions card in user management shows incorrect permission as preview
- AI-3102 FIXED: Fix deactivated users that are counted towards the user limit
- AI-3129 FIXED: Reports that contain forms with public permission are not viewable when published
- AI-3521 FIXED: "Edit report" button is misleading for users who can save a copy but are not allowed to edit a shared/database report
Table view
- AI-2956 FIXED: Table view of subform with certain combination of the keys from parents and other subforms crashes
- AI-3288 FIXED: No record selected sub-text is hidden in the background color of the side panel
- AI-3661 FIXED: Sorting quantity fields with blank values results in incorrect ordering
- AI-3732 FIXED: The filter is not automatically removed when deselecting last option in filter by menu
XLSForm import
- AI-3344 FIXED: Improve XLSForm Import
- AI-3840 FIXED: XLSForm importer breaks if curly quotes are used in formulas instead of straight quotes