Linked Tables are a versatile tool that enables users to create interconnected tables, design recipe structures, and seamlessly transmit data to PLCs. They provide a robust framework for organizing, monitoring, and managing production data. With Linked Tables, users can efficiently define data structures and customize how the data is displayed through dynamic views.
Key Concepts:
1. Definition A Definition establishes the rules and specifications for the data structure in a Linked Table. It determines the fields, data types, constraints, and descriptions that define how data is organized and interpreted.
What It Includes:
Field names and data types.
Constraints (e.g., uniqueness or required values).
Descriptions for codes or values.
Example: For a table containing country codes, the Definition might include:
CountryCode: A unique, three-letter identifier.
CountryName: A text field for the country’s name.
Constraints ensuring that CountryCode values are unique.
2. View A View offers an alternative way to display data from one or more Linked Tables. Rather than storing data, it generates a query to present the desired information. Views can include specific columns, filters, or combinations of tables to create tailored representations.
Default View:
Automatically generated for each Linked Table Definition.
Includes all fields from the definition and cannot be modified.
Custom Views:
Users can create their own views by selecting specific fields, applying filters, or joining tables to customize data presentation.
Example: A View might show only employees from the IT department, while the underlying table contains details for all employees.
Benefits of Linked Tables:
Organized Framework: Helps define clear data structures for efficient management.
Customizable Views: Allows users to tailor data representation for specific needs or departments.
Seamless Data Transmission: Easily transmits recipe data to PLCs for production tasks.
Efficient Monitoring: Provides insights into production or organizational data through dynamic filtering and structuring.
By combining Definitions and Views, Linked Tables provide a powerful, flexible solution for managing complex data structures and ensuring clarity and precision in production and organizational processes.
How can Linked tables be used?
Recipes: Streamlining control
Recipes serve as a versatile tool, enabling users to configure multiple parameters simultaneously within controller technology. For instance: Home Automation: Picture an intelligent household with Linked thermostatic heads controlled through MQTT. With a single click, users can set all thermostats to a specific temperature in predefined scenarios. Industry: Consider a production line capable of manufacturing various items, each requiring specific machine settings. In recipes, predefined scenarios for each item simplify the process. When switching production, users can effortlessly choose and input a different recipe into the control unit.
Utilizing Linked Tables as an item/production monitoring system is exemplified by the following: Creating an intricate and well-organized Linked table detailing the origin of items is within your capabilities.
In cases of both unexpected and expected machine maintenance, logging this information into the Linked table becomes a straightforward process. Record the start and end times of the maintenance, and the system will generate the overall duration of the maintenance. Additionally, if another issue arises immediately after the initial one or if the repair/maintenance extends beyond workers’ expectations, seamlessly merge these two downtimes into a single entry for comprehensive tracking.
Optimizing Workforce Efficiency with Smart Shift Management Systems
Getting Started with Linked Tables
Create a Linked Table and define its content.
After completing the creation of definitions and saving your progress, the system automatically generates a “default” view containing all the definitions, which is non-editable. Should you desire specific data for a tailored experience, take the initiative to create your own Linked table view.
gif
After creating your personalized Linked table view, open it and drag the desired definition items from the right toolbar into the main table. Save your changes to solidify your customized view. Once you create your Linked table view, feel free to open that view up and drag the definition items you want to be used from the right toolbar into the main table and save.
gif
Once you have completed the customization process, proceed to specify the data in the code table view.
gif
Did you know that you can enhance connectivity by using the “Linked Tables” type within the Linked Table definition to link Linked Tables definitions together?
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
