Automation help: "sleep" a few minutes before sending a Slack notification

Hi there,

Unfortunately, there are no delays after the automation has triggered, but here you have a way to delay an automation from running.

Best
Sergio
https://devblocks.agency
If this reply fixed your problem, please mark it as a solution :white_check_mark:

Create a new formula field in your check-in table, let’s call it ExampleFieldName:

VALUE( 
    FROMNOW( 
        IF( 
            LAST_MODIFIED_TIME(), LAST_MODIFIED_TIME() , 
            CREATED_TIME()), NOW()
    ) 
)

This will return the rough number of minutes since any given record was last modified or created (if it was never modified after being created).

You should be able to easily modify this formula or create another one that references its value, then returns true||false||1||0||“automation go”||null or whatever trigger you want your automation to wait for before the processing starts.

I suggest setting the threshold at around 16-20 by doing something like:

IF(ExampleFieldName > 15, "Automate", "Wait")

Either in a new formula or by setting up a conditional View that only shows recoirds whose ExampleFieldName value is over 15, then having your Automation scan “only” records in that view.

That’s because the NOW() call only gets updated four or five times per hour. There are ways to be way more precise with this targeting by writing a custom automation script, but that doesn’t sound like it’s necessary in your case.

Also @ismail_crc, I’m assuming your automation is already keeping track of the processed records in one way or another as the above example doesn’t account for that.

EDIT: Forgot to add that you might want to set your Formula field formatting options to double-precision decimals instead of ‘Duration’ as the latter would just require additional formatting for no benefit due to the asynchronous nature of the NOW formula.

VALUE( 
    FROMNOW( 
        IF( 
            LAST_MODIFIED_TIME(), LAST_MODIFIED_TIME() , 
            CREATED_TIME()), NOW()
    ) 
)

Hey Dominik! I was trying to follow your method, but the formula is just returning ‘0’ - any idea why?

As I said, your field settings can affect the output, based on the exact formula.

If you can’t get the above to output, remove the value wrapper:

FROMNOW(IF( LAST_MODIFIED_TIME(), LAST_MODIFIED_TIME() , CREATED_TIME()))

And paste it to a new formula field. You should then be seeing this:

From here, just return the wrapper and adjust the settings as neccessary to get raw, steadily changing numbers.

Otherwise, I’m out of ideas, Maybe contact Airtable support but reading through the docs would probably be more worthwhile. Here’s an example of a super useful reference regarding formatting

Amazing - thank you very much!