Skip to main content

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

Video tutorial

embedded-image-jpt8ovzj.png

1st Module:

Search Record: it basically get all the rows in the People Table. You need to select correct:

  • 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 added an ignore module to prevent error if the company is not found

embedded-image-xemnfxbe.png


3rd 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 2nd module


embedded-image-nixzxtsw.png