Non-time based automation not triggering : Any workaround?

Hi everybody :slight_smile: !

I’m trying to get notified (within Coda) when a row is modified is one of my table.
The rule works when tested but doesn’t trigger outside the test.

Specifically, I’ve got a field Status that changes from Running to Ready when a countdown hit 0.
The countdown is triggered by a button in that table. And I simply would like to be notified when ThisRow.Status="Ready".

I’ve got several rows in that table but the fields concerning the countdown remain Blank() unless the countdown in that row is triggered too.

I’ve tried to play around with checkboxes, with Modified(thisrow), I’ve tried to Count() the number of rows where Status="Ready". Each time the automation works when tested, but doesn’t trigger when needed.

I’ve got no idea left to try and solve this :sweat: .

Searching here, I’ve found this topic :

But I wasn’t able to apply this to my doc because I’m not sure to follow the suggested solution :confused:.

I’ll be profoundly grateful for anyone having a solution, workaround :bulb: :grin:
(I know nothing about Zapier or Integromat, but I’m ready to go there if needed :wink: )

Thank you very much in advance :grin: !

Generally speaking, I don’t think automations can detect changes from formulas. Al’s workaround actually depends on manual (or API) input to trigger the Row changed flag.

That’s the same principle for Modified on. It only updates when the formula code (including its references’ values) is modified, but ignores changes to the displayed/calculated value.

So you need to actively poll the table to detect any changes (that’s what happens when you Test the automation rule).

That can be done with a time-based automation. Then if you need more resolution than 1 hour, you’d fall under the same case as this one:

Integromat offers 15-min resolution. So what you can do is:

  1. Set up a checkbox column on your table and create an automation to watch row changed and test if that checkbox is true.

  2. Setup your Integromat connection, then create a scenario like this:

    The first block is pretty straightforward. On the second one you need to map the row coming from the first block. Then you can do some logic to test Status and update the checkbox.

After Integromat updates the row, the Coda internal automation will kick in.

1 Like

Thank you very much for your help @Dalmo_Mendonca :grin: !

It took me a while to get this in place :sweat_smile: but it seems to be working :grin: !

1 Like