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”
The ID has been entered and I drag and dropped the relevant field that I want to update.
But hitting the execute node button doesn’t update the card. It has the original value of “Have Reached Out”.
Describe the issue/error/question
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”.
What is the error message (if any)?
There is no error message. The OUTPUT just doesn’t show the updated value from the input and the card on airtable remains unchanged.
Please share the workflow
Share the output returned by the last node
Information on your n8n setup
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
Closed
February 21, 2023, 10:19am
9
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.