Removal of the EXECUTESQL, ABRIRZOOMSQL, and UPDATEGRIDZOOMSQL functions
The EXECUTESQL, ABRIRZOOMSQL, and UPDATEGRIDZOOMSQL functions have been depreciated in February of 2020.
From December of 2022 onwards, in version 2.2.0, they will no longer work. It will not be possible to add or edit formulas with these functions.
Instances in progress will not be affected.
The change is necessary to avoid users using SQL commands directly in the formula text, improving system security.
New functions have been created to replace the obsolete ones, and they are available since version 2.1.3.
Responsive form import
From this version onwards, it is possible to import a responsive form from one SoftExpert Suite database to another.
For example: Exporting from a release environment and applying to a production environment.
In this first version, the web service configuration is not imported. For datasets, the system checks if it already exists in the database to perform the correlation.
These restrictions will be met in future versions. To perform the import, simply access the responsive form editor and click on "Import".
API to add, edit, and view records by form
From this version onwards, it is possible to create analyses (SoftExpert Analytics) with form records and add a link to open the record data.
Three APIs have been created based on consumption URLs: the first one is to add new records, the second allows creating a link to edit an existing record, and the third allows opening the data to view the record only.
It is worth noting that it is necessary to have access to the SoftExpert Form menus, as well as permission to access the records.
Decimal places displayed in the old form grid
The old form grids now display decimal places according to the precision configuration set in the subform.
It is worth noting that this improvement is applied only to grids displayed within the form.
Precision of decimal places in the table field for use in the responsive form
From this version onwards, the decimal place precision configuration has been added directly to the table field.
This configuration is used only by the responsive form to display the number of decimal places in the subform grid and fields.
Configuration to block the addition of duplicated records with the exception of null values
It is now possible to configure a table field to block the addition of duplicated records with the exception of null values.
Until now, the block was made for any records.
This improvement aims to meet the imports of several records to a form grid/table with null values, when the duplicity must be avoided when editing each record individually.
Responsive form in SoftExpert Document
From this version onwards, the use of the responsive form in the document category has been made available.
Until now, it was only possible to use the old form (non-responsive).
This improvement allows creating documents using a form with a better layout, increasing the usability.
Previous versions
View also the improvements made to this component in previous versions:
