September 28, 2016

This release includes new features, minor enhancements, and bug fixes.

Release Notes

NEW FEATURES

Formula Fields in Tables

A new “Formula” data type now supports calculations at the table level. In Table Design, you can create Formula fields using functions, constants, and values from other fields in the same record.

formula_field_211

Formula fields automatically calculate values based on your defined expression whenever records are inserted or updated in the table (through Table Datasheet, DataPages, Data Import, Scheduled Tasks, or API).

Watch the video below to see how to create formula fields in Caspio:

If you don’t need to store the calculated values in your tables, you can still use Calculated Fields to compute values on-the-fly and display them in Reports and Details Pages.

This feature is available in all plans.

Learn more about Formula Fields.

Fixed Columns in Reports

To improve usability of Tabular Reports with lengthy or wide search results, you can now enable “Fixed Columns” to keep a certain number of columns within view at all times. Similar to enabling Sticky Header Row, a new option for Fixed Columns has been added to the Report DataPage wizard.

fixed_rows_and_columns111

You can also customize the behavior of Fixed Columns in the Styles wizard, such as the divider line styling and the minimum scroll width.

This feature is available in all plans and applies to Tabular Reports only.

Learn more about Fixed Columns.

Formatting and Localization for Data Downloads

Prior to this release, data downloaded from Report DataPages contained no formatting. Starting in version 9.4, downloaded files can follow the same formatting settings as shown on the DataPage. This feature is available in all plans.

data_formatting1

New POST Option in SAML Single Sign-On

In SAML single sign-on authentication, we have added a new “POST” method (in addition to the previous “Redirect” method). This feature is available in Corporate plans and higher.

MINOR ENHANCEMENTS

  • Sticky Header Row (released in version 9.2) is now also available in Pivot Table Reports.
  • Password Recovery DataPages now have the ability to insert fields and parameters in the Destination Page URL.
  • To protect data integrity, lookup tables used as Display Values in Relationships can no longer be detached from Apps.
  • The width of the Bulk Edit dialog has been increased to reduce instances of horizontal scrollbars.
  • This release also includes security and compatibility updates.

SELECT BUG FIXES

ID Area Description
29699 DataPages Fixed issue in cascading elements, where child values did not filter properly when parent field was a radio button.
26173 Automatic Emails Fixed issue in notification emails, where emails did not send if the “To” address was a field parameter containing multiple emails separated by semicolon.
28188 Caspio Bridge User Interface Fixed issue in DataPage Wizard, where Prefixed Autonumber fields did not display in the parameter picker options for text fields.
28457 DataPages Fixed issue in Report DataPages, where “Edit” and “Delete” icons did not display on mobile devices.
28557 DataPages Fixed issue in Details Pages with Virtual Fields, where assigned default values did not insert properly in dropdown and radio button fields.
28585 DataPages Fixed issue in Reports with Sticky Header Row enabled, where report did not align properly when using <DIV> tags to center the DataPage.
29240 Relationships Fixed issue in Table Relationships dialog, where enabling Display Values caused a delay.
29148 Scheduled Tasks Fixed issue in scheduled import of Excel files, where Text(255) fields containing both letters and numbers did not import when first row contained field names.
29030 DataPages Fixed issue in Reports with Grid Edit enabled, where data in hidden fields was blank if the row was edited, saved, and re-edited again.
29496 DataPages Fixed issue in Tabular Reports with Inline Insert enabled, where cascading elements did not filter child values properly in dropdown fields.
29680 DataPages Fixed issue in Report search forms, where cascading listboxes with multi-select enabled did not filter properly.
30185 Automatic Emails Fixed issue in notification emails, where values from Calculated Fields did not load in fields inserted into the email body.
29979 Caspio Bridge User Interface Fixed issue in DataPage Wizard, where Image Resizer settings were not saved correctly after editing.
29292 DataPages Fixed issue in Reports with Sticky Header Row enabled, where the header displayed incorrectly when deployed to WordPress and viewed in IE 11.
29397 PDF Reports Fixed issue in PDF Reports, where emails did not send if the “mailto” parameter began or ended with a semicolon.
24319 Import/Export Fixed issue in Import/Export, where Views created or edited during version 8.3 could not be re-imported.
29401 DataPages Fixed issue in parameters, where fields from authentication data source containing HTML did not render as properly in the DataPage Header/Footer.
28761 Caspio Bridge User Interface Fixed issue in editing or importing certain DataPages created prior to the introduction of Sections.
28416 DataPages Fixed issue in Reports with Inline Edit enabled, where incorrect error appeared when updating records containing Date/Time hidden fields without a default value.
30299 REST API Fixed issue in REST API, where searching for some keywords using “LIKE” operator did not return proper results.

IMPACTED AREAS

Refer to the 9.4 Impacted Areas article for more information about the areas affected by this release.

HAVE A FEATURE REQUEST?

Submit your ideas and feedback regarding product features in the Caspio Ideabox.