Linking lists is a simple and effective way to create a relation between two different lists.
Linking lists is a simple and effective way to create a relation between two different lists. This field type allows you to connect a record to another record in another list. This can be very helpful in finding related information and eliminating data duplication.
Linking a "product" with an "order".
Linking a "contact" with an associated "company".
Linking an "invoice" with a "customer".
Required Field (optional): you can make this field mandatory for new records.
Choose List(required): select one of the lists on the same app or scroll down to select a list from a different app in your workspace.
Allow Multiple (optional): allow linking multiple records to the original at the same time.
Cascaded (optional): limit the linked record selection with another linked list field. For example if the country is selected, show only the cities that are linked with the country.
Assume you want to create a new app for an educational institute. There are at least two lists to create: "courses" and "teachers". Each course have a teacher, and each teacher may teach many courses.
Let us create those lists, and make this relations in Workiom!
Create a new app named: My courses.
Create a new list named: Courses with the field:
Name: Field Type text
Description: Field Type text with "Multiline"'s option checked.
Duration: Field Type static list with this values: 2 weeks, 1 month, 2 months
Go back to list and insert some data such as the following:
Create a new list named: Teachers with those field:
Full name: Field type text.
Phone number: Field type phone number.
Email: Field type email.
Notes: Field type text with "Multiline"'s option checked.
Back to list and insert some data:
Now that we have created two lists: "courses" and "teachers", let's now create the relation between them!
Create a relation:
Go to the "Courses" list and click on the "Field" button.
Click on "New Field" button.
Enter the field name as "Teachers", and choose the Field Type as "Linked list".
Choose the list "Teachers" from the Linked list drop down.
Check the "Allow Multiple" option, if checked this means that a specific course could be taught by one or more teachers.
Congratulations, you have created a new field in the Courses list linked with the Teachers list.
You can go back to the list "Teachers" and see that a new field automatically created there for the link to "Courses" list.
In the Courses list, you can assign a course for one or more existing teachers. If you try to add a new teacher that does not exists, you can click on 'Create [ New Teacher ]' button and create a new record in Teachers list.