This question also exists in Integromat-Airtable integration: Create record with synced linked record -- record id not found - Stack Overflow
I’ve created a scenario where a customer submits an order form jotform. In airtable, I have an “Order Line Item” table in my “Sales” base that links to a record from the “Inventory” table from the “Inventory” base. This linked record column is called “Inventory ID”. It also has a linked record to my “Order” table in the “Sales” base.
–order line item table–
In integromat, I have a “Create Record” airbase tool. When I manually put in the Order ID, that creates the new order line item record no problem. But when I manually put in the Inventory ID record, it says it doesn’t exist. And, I’ve tried both the POST API and the Create Record tool.
–synced inventory table–
–integromat scenario excerpt–
Is this a bug in the airtable API?