Full-text search improvements:
- An index for full-text search can now be created. When creating an index in the constraints setting for a table, you can select "Full-text search" in the field selector. This will dramatically speed up search on large tables.
- Use websearch_to_tsquery if available. This is a more natural and modern syntax.
- Link to syntax examples in /search
- Use default locale's language for search localisation.
- Option to show results in tabs in search configuration.
select_by_view fieldview for Key fields: the user selects the value of a Key field based on an clicking in a row of rendered views (typically a Show view) of the joined table. Works for both Edit and Filter views.
Click to edit (Show and List view patterns) is now implemented by rendering the first available edit fieldview. This should be more robust and work with more data types.
Data in the admin's data edit grid is now loaded by page. This makes it possible to work with much larger datasets.
You can now permit to non-admin (role ID > 1) users to edit or inspect tables, or edit views, pages or triggers. In the permissions tab of the Users and security settings, minimum roles can be set for these capabilities. The appropriate menu items will be added to any users with the roles that match these permissions.
Stored calculated fields that contain joinfields in the expression are now automatically updated when the values they reference are changed, i.e. changes occur in the tables they reference. This is limited to single (expression contains x.y) and double joinfields (expression contains x.y.z). In most cases, you can now remove all recalculate_stored_fields actions.
Builder:
- Add ability to set custom id on containers. This is useful for scroll targets
- Add animations tab to containers. All animations are activated on scroll
- Tabs and multi-step actions implement a new interface that lets you move, delete and add steps/tabs.
Workflows:
- APIResponse step type. Provide the API response
- Stop step type. Stop workflow immediately
- EditViewForm step type: run a form from an Edit view, add respnse to context
- Call other workflows in a workflow step. Control subcontext for called workflow
- Error handling. SetErrorHandler step type, which set the step invoked on errors
- ForLoop step type for loops over arrays.
- Varius UX improvements for editing workflows
- Integrate copilot, if installed, in workflow editing
- Call non-workflow trigger actions.
sbadmin2 theme - Color update: dark side bar, darker primary blue
AppChange event, runs every time a view, table, trigger, page or configuration value is changed.
Mobile builder:
- PJAX view loading: Use pjax for all functions like on the web version.
- Share content to your app on mobile and PWA.
  - Ensure at least one ReceiveMobileShareData trigger exists when the app is built or the PWA is installed.
  - Shared content is accessible via the row variable.
  - Android: No additional configuration is needed.
  - PWA: Ensure a trusted HTTPS connection is used.
  - iOS:
    - A second provisioning profile is required, with the bundle ID of the main app followed by share-ext (e.g., com.saltcorn.share-ext).
    - The iOS project needs a Share Extension target. To set this up, open Xcode and add a Share Extension target from a template (more documentation is is about to come).
    - The build will stop when the Xcode integration is required, and a "Finish the Build" shows up.