V2 Come collegare due tabelle in NocoDB con Make.com scenarios

Video tutorial of V1

 

1st Module:

Repeater: To run through all the pages of the dataset. Inside each dataset is a data list capped at 25 records. This repeater advances by page. For example, if a dataset contains 100 records, it has 4 pages of 25 records each. Therefore, repeat the automation 4 times.

 

2nd Module:

Establishing connection with the NocoDB dataset, and calling the page the automation is currently on. Copy and paste the Table ID of the table on NocoDB where you want to begin the relation.

3rd Module:

The iterator module simply retrieves the datalist page and continues the automation by running each record across the page.

Establishing connection with the NocoDB dataset, and calling the page the automation is currently on. Copy and paste the Table ID of the table on NocoDB where you want to begin the relation

Filter between 3rd and 4th Modules:

The final step before running through the record is to test two conditions:

1: Does the field in which to relate the two tables even exist in the original?

2: Is the Relation Field empty? 

 

4th Module:

Search for the related record. This module access the other table with which you want to relate your original table with, and matches the record. Fill in the correct fields for which table you want to search, then in the "Where" field, copy the table ID for what you want to find a match with, and use "like" and then the column of the same type in your original table.

Add an ignore module to prevent error if the company is not found

5th Module:

This module uses and HTTP request to link the company related records via the Nocodedb API Documentation

Make sure to replace “tableid”, “link fieldid”, “recordid”

Map the ‘ID’ from 4th module