New Tweak Rotana

1. Bug fixes

- Preserved legacy screen configurations during saves and transfers, including binary IDs, custom queries, lookup aliases, encryption settings, and dormant field metadata.
- Fixed dependent lookups producing duplicate or incorrect results, losing parent context, or retaining stale display joins.
- Preserved exact large integers, decimal values, and date/time precision when editing and saving records.
- Fixed child-screen permissions, parent filtering, specialized field controls, formatting, and navigation behavior.
- Corrected inline-table relationships to use saved parent values and reliably restore existing selections.
- Fixed gallery duplication affecting source records, primary-image updates crossing gallery scopes, and partial upload failures losing saved-record identity.
- Strengthened file deletion authorization and prevented duplicate flows from deleting source files.
- Fixed chart aggregation truncation, timestamp grouping, text identifiers, field dependencies, parent filters, and stale exports.
- Corrected PDF readability for wide reports and ensured booking reports respect configured column labels, visibility, and order.
- Fixed clearing layouts, removing all sortable fields, and disabling exports so those changes persist correctly.
- Corrected export permission enforcement and hidden-screen visibility in navigation.
- Fixed before-save automation changes not reaching the database and restored omitted saved fields in automation context.
- Corrected scoped uniqueness checks for edits, explicit null values, and duplicated records.
- Fixed conditional calculated-field handling of nulls, boolean values, filtering, sorting, and legacy aliases.
- Fixed screen creation and transfer identity handling within menus.
- Hardened cell and HTML rendering, preserved password masking, and aligned legacy field notes with their controls.
- Fixed notification image payloads for iOS.
- Repaired and expanded database-backed screen-save and transfer regression checks.

1. New features

- Added configurable charts and figures, including line, area, bar, pie, donut, mixed charts, and summary figures, with dataset bindings and SVG/CSV exports.
- Added chart rendering in child screens and record selection for actions in chart mode.
- Added in-place session reauthentication that preserves compatible unsaved work and refreshes access after login.
- Added configurable screen access rules and required filters that must be completed before loading data.
- Added server-enforced hidden filters supporting multiple allowed values.
- Added configurable date/time display formats with presets, custom patterns, and previews.
- Added conditional calculated columns with filtering, sorting, and export support.
- Added configurable signed guest PDFs with signature, date, and location overlays, plus customizable document button labels, order, and visibility.
- Added atomic exclusive-value rules to keep one matching record active within a configured scope.
- Added automation capabilities to read stored or related record values and count matching or distinct records.
- Added validation comparisons between fields, fixed values, and automation results, including allowed/excluded value lists.
- Added guided controls for configuring scoped uniqueness rules.
- Added copying ordered export-field selections between PDF and Excel.
- Added optional parent-scoped lookup display joins.

1. Bug fixes

- Preserved legacy screen settings and binary IDs during saves.
- Fixed empty layout, sorting, export settings, and configured PDF columns.
- Fixed parent relationships and missing dependency/lifecycle context.
- Fixed gallery duplication, partial upload handling, primary-image scope, and navigation visibility.
- Fixed chart aggregation truncation and UTC time grouping.
- Fixed dashboard label clipping and added immediate hover/focus values.

1. New features

- Dependent lookup filters, fixed conditions, and optional unique values.
- Shared condition help, multi-value editing, and NULL comparisons.
- Nested access-scope condition groups.
- Optional beforeCommit validation locking, with rollback when validation fails.
- Access-scope value mapping between tables, rejecting missing or ambiguous mappings.
- Dashboard chart ordering updated: I-Sign first, with exports alongside the first chart.

1. Bug fixes

- Preserved report and filter references when a field is renamed.
- Removed generated fields correctly when saved report totals are deleted.
- Kept numeric `0` distinct from empty summary values.
- Repaired missing lookup display projections, including legacy/union cases.
- Preserved blank and whitespace virtual-column separators.
- Prevented closed filter panels from consuming layout space.
- Improved wording for report completion, required filters, and XML preview guidance.

1. New features

- Added metadata-backed, searchable column selectors throughout the Screen Builder.
- Added read-only report grouping for multi-table and union-report screens.
- Added configurable display defaults for null field values in grids, views, and exports.
- Made existing filters editable in the Screen Builder.
- Added chart calendar-gap filling and chart-total export support.
- Added grouped totals / summary reports, respecting filtering and tenant scope.
- Added multiple-choice filters and conditional date-range behavior.
- Added safe date-XML and currency/money value formatting, with previews.
- Added fallback-source handling for missing relationship matches, excluding fallback rows when a primary match exists.
- Added record-change history with actor details and change flags.
- Made queued related writes execute inside the row transaction.
- Added grouped-report export setup, validation, full bounded export data, and accurate currency totals.

1. Bug fixes

- Fixed summary default sorting so it remains stable after saving.
- Ensured hidden grouping fields are correctly respected in summary tables and exports.
- Applied missing match exclusions inside each `UNION` query branch.
- Preserved `UNION` view fields and related-screen links through builder edits and screen transfers.
- Prevented chart dashboards from clipping their content.
- Fixed exact record selection for `UNION` views and linked screens.
- Reused summary protection metadata within a dataset request for more consistent and efficient summary processing.

1. New features

- Added `OR` logic and null checks to Screen Builder join conditions.
- Added an explicit All filter choice and optional "load only after Apply" behavior.
- Added an optional "only write history when the value changed" setting for record history.
- Exposed and preserved filter input types across the Screen Builder and transfer flow.
- Added reusable calendar-day conditions for calculated/virtual fields.

1. Bug fixes

- Preserved UNION component filters during Screen Builder saves and screen transfers.
- Kept unique lookup displays to one match per stored value and preserved unique lookup settings when column editors are reopened.
- Prevented ambiguous related-field joins from returning duplicate or mismatched data.
- Prevented Firebase notification POST replay, rejected unreadable integration journals, and preserved staff-notification tenant context during shutdown auditing.
- Corrected Members flows for duplicate Exclusive enrollments, other-program Discovery accounts, multiple memberships on one account, SQL-free View fields, missing-profile messaging, legacy form eligibility, and Suspended renewals.
- Fixed dependent-filter allowlisting when the same dataset table is used more than once.
- Fixed chart keyboard entry and removed overlap with native browser tooltips.
- Removed internal primary-key badges from dynamic editor field labels.
- Fixed STARTTLS email delivery against the configured SMTP host.
- Preserved binary UUID screen identities through Screen Builder saves and screen transfers.
- Normalized missing booking currencies and kept booking totals and fees assigned to the correct currency.
- Hardened repeated LIKE and NOT LIKE pattern filters, including wildcard escaping, encrypted values, and server-side validation.
- Restored the legacy tenant-local Azure SSO configuration model while retaining strict configuration validation and local-account security checks.

1. New features

- Added confirmed status changes for selected or all matching records, with a server preview count, transactional validation, auditing, and automatic refresh.
- Added search for long runtime select lists while preserving their native stored values.
- Extended signed guest PDFs with row-driven placement, multi-page signatures, relative captions, and authenticated protected-document previews.
- Added an automation that assigns the first available whole-number value within a configured parent scope.
- Added guided single-table related fields using filtered unique matches.
- Added background staff-notification delivery through Firebase, including post-save queueing, delivery status, and manual refresh.
- Added Colleague profile synchronization and guided enroll, activate, and deactivate actions.
- Added a Members service-backed directory with provider search, guided enrollment, editing, reset, renewal, upgrade, payment/cash flows, and enrollment reporting.
- Added related-table parent support for dependent lookup choices.
- Added a tenant-granted self-service two-factor authentication settings screen.
- Added accessible dynamic chart hover and keyboard tooltips.
- Added Rotana Users actions for sending notification emails and password-reset links.
- Added App Bookings report totals grouped by currency.
- Added implicit linked-screen foreign keys derived from saved parent-child relationships.
- Added Web App Users actions for disabling accounts and resetting passwords.
- Added repeated filters on the same field and SQL pattern operators using % and _ wildcards.
- Added tenant-gated Microsoft Entra sign-in using validated tenant-local configuration and existing Tweak user accounts.