The Linked Tables Settings section provides a range of options for managing the behavior, storage, and editing of data in linked tables. These settings allow users to customize how data is handled, ensuring flexibility and control in both runtime and design environments.
Key Features:
1. Use Trash
- Purpose: Temporarily stores deleted items in a “trash” section instead of permanently removing them.
- Benefits:
- Prevents accidental permanent deletions.
- Allows users to restore deleted items or remove them permanently at a later time.
2. Check Before Delete
- Purpose: Displays a confirmation dialog whenever a user attempts to delete an item from a linked table.
- Benefits:
- Ensures intentional deletions.
- Acts as a safeguard against accidental data loss.
3. Enable Data Edit
- Purpose: Controls whether data in linked tables can be modified during runtime.
- Options:
- Enabled: Allows dynamic updates to linked table data during runtime.
- Disabled: Keeps data static during runtime, restricting modifications to the Design section.
- Use Case: Ideal for projects where real-time data updates are required or when maintaining static data integrity is necessary.
4. Data Storage
- Purpose: Specifies where the linked table data will be stored.
- Storage Options:
- Native Database (MongoDB): Default option for storing linked table data.
- Microsoft SQL Server (MSSQL): Provides the flexibility to store data in an external MSSQL database.
Benefits:
- Data Safety: The Use Trash and Check Before Delete options prevent accidental data loss, offering a layer of protection during data management.
- Customization: Users can control the editability of data during runtime, enabling dynamic or static workflows based on project needs.
- Storage Flexibility: Supports integration with different database systems, allowing users to align with their existing infrastructure and preferences.
This section ensures that linked table data is managed efficiently and securely, enhancing usability and providing control over critical data processes.