Dear all,
I have created 2 tables, and they are connected via ArtID.
I want to Create a Row in my table lieferanten_recherche and I can see all columns but NOT the ArtID!
Furthermore, there is the error message: The module is not set up.
Which column type is your column ArtID?
It is an Array and can not change to number like in the other table.
What I did to create the connection.
The add row operaton does not support adding links.
You must first create the row and then link the new row.
I have created the column ArtID new without the connection and did one run to create the rows.
But now I can not connect the ArtID from table lieferanten_recherche with table material_stamm.
Of course not. Don’t delete the link column if you want to link records in ‘lieferanten_recherche’ and ‘material_stamm’.
What I was saying is that you must use a two step approach:
1.) Create the row in ‘lieferanten_recherche’
2.) Add the link between ‘lieferanten_recherche’ and ‘material_stamm’
Logically, you need a link column between these two tables.
Step 2, you can implement via API (Make.com) or via an automation rule. Up to you.
I did 1 and 2, but in make.com I still do not see the linked column ArtID.
Or do you mean that in the linked column I should have an automation rule, havin 2 columns with the ArtID in the table. One with the link and the other for make.com?
Again, you cannot create a new row and add a link in one operation. This are two separate operations.
I mean this:
Or this:
The latter requires an Enterprise subscription.
Thanks, and I see now what you mean with 2 operations!
My issue is that in the first operation i need the ID directly in each new row. I can not add the ID in a second step.
In a first step I will add X new suppliers for Y items. Each item has his ArtID.
Well, you must. Sorry.
Please write the ArtID in an text field in the first operation. Then use the ArtID from the text column in the second step to create the link.
1 Like
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.
