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.