Linked Tables empower users to create interconnected tables and design recipes seamlessly transmittable to PLCs. Users can configure their organisational framework, monitor production, and complete various tasks using this technology. Constructing a Linked Table is straightforward; begin by creating a definition and then proceed to specify multiple views.
Definition
A definition is a set of rules or specifications that define the structure, meaning, and characteristics of data elements within a Linked Table. It includes information about the attributes stored in the table. It typically includes field names, data types, constraints, and meanings or descriptions associated with the codes or values in the table.
Example: For a country code table, the definition might include the fields CountryCode (unique, three-letter codes), CountryName (text), and constraints like uniqueness for the country codes.
View
A view provides an alternative way to present data from one or more Linked Tables. A view does not store data itself; it stores a query used to generate the result. It can include specific columns, apply filters, or join multiple tables to create a customized representation of the data.
Every Linked Table definition automatically creates a default view containing all definitions that cannot be edited. You can create your Linked Table view containing the definitions you choose.
Example:A view might be created to show only employees from the IT department more concisely, even if the underlying table contains more information about all employees.
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?
gif
Manage Consent
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.
