I am new to airtable, and it is working fine for me so far.
I am trying to automate posting to Facebook Page, I have a field in my records that contains Date and Time components.
When adding a condition, I noticed that I can only test the date component, but not the time. Which means I couldn’t so far set an exact time for my post.
Am I doing something wrong?
the time diff returns negative number when the “date post” is in the future, while it returns positive number when it is in past.
So your automation should run when diff is = 0
The now function runs when you open the table, so if you open it at 7:29 pm and the automation should run at actually at 7:30pm (when the date_diff should be equal to zero) at 7:30pm you had already opened the table, so it will keep in cache memory the value of 7:29pm
To solve this issue I recommend you to do the following:
Create field “post time” which should be duration type. There you will put the time you want all posts be scheduled by using the 24hr system
Create an automation that matches conditions:
Post_date is “number of days from now” = 0 AND
post_time is equal to the time you want to run the post. This time should be the exact time you put in the post_time field
Following this solution means that all your post will run at the same time but this is the most efficient I can recommend you in free plan.
Otherwise you can use the scripting to create this automation but after March 22 the scripting will bb available only in pro plan. Do you use a paid version of Airtable?