Airtable linked record

Feature Requests
1

I have checked the docs and I am wondering if I set linked column in airtable to lookup from another table what value I should set when I create new record? Record Id from lookup table?

2

Hi @Droren

Usually you will need to set the Id of a linked record. As this is the value that is actually used to setup the link.
Not sure on Airtable specifically, but it would surprise me if they made it differently.

1 Like
3

I’m facing this issue too. Usually, you’d just pass in record ID as an object, ie, [recordId], but with the Airtable nodes available in n8n (create and upsert), linked record fields are simply greyed out and non-edible. I can’t pass in a value or add an expression. Any workarounds other than a custom HTTPS post after the create/update step to populate the relationship?

1 Like
5

I am afraid not @alexiom, though this has come up a few times now and I hope we’ll change this soon.

For the time being I shall convert this into a feature request allowing you and other users to vote on having this implemented on the Airtable node.

For a workaround using the HTTP Request node head this way: Airtable multiple select field updated - ERROR: Invalid input for 'XXXXX' [item 0] - #13 by MutedJam

1 Like
6

PATCH call worked. Thanks!

Also, for a low(er) code fix, I found you can push the parent record ID’s into simple text fields, and then use an airtable automation running on record-create to resolve the lookup.

1 Like
7

I use another way:
copy node to vs,

there are “schema” item

this item look like:
{
“id”: “id”,
“displayName”: “id”,
“required”: false,
“defaultMatch”: true,
“display”: true,
“type”: “string”,
“readOnly”: true
}

so “readOnly”: true, I change to “readOnly”: false,

next ctrl+a, ctrl+c, and in n8n paste node,

remeber to change options to
“options”: {
“typecast”: true
}

10 Likes
8

This right here is the real MVP answer!

3 Likes
9

My friend!
What a life safer you have been!

3 Likes
10

Thank you! That was exactly what I needed too!

2 Likes
11

Wow - didn’t know you can work with nodes like this … thank you for this insight!

12

At first, I didn’t understand, but when I did… :fire: :fire: :fire: :fire:

13

Is it possible someone can show a video?