- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 12, 2021 02:55 AM
Dear Community,
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 12, 2021 09:43 AM
Hi there,
you can do the following:
- create a field to extract the time of the field you have already let’s say “day_to_post”
the formula will be: TIMESTR(day_to_post) - Then create your automation with by setting 2 conditions to run. The first will be on day_to_post field while the second will look at the field with time function.
Please notify us if it works for you and if you need further support don’t hesitate to text us.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
DATETIME_DIFF(NOW(),{Post_Date},‘minutes’)
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 15, 2021 09:45 AM
Hi Fuad,
please keep in mind the following:
- 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?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.