Connect tables

Connect all your data with a relational database

What is the connect tables field?

It's a field that connects a record on a table to a record on another table. For example, you could have a field that connects a Client to a Plan, or a Purchase to a Vendor.

One thing of note is that when you create a Connects tables field, a summary of connected records is automatically created on the table you're connecting to. On the example below, you can check purchases attributed to Alpha Inc on the upper right panel.

How to create a connect tables field

To create a Connect tables field:

  • On table mode, click on the last table header with a "+" and that will open the create field page
  • Just look for the "Connect tables" 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

When should I use it?

When you wish to establish a relationship between two records 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.

📘

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/