In the documentation for the NOW() function it states that:
If the base is closed, it will update approximately every hour only when the base has time-dependent automation triggers or actions, or sync dependencies.
I have a Zapier process that polls a view, does this count as a sync dependency?
The formula i’m using calculates whether the value in a date field is greater than the current datetime, and if it is it will appear in the View that Zapier is watching. It’s important that the formula is calculated 24/7 and not just when the base is open.