Skip to main content
Solved

Integromat-Airtable integration: Create record with synced linked record -- record id not found


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?

Best answer by Wichie_Artu

Someone in the integromat facebook community …

FB Person: As I understand how airtable record ID works, synced inventory ID (from another base) is different from that base’s recordID. try to create a recordID formula field and use that instead as reference?

Wichie Artu: You’re a godsend! The Inventory ID in the Sales base is DIFFERENT from the Inventory ID in the Inventory base. I did a formula in the Sales base to get that record id, and used that.

View original
Did this topic help you find an answer to your question?

2 replies

  • Author
  • New Participant
  • 1 reply
  • Answer
  • October 24, 2021

Someone in the integromat facebook community …

FB Person: As I understand how airtable record ID works, synced inventory ID (from another base) is different from that base’s recordID. try to create a recordID formula field and use that instead as reference?

Wichie Artu: You’re a godsend! The Inventory ID in the Sales base is DIFFERENT from the Inventory ID in the Inventory base. I did a formula in the Sales base to get that record id, and used that.


ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8768 replies
  • October 24, 2021
Wichie_Artu wrote:

Someone in the integromat facebook community …

FB Person: As I understand how airtable record ID works, synced inventory ID (from another base) is different from that base’s recordID. try to create a recordID formula field and use that instead as reference?

Wichie Artu: You’re a godsend! The Inventory ID in the Sales base is DIFFERENT from the Inventory ID in the Inventory base. I did a formula in the Sales base to get that record id, and used that.


Nice! Very subtle but very important distinction!


Reply