v1.68.11 — Rapid Platform
We're excited to announce new features live on Rapid Platform Wednesday, November 18th
Features
Classified columns
Administrators can now mark columns that hold sensitive information, such as salaries or personal details, as classified. Set up your site's classification types under Maintenance → Data Classification in Designer, then pick one under Data classification in a column's settings. Learn more about Classified Columns
Each classified column has its own Read, Edit and Create permissions, separate from the rest of the table. Create lets someone enter a value on a new item without being able to see it afterwards, and Edit always includes Read.
- People without Read access see a lock and "You don't have permission to view this value" in place of the value, in both Explorer and Experience Host, so a hidden value is never mistaken for an empty one
- Withheld values are also kept out of filters, sorting, search, charts, CSV exports and item history
- Access is enforced by the platform itself, so integrations and AI agents acting for someone get no more access than that person has
- Classified values are cleared when a site is copied to a test site
Per-row access for classified columns
A classified column can also grant access one item at a time. Under Per row in the column's Data classification settings, choose a classified User column or Created By: whoever that column names (a person, or a group they belong to) gets Read or Edit on that item's value. For example, combining Create access with a per-row grant through Created By lets staff enter a value and see only their own entries afterwards.
Filtering, sorting, search and charts on a classified column still need access to the whole column.
Computed columns can't be classified, so a computed column built from a classified column will show what it's built from. Public forms run as the application account and aren't limited by classification.
E-mail files from more than one folder
In the File Browser, files you tick now stay ticked when you open another folder. E-mail Files and Share attach every ticked file across all folders, and the button shows the total, for example "E-mail 2 Files". A Clear Selection button appears when you have files ticked in other folders. Rename, Edit, Delete and Details still only act on the folder you have open.
Subquery checks in Designer
The subquery editor has been rebuilt with syntax highlighting, autocomplete from your site's tables and columns, and warnings for common patterns that make subqueries slow or wrong:
- A redundant
IS NOT NULLcheck next to a comparison on the same column, which can be fixed in one click - A join that never refers to the table it joins
Warnings also appear in the columns list, and Test with now shows how much database work a subquery costs for one item.
Improvements
- Creating and deleting tables is much faster on large sites and no longer times out, with a progress bar while it finishes
- Searching lookup columns is much faster, especially for uncommon search terms
- Saving items and loading linked items use far less database time
- Linked item data takes up much less space in the database, making saves faster on large sites
- SharePoint sync recovers more smoothly when SharePoint limits requests, rather than retrying the same work over and over
- Creating and repairing a site now waits out SharePoint throttling instead of failing
Bug Fixes
- Fixed an issue where items linked by universal link (such as Notes on a record) didn't load in Experience Host
- Fixed an issue where unsaved changes could be lost when opening a tab in an Experience Host document for the first time
- Fixed an issue where default values and progress restored with Save Progress weren't saved when an Experience Host form was submitted
- Fixed an issue where multi-line text and embedded files in repeating sections loaded empty in Experience Host
- Fixed an issue where files in repeating sections showed no thumbnails or previews in Experience Host
- Fixed an issue where search stopped checking columns after the first multi-select column
- Fixed an issue where deleting a table straight after creating it could fail and leave the table behind
- Fixed an issue where changing a field's column name through the API returned a server error instead of a clear message
