I intend to use Airtable and Zapier to automatically schedule social media tasks.
Every day Zapier schedule checks a Primary key [Date] column in Airtable. If today’s date equals the date in the Airtable column then do some stuff…
However, I keep receiving a “Record not found” message.
I construct a date in the Zapier search field that matches the date format in Airtable.
For example Zapier search value = 2019-08-05
In Airtable a primary key date column with the value 2019-08-05
I have confirmed the date format is yyyy-mm-dd in Zapier by hardcoding search string: 2019-08-05 against a text column in airtable and the format is yyyy-mm-dd. Then reviewing the successful output of the record in Zapier.
I’m not sure if there is a specific date format beneath the covers I need to know about.
One solution I have considered is to create a single line text column with the date converted to text and use this column as the lookup.
Any ideas would be appreciated.