Skip to main content

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

Video tutorial of V1

embedded-image-jpt8ovzj.png

Screenshot 2026-03-03 at 9.38.21 AM.png


 

1st Module:

SearchRepeater: Record:To itrun basically getthrough all the rowspages 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.

Screenshot 2026-03-03 at 9.41.25 AM.png

 

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.

Screenshot 2026-03-03 at 9.44.35 AM.png

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

Screenshot 2026-03-03 at 9.46.59 AM.png

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 Peopleoriginal?

Table.

2: YouIs needthe Relation Field empty? 

Screenshot 2026-03-03 at 9.47.52 AM.png

 

4th Module:

Search for the related record. This module access the other table with which you want to selectrelate correct: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.

    Screenshot 2026-03-03 at 9.50.52 AM.png

    Latest API version:

    Workspace

    Base

    Table

    embedded-image-kcjmmiwj.jpeg



    Limit:

    The limit is where you select the maximum number of record/people you want to get from the table

    embedded-image-gntcolg0.jpeg





    Filter:

    The filter step is to check if the “company” is not missing in the people table and the “company related” hasn't been updated to avoid wasting operations

    embedded-image-f8d5o4no.png






    2nd Module:

    Search Record: The second Module is where search for the related company to get the

    company's ID

    embedded-image-cxvihe23.jpeg

    embedded-image-bob80w5n.jpeg


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

    embedded-image-xemnfxbe.png

    Screenshot 2026-03-03 at 9.55.25 AM.png


    3rd5th Module:


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

     

    Nocodedb API Documentation

    embedded-image-hmq9b5wc.png

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

    embedded-image-vnxbihmq.jpeg

    Map the ‘ID’ from 2nd4th module


    embedded-image-nixzxtsw.png

    Back to top