Self-managed Server 4.2 Beta 3

Released on Nov 21, 2022.

Downloads

Release notes

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
• New languages: Albanian, Georgian Macedonian, Pashto, Serbian, Slovak, Bulgarian,

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