Create Relation
MTO Create
Interface that allows users to create a relation between the current item and a single item from a single table.
To create a new Relation, follow these steps:
Step.1 Go to the table and click the settings button on the top right corner.
Step.2 Select the 4th section, “Relation”.
Step.3 If you have already created a relation, it will appear in the table. Otherwise, click the “+Add” button.
Step.4 A form with 6 fields will appear, which you need to fill out:
Label from: Label display in current table layout .
Label to: Label display in connected table layout.
Table from: The table which data will be taken (this is automatically selected).
Table to: The table you are relating to.
Relation type: The type of relation (e.g.,M2O, M2M).
View fields: Choose which fields will be displayed.
There are also two checkboxes to consider:
Disable edit table: Prevents edits to the table.
Enable multi-language: Enables support for multiple languages.
This all falls under the Schema section.
Step.5 In addition, there’s an Additional section with four checkbox options:
• Disabled - if user enable “Disabled”, this function disables the relation for the selected field, preventing any further interaction or association with that field.
• Default editable - This checkbox in the relation section determines whether the related field is editable by default. Enabling it allows users to modify the related data directly, while disabling it restricts editing permissions.
• Creatable - If user enable ‘Creatale’, when enabled, automatically generates a ‘Create’ button during search operations. If the user searches for an item (e.g., a client) that does not exist in the current table (such as the product table), the “Create” button will appear. Selecting this button redirects the user to the appropriate table (e.g., client table), enabling them to add the new item directly.
• Relation button -This option determines whether a button is displayed to access or manage the related data. Enabling it allows users to quickly navigate to or interact with the associated items in the related table.
Step.6 There’s an Auto-filter section for applying filters automatically.
The Auto-filter feature streamlines data entry by automatically populating fields based on relations and predefined conditions. When enabled, it dynamically filters and fills in related fields (like client type or employee data) based on the selection of an initial field. This reduces the need for manual data entry and ensures consistent, accurate data across related tables. For example, if a specific employee is selected in the Product table, relevant details tied to that employee, such as their client type, can automatically appear without extra input.
MTM Create
Interface that allows users to create relations between the current item and many different items from a single table.
To create a new Relation, follow these steps:
Step.1 Go to the table and click the settings button on the top right corner.
Step.2 Select the 4th section, “Relation”.
Step.3 If you have already created a relation, it will appear in the table. Otherwise, click the “+Add” button.
Step.4 A form with 6 fields will appear, which you need to fill out:
Label from: Label display in current table layout .
Label to: Label display in connected table layout.
Table from: The table which data will be taken (this is automatically selected).
Table to: The table you are relating to.
Relation type: The type of relation (e.g.,M2O, M2M).
View fields: Choose which fields will be displayed.
There are also two checkboxes to consider:
Disable edit table: Prevents edits to the table.
Enable multi-language: Enables support for multiple languages.
This all falls under the Schema section.
Step.5 In addition, there’s an Additional section with four checkbox options:
• Disabled - if user enable “Disabled”, this function disables the relation for the selected field, preventing any further interaction or association with that field.
• Default editable
• Creatable - If user enable ‘Creatale’, when enabled, automatically generates a ‘Create’ button during search operations. If the user searches for an item (e.g., a client) that does not exist in the current table (such as the product table), the “Create” button will appear. Selecting this button redirects the user to the appropriate table (e.g., client table), enabling them to add the new item directly.
• Relation button
Step.6 There’s an Auto-filter section for applying filters automatically.
The Auto-filter feature streamlines data entry by automatically populating fields based on relationships and predefined conditions. When enabled, it dynamically filters and fills in related fields (like client type or employee data) based on the selection of an initial field. This reduces the need for manual data entry and ensures consistent, accurate data across related tables. For example, if a specific employee is selected in the Product table, relevant details tied to that employee, such as their client type, can automatically appear without extra input.
Last updated