For building no-code database apps, RecordsManager supports scripting in data entry forms to perform actions based on entered data. In the latest version, scripting functionality has been extended significantly.
To allow scripts to react based on data that app users enter, new script branches (if / then / else) have been introduced. With this implementation, complex conditions can be configured easily using a completely visual scripting editor.
New functionality includes:
- Script branches (if / then / else conditions). In each branch, the app administrator defines a set of conditions. For each case (true and false), the script will carry out, as appropriate, any of the actions available for that type of script (see the screenshot below).
- Scripts can be executed when a record is saved. The script is used to modify other field values of the record and/or to send emails.
- Scripts can send emails using email forms defined by the admin.
- Scripts can save records.
- Scripting can be used to trigger creation, modification, or deletion of child records.
- A new $CurrentUser variable can be used in script branches or User field assignments.
- Buttons can be created to execute scripts (e.g., Send Email, Save and Continue, etc.). When a button is clicked, its script can modify field values of the record, create or delete records, send emails, or display messages.
- Changes made via automated scripts can be highlighted for end users.
- New conditions are available for scripting actions: Is Record Valid, Is Record New, Has Field Changed.
- Scripting can be used to show messages (standard, warning, error).
All scripting is configured via a straightforward visual scripting interface, as shown below.
The new, extended scripting functionality in RecordsManager 2.0 gives administrators even more tools for defining sophisticated functionality to react to user input in real-time and implement intelligent automation.
