Sep 12, 2021 02:55 AM
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?
Sep 12, 2021 09:43 AM
you can do the following:
Please notify us if it works for you and if you need further support don’t hesitate to text us.
Sep 14, 2021 02:30 AM
Thank you for your reply. I tried the following solution:
In my table I have the following 2 fields:
Post_Date: I set here the date and time when I want my record to be posted on FB page.
Post_Time_Diff: is a formula field implementing the following formula
The condition I am trying to use in the automation is like this:
When Post_Time_Diff >= 0
So, if the Post_Date is after or equal to now(), the post should be created.
I have 2 records in my table, and the post_time_diff field for them shows 170 and 50 minutes respectively. Yet, nothing was posted so far in my FB Page.
Am I doing something wrong? Where is the hiccup?
Sep 15, 2021 09:45 AM
please keep in mind the following:
To solve this issue I recommend you to do the following:
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?
Sep 19, 2021 08:16 PM
How would you approach this with a script?
I’m surprised that automations don’t account for the timestamp. Facing a similar issue myself.