Linked List

Linking lists is a simple and effective way to create a relation between two different lists.

Chat icon
Transcript

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.

Usage Examples:


Linking a "product" with an "order".
Linking a "contact" with an associated "company".
Linking an "invoice" with a "customer".



Field Preferences:


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.



Example:


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!

First Step:

Create a new app named: My courses.

Second Step:

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:



Third Step:

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.

Search icon

Looking for something else?

Search by entering some keywords such as; 'email automation', 'linked list'...
Email icon

Still need help?

If you could not find the answer to your question, please contact the support team using the chat box.