Got a field Following and a Last Updated (FollowingSince) on that specific field. Any try to trigger that way ended in a ERROR: The Field "FollowedSince" does not exist.
But I could not find a way with the Last update date on a specific field. Just had to do it “global” last update and check value with a If node. Not perfect but it works.
Dunno. Maube I did something wrong. Or maybe this is an issue with the tracked field : in my table, FollowedStatus is a Single select associated to an automation (button clicked).
The datetime field is successfully retrieved when calling from an Airtable regular node, but when trying to use the same field as the trigger field in an Airtable trigger node, it gives an error “The field does not exist”.
Note: the Airtable Trigger node works just fine if the same field is converted, in Airtable, to a global trigger instead of a field-specific trigger. Although, i’m not sure why there’s such a difference, as both the (datetime) field types (in Airtable) are exactly the same.
Hm, I still can’t reproduce this I am afraid. I wonder if the Airtable API behaves different for my account for some reason (perhaps because it has some legacy status or something). When saying datetime field, are you referring to the trigger field itself or have you also configured your trigger field to observer changes to a datetime field?
@Jon anything obvious you can think of in the respective trigger node code that could cause these problems here?
Hey @MutedJam . When i say the datetime field, i mean the field itself.
I’ve tried configuring that field to observe changes in various types of other fields for its trigger, all with the same result.
I had two automations working using two separate workflows and triggered by two separate bases.
These were both used to send messages via twillio to a group of contacts when a record is created in airtable (triggered by a date field and polling every minute).
Both of these were working okay including, most recently, this morning.
I then made a change to one of the automations. I added a new text field to pass some placeholder information for the twilio message. I did not change anything to do with the created time field.
When I came to execute the workflow I receieved the error: “Airtable Trigger: The Field “created” does not exist.”
I have not been able to fix this by recreating the date field or by copying to a new base.
Interestingly, the second automation (which is totally separate base and workflow) now also gives the same error (despite not having changed anything to the base or workflow).
This is a duplicate (and cleaned) version of the base where the issue happened. The “whatsapp n8n triggering” is the one that holds the info fed through to n8n.
Thanks for that, I have copied it and used the whatsapp n8n triggering table and created as the field but for some reason I can’t reproduce the issue from the initial setup I then added a field to the table but this doesn’t appear to have stopped it from working
What happens fi you delete the trigger node then add it again does that help? What version of n8n are you running as well?
Essentially it is because some of the records in my DB did not have a “created” field anymore. So it is actually a super simple explanation, apologies.
To talk you through why I did this:
I am using airtable to trigger messages to a lot of people at once via whatsapp
I want these messages to send quickly when I am ready, so I have n8n set to 1min polling time
But, I need to add quite a bit of info to each record before it sends. (eg which agents, what is the message)
This means that there was a risk that the polling trigger of 1 minute would fire before I have filled in all the info
To solve this in airtable I just built a simple automation to set a date field to “created time” when I update the status
As part of testing this I wanted n8n to pull in the more recent records so I cleared the old “created time”. This is when the error occurred.
To narrow this down further I’ve now found that it is ONE specific airtable record that causes this error. I can delete “created” from all records apart from this one and n8n fetches the test event correctly,
As soon as I remove “created” from that record it breaks.
Happy to show you this on screenshare etc if helpful.
That is interesting so it is more that if a record doesn’t have a field the test fails? That is a bit annoying but if you can maybe record it failing I have a chat with one of the other engineers and we can have a think about how we can handle that sort of case.