I’m having trouble with my Make.com (formerly Integromat) scenario that creates records in Airtable after a customer submits an order form through Jotform. Here’s my setup:
In Airtable, I have an ‘Order Line Item’ table in my ‘Sales’ base
This table links to an ‘Inventory’ table in a separate ‘Inventory’ base
The link is through a column called ‘Inventory ID’
There’s also a link to an ‘Order’ table in the ‘Sales’ base
In my Make.com scenario, I’m using the ‘Create Record’ action for Airtable. When I manually input the Order ID, it works fine and creates a new order line item. However, when I try to add the Inventory ID, it says the record doesn’t exist. I’ve tried both the POST API and the Create Record tool, but no luck.
Is this a problem with the Airtable API? Or am I missing something in my setup? Has anyone else run into this issue when working with linked records across different bases in Airtable?
hey, i’ve run into this before. make sure you’re using the right format for the inventory ID - it should be an array like [{“id”: “recXXXXXXXXXXXX”}]. also, try searching for the inventory item first in your scenario to get the correct ID. that usually fixes the ‘record doesn’t exist’ error. good luck!
I’ve encountered this issue before when working with linked records across different Airtable bases. The problem likely stems from how you’re referencing the Inventory ID in your Make.com scenario.
When linking to records in a different base, you need to use the correct format for the Inventory ID. It should be an array with the record ID, like this: [{“id”: “recXXXXXXXXXXXX”}].
To resolve this, I’d suggest adding a Search Records step in your Make.com scenario before the Create Record action. Use this to find the inventory item in the Inventory base using a unique identifier. Then, use the returned record ID in your Create Record action.
Also, ensure you’re using a personal access token for Airtable API authentication, as API keys are now deprecated. This change might be causing connection issues if you haven’t updated your credentials recently.
I’ve dealt with a similar issue when linking records across different Airtable bases using Make.com. The key is understanding how Airtable handles these cross-base links.
First, make sure you’re using the correct record ID format. When linking to an inventory item, you need to provide an array with the record ID, like this: [{ “id”: “recXXXXXXXXXXXX” }].
Since your inventory is in a separate base, you’ll need to perform a search in the Inventory base first. Use Make.com’s ‘Search Records’ module for Airtable to find the inventory item by its unique identifier. Then, grab the record ID from the search results.
Once you have the correct ID, use it in your ‘Create Record’ action. This should solve the ‘record doesn’t exist’ error you’re encountering.
Also, double-check your Airtable API permissions and ensure you’re using a personal access token instead of the deprecated API key. This could be another reason for the connection issues you’re experiencing.