Come collegare due tabelle in NocoDB con Make.com scenarios

https://drive.google.com/file/d/18baYOZU0_kFQqRJsmu71om1eLxi3u2Tl/view?usp=drive_link

Loom video recording:

https://www.loom.com/share/c6308df8a9e341c3b6354d2cd9702b9d?sid=9f146c98-0f96-433b-8 9a1-dbdef4e74566

Here is the Final Setup

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
  

Limit:

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

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

2nd Module:

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

 

Fields0 Select 

D Id

D Company_Name

D VAT 

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

3rd 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”

HTTP ! :X ? x

>

>

>

1e company record to People

Make a request

>

+ Add a header This is your Nocodedb API Key

• Query String

-- + Add parameter

C> Run once • Advanced settings

Map

Map the ‘ID’ from 2nd module