Caspio 9.8
Jul 27, 2017 • 3 minutes to readThis release includes several enhancements to improve your productivity building applications, plus a limited beta release of Triggered Actions.
Formula Field Enhancements to Support Composite Keys
In Table Design, it is now possible to set Formula Fields as Unique. This capability was highly requested in the Caspio Ideabox and is often referred to as a “composite key” – where you can create a unique field by combining multiple fields (which may or may not be unique) to prevent duplicates in the database.
Let’s say you want to set a database restriction that prevents a user from submitting more than one record per day – for a contest, timesheet, or voting application for example. As shown in the image below, you can create a unique Formula Field combining the email address (or username) of the person and the date submitted. In this scenario, the web form will not allow the same person to submit an additional record during the same day.
Learn more about Formula Fields.
Bulk Actions for Improved DataPage Management
To save you time when performing the same action on several DataPages, we have introduced a Bulk Actions menu option on the DataPage listing screen. To use bulk actions, select the checkboxes next to the relevant DataPages and choose from one of the available bulk actions: Deploy, Duplicate, Move and Delete.
Expandable Editing Area in Datasheets
To make it easier to work with long text in datasheets we have added the ability to expand text fields. Simply drag the lower right corner of the text field to expand the editing area.
REST API Enhancement for Audit Logs
A new optional header parameter named Principal is added to REST APIs. For Compliance editions of Caspio the value of this parameter will be considered the ID of the user making the call and it is stored in audit logs.
Triggered Actions (Beta)
Triggered Actions provide the ability to perform actions based on data insert, update and delete. Initially, the actions will be related to updating records in the same or other tables but we will be adding other actions such as generating email and SMS messages or performing API calls, etc.
At the current time this feature will be offered to a limited number of existing beta users for the purposes of evaluating and providing feedback. The general availability of Triggered Actions are expected to be in the next release.
Bug Fixes
| ID | Area | Description |
|---|---|---|
| 45285 | Files | Fixed issue displaying large number of files in folders |
| 48352 | Rendered DataPages | Fixed vertical alignment issue for List Data Type fields rendered as delimited values |
| 47228, 46829 | Messages | Fixed issues with viewing and deleting account Messages |
| 47274 | DataPage Wizard | Fixed issue assigning a value to virtual fields during on-load events |
| 46899 | Rendered DataPages | Fixed validation issue for date/time values in 24-hour format |
| 47593 | Automatic Emails | Fixed data sorting issue in notification emails of bulk actions |
| 48283 | Rendered DataPages | Fixed sorting issue for calculated fields with SQL subquery |
| 44939 | Rendered DataPages | Fixed issue with inserting record on Report page when AJAX is enabled |
Have a Feature Request?
Submit your ideas and feedback in the Caspio Ideabox.
