Connected Table (N:M)
Add many to many relationships creating an intermediary table
What is the Connected Table (N:M) field?
It's a field that you can add many to many relationships creating an intermediary table
Many to many connections should be used only when many elements could be linked to many others elements. It's not a usual scenario for business processes, and it's commonly mistaken with N:1 relationships.
In order to build this connection, a 3rd table is automatically created, managing the multiple relationship between both tables.
How to create a Connected Table (N:M) field
To create a Connected Table (N:M) field:
- On table mode, click on the last table header with a "+", press (F) or click on the "+" on the upper right and this will open the field creation page
- Just look for the "Connected Table (N:M)" option and click on it
- Choose the name of your field, the table you're connecting to, and if it's a required field
You can delete or edit by clicking on the table header name and choosing one of the options
Filter the connected records
Scrolling down the connected record creation page, you'll find the option to filter the connected records
This way you can filter the connect table field to only show specific filtered informations
Common use cases
Connected records” field is very important and useful for creating a scalable database structure. It can be used to create a correlation between data in a way you can easily access information on the connected record, as well as having the summary of connections. This is useful for purchases, sales, documentation, projects and many other different cases.:
- In a “Sales” flow, it can be created as a field to link the sales orders to the “Clients” table.
- You can create a “Companies” table for storing leads and a “Contacts” table to register the contacts of these companies. Then you create a “Connect records” field in the “Contacts” table to associate each contact to a company.
Understanding processes and block based building.
If you want to understand more about how to effectively use Connect tables field, we highly encourage reading on the Three Laws of Process Building: https://jestor.com/blog/jestor-process/pareidolia-to-process/
Updated 2 months ago