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
