Notifications
Clear all
Topic starter
I'm trying to update the value in the Status field of an Airtable card from "Have Reached Out" to "Meeting Scheduled". However, when I configure the Airtable update node, it doesn't seem to modify the Status field. Instead, it returns the original, unedited Airtable card, as if it's only reading the value and not performing the update.
See this screenshot for more details.
Notice that the input field shows "Meeting Scheduled".
The ID has been provided, and I've dragged and dropped the relevant field I intend to update.
However, clicking the execute node button does not result in the card being updated. It still displays the original value of "Have Reached Out".
Describe the issue/error/question
The input for this Airtable update node is a JSON object intended for updating the card.
- I provide the ID from the input.
- I deselect "Update all fields".
- I drag and drop the specific field I wish to update.
- I click Execute node.
- The right-hand side displays 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 simply does not reflect the updated value from the input, and the card in Airtable remains unchanged.
Please share the workflow
Share the output returned by the last node
Information on your callin.io setup
- callin.io version:
- Database you’re using (default: SQLite): Pulling from and pushing to Airtable
- Running callin.io with the execution process [own(default), main]:
- Running callin.io via [Docker, npm, callin.io, desktop app]: npm and cloud has this error
Please provide the rewritten markdown content *it should be in the markdown format.
Posted : 10/02/2023 2:43 pm
Hey,
Welcome to the community
Do you have a field in your Airtable named Meeting Scheduled? I suspect if you clear the expression from the Field there and simply type in ‘Status’ it might resolve the issue, although you might prefer to only pass the ID and status field.
Posted : 10/02/2023 2:56 pm
Topic starter
Hi there, thanks for the quick reply!
No, I don't have a field named Meeting Scheduled. That's actually the value of the Status field.
I've followed your advice and entered Status directly into the Fields section, but the status is still not updating.
See the screenshot below.
When you say to only pass the ID and Status field, do you mean I should only pass an array containing those two key:value pairs?
Posted : 10/02/2023 3:03 pm
Yes, that should resolve it. In the Set node, check the option at the top, then add 'id' and 'Status' as two options, and you should be all set.
Posted : 10/02/2023 3:06 pm
Topic starter
Yes, that resolved the issue! It functions correctly when using the Set node.
PS: Do you have any insights as to why a Set node is necessary before the Airtable Update node?
If I directly adjust the incoming code from the code block to only include id and Status, it doesn't work. Please see below.
I might have overlooked this in the initial documentation. However, not realizing that a Set node was required certainly led to a significant amount of wasted time.
Posted : 10/02/2023 3:12 pm
Hey,
It should function with the code node too. Based on your output, the issue is likely that 'status' is in lowercase. If it were capitalized as Status, it would probably work.
Please provide the rewritten markdown content.
Posted : 10/02/2023 4:36 pm
Topic starter
I believe you are right! Ah, that's quite frustrating to have made just a simple syntax error. It appears to be failing silently, and it would have been great to receive an error message warning me that the Status field does not exist.
Thanks again for your assistance!
Posted : 13/02/2023 6:26 pm
That sounds like a request for Airtable to return that in their API messages
Posted : 14/02/2023 10:18 am
This thread was automatically closed 7 days following the last response. New replies are no longer permitted.
Posted : 21/02/2023 10:19 am