So I've read a few answers here regarding what I'm trying to do and what I'm seeing, but I'm still very unsure if
im going about things the right way
the behaviour I'm seeing is expected
there maybe is something thats not working right or
what I am trying to do just isn't possible
I'd like to trigger a webhook to go out to another self hosted work automation platform at the start and end of "bookings" in one of our tables.
Each booking has a date / duration field with time. And bookings tend to be an hour or so long.
I couldn't immediately figure out anyway of triggering an automation via "current time" at all - matching current time to a field (start or end of a duration in my instance) so I went about figuring out a plan b.
I created a formula field that simply detects if we are currently in a booking.
if([Booking Date/Time].[Booking Date/Time Start]<=NOW(),
if([Booking Date/Time].[Booking Date/Time End]>=NOW(), "in progress","finished")
,"coming up")That seems to work - but turns out even this isn't working. I'm falling down at the first step.
The formula column only seems to update if I also update something else manually in that entry. The formula doesn't auto calculate once the initial calculation of the entire column is done. This seems extremely odd to me.
Is this meant to work? I've seen discussion 2 years ago where this was acknowledged as something occuring, and that it was to be fixed immediately, but then there were no further updates to it.
Now, I also create an automation now that just looks to the formula field
but this also only fires if the formula has manually been triggered - OR - if I update the record. But nothing actually happens automatically.
Has anyone experienced something like this lately? Is there a way around it?
(The webhook part of the automation is great - and works perfect. No issues with inserting and reading relevant json. )
Cheers!