Airtable API

[Ema_Pop]

Description
I am trying to send data from Glide (what a user might input though a choice) into an airtable database. Glide might be sending the wrong format for the Airtable API. In my context when a user selects a choice it should update though airtable but the change does not happen. This is the workflow:

In the action log I get this:
{
“updates”:{
“remotefldm5t3agk3udlcWK”:{
“0”:“recIlk5kmqUz8xT55”
}
}
“tableName”:“Action Points”
}
But Airtable does not seem to get the correct data even though the record id is correct (recIlk5kmqUz8xT55) and the field name is correct too (fldm5t3agk3udlcWK). Not sure what the remote part of the field is and the object format instead of the array.

This is the conficuration of the choice drop down in the table on Glide.

In the Data tab the Action Point Owner is correctly recognised by the record ID but the data is just not being sent correctly though to airtable.

How to replicate
https://go.glideapps.com/support/ac4f2842-9ad5-48bf-bb46-7ac62ef04aeb

[ThinhDinh]

Trying to understand the flow here. So the action already edits the “Action Point Owner” field in Airtable but you want to do a set column again on top of that? Why do you need to have two “Action Point Owner” fields?

[Ema_Pop]

The relation link was made because I thought I had to have it for the record id to match with the current Action Point Owner. What would be the best way to go about it?

[ThinhDinh]

Wouldn’t the first column here do the work already? It’s already a “relation”.