Post to Twitter on Specific Date and Time

I would like to automate posts to Twitter so that they send out both when “Ready to Publish” (status field) and at a specific date and time (date field with time).

I note that in the triggers, it allows for date but the most specific it gets is “today” and does not include the specific time.

Will it still post at the correct time if the automation is running or is this not possible in Airtable yet?

1 Like

Instead of using condition option to look directly at the {Publish Time} field (guessing a name for now), I suggest adding a formula field named something like {Publish Trigger}, with a formula something like this:

NOW() > {Publish Time}

That will output a 1 when the current time—represented by NOW()—is later than the publish time, and 0 otherwise. Then you can set your automation conditions to be when {Status} is “Ready to Publish”, and {Publish Trigger} is 1. Or you could condense both conditions into the formula, and then the only automation condition would be when {Publish Trigger} is 1:

AND(Status = "Ready to Publish", NOW() > {Publish Time})

There are two issues with this system that you need to be aware of:

  1. The NOW() function doesn’t update constantly. It updates about every 15 minutes when the base is open, and roughly every hour when it’s not (according to the documentation), so the triggering isn’t going to be terribly precise. It’s also extremely unlikely to be an exact match, which is why I used > to compare the two times, not =
  2. The NOW() function calculates time based on GMT, not your local timezone. A more accurate method of comparison is to figure out your local timezone’s offset from GMT and add that many hours to the NOW() value. For example, if your local time is five hours later than GMT, here’s that approach with 5 hours added to NOW().
AND(
    Status = "Ready to Publish",
    DATEADD(NOW(), 5, "hours") > {Publish Time}
)
2 Likes

This is such a helpful reply. Thank you!

Glad to know that you got the answer you were seeking! If you would, please mark my comment (the one above, not this one) as the solution to your question. You incorrectly marked your own comment as the solution. :slight_smile: This helps others who may be searching with similar questions. Thanks!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.