In this release, Caspio provides the ability to create relationships between Tables to ensure your associated data always remains connected. The Relationships drag-and-drop interface makes it easy to add new relationships by simply dragging fields from one table to another.
Once Relationships are set at the table-level, you can easily create Views, Forms and Reports that automatically preserve the important associations between all your data.
Caspio supports both one-to-one and one-to-many relationships. When creating one-to-many relationships, you have the option of displaying values from the parent field in the related table’s dropdown.
Additionally, you can protect one-to-many relationships by enforcing Referential Integrity, which prevents orphaned data and keeps all references in sync. Table Relationships can be imported and exported to/from Microsoft Access.
In addition to Table Relationship joins, Views also support more join types:
- Inner Join: Default join type which includes only matching records which are present in both Tables.
- Left Outer Join: Includes all records in Left Table and only matching records in Right Table.
- Right Outer Join: Includes all records from Right Table and only matching records in Left Table.
- Full Outer Join: Includes all records in both tables, even if no other matching record exists.
When Relationships are set at the table-level, the field associations and join types will be automatically populated when creating Views and DataPages. Learn more about creating Views.
General, Integer and Currency Number Types
New Number data types were added to support additional numeric formats:
- General: Default for general numbers up to 15 digits including decimal places.
- Integer: Integer numbers without decimals, up to 10 digits.
- Currency: Monetary data, up to 15 digits and 4 decimal places.
The new Number types are configurable in Table Design below the field list.
Delete Multiple Records in Datasheet View
It is now possible to delete multiple records at a time in Datasheet view using multi-select checkboxes. You can also easily narrow down unwanted records by applying filters and using the new checkboxes to delete the filtered set.
Image Alt Attributes
Caspio-powered images can now display rollover text using a new Image Alt attribute. Image Alt attributes are helpful when deploying for SEO and Section 508 compliance to support visually impaired individuals using screen readers.
Additional Enhancements and Bug Fixes:
|13476||Calendars based on a table with one TimeStamp date field are now supported.|
|13469||Table Properties screen now displays full folder names for associated DataPages.|
|13463||Invalid XML file is prohibited during DataPage import.|
|13436||Reports can now be grouped by Timestamp field and Timestamp fields can be used as a Category in charts.|
|13411||In Datasheet, “Page down” key is now fully supported on all browsers.|
|13404||In Destination Page configuration, calculated fields are no longer incorrectly appearing in the field insertion dropdown.|
|13387||Radio button values with ampersand and apostrophe symbols can now be passed as parameters to the Destination Page URL.|
|13376||In Datasheet, HTML that contains data with special characters is now handled correctly.|
|13362||In the Style wizard, users can now adjust the padding for a Field Cells container.|
|13345||User can now choose any DataPage as the destination after Web Form submit.|
|13291||In search forms, the Date/Time data type is now allowed in dropdowns for timestamp fields.|
|13290||Users with DataPage edit and execute permissions can now preview DataPages in Revisions.|
|13289||In Search forms, TimeStamp fields can now be used as parent dropdown by setting precision to “Date and Time”.|
|13288||In Search and Report, TimeStamp fields are now correctly validated when configuring dropdown custom values.|
|13263||API Profile passwords now prohibit quotation marks.|
|12691||In Results pages, aggregation now works correctly for grouped fields starting or ending with a space.|
|13097||When exporting to Microsoft Access, the export wizard now includes a warning alert when tables exceed maximum data limits of Access MDB files.|
|13291||In Search forms, a Date/Time field can now be used as a value in a TimeStamp dropdown field.|
Questions or Comments?
Submit your ideas and feedback regarding product features in the Caspio Ideabox.