I want to change the value in the Status field of an airtable card from "Have Reached Out" to "Meeting Scheduled". But when I fill in the airtable update node it doesn’t update the Status field. It just returns the original, unedited, airtable card as if it’s reading the value and not writing/updating it.
See this screenshot for more info.
Notice how the input says “Meeting Scheduled”
But hitting the execute node button doesn’t update the card. It has the original value of “Have Reached Out”.
The input to this airtable update node is a json that I want to update the card with.
I provide the ID from the input.
I deselect “Update all fields”.
I drag and drop the specific field I want to update.
Click Execute node.
RHS has the older value of “Have Reached Out” instead of “Meeting scheduled”.
There is no error message. The OUTPUT just doesn’t show the updated value from the input and the card on airtable remains unchanged.
n8n version:
Database you’re using (default: SQLite): Pulling from and pushing to Airtable
Running n8n with the execution process [own(default), main]:
Running n8n via [Docker, npm, n8n.cloud, desktop app]: npm and cloud has this error
Jon
February 10, 2023, 2:56pm
2
Hey @hdotking ,
Welcome to the community
Do you have a field in your Airtable called Meeting Scheduled? I suspect if you clear the expression from the Field there and just type in ‘Status’ it might do the job although you might want to only pass in the ID and status field.
1 Like
Hi Jon thanks for the speedy response!
No I do not have field called Meeting Scheduled. That is the value of the Status field.
I have take your advice and changed and simple entered Status into the Fields section but theh Status is still not updating.
See the screenshot below.
By only pass in the ID and Status field - do you mean I should only pass in an array with those two key:value pairs?
Jon
February 10, 2023, 3:06pm
4
Yeah that would do it so in the Set node check the option at the top then add id and Status as 2 options and you should be good to go.
2 Likes
Yes that did the trick! It works with the Set node
PS: Any idea why we need a Set node before the Airtable Update node?
If I simply modify incoming code from the code block to look like it only has id and Status it does not work. See here.
I may have missed this in the introductory material. But not knowing that a Set node was required sure did waste a lot of time.
1 Like
Jon
February 10, 2023, 4:36pm
6
Hey @hdotking ,
It should work with the code node as well, Looking at your output it is probably where status is lowercase. If it was Status it would probably work.
2 Likes
I think you’re correct! Ah that’s so frustrating to have made just a simple syntax error. It looks like it’s failing silently and it would have been so cool to get an error message - warning me that the Status field does not exist.
Thanks again for your support!
Jon
February 14, 2023, 10:18am
8
That sounds like a request for Airtable to return that in their API messages
1 Like
system
February 21, 2023, 10:19am
9
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
