Automation intervals

[Yaniv_Bahat]

I created an automation to trigger an email when a record has been modified/updated.
Can I set that the “Action” will not happen immediately. let’s say after 10 min from the change?

Thanks

[GertJan_Kuiper]

Related request here. I send an email when a new record is created, but that means that often multiple emails are send, varying from an empty record (the first) up to the completed record (the last). A slight delay, or the possible to delay a trigger would be helpful.
For some triggers that are not urgent I created a work around by using a view in which the created or modified records from yesterday are shown, and use this grid for the email notification.

[Tuur]

Check this out.

Pause or Delay in Automations Automations

Uploading of attachments can be a bit tricky. As @Mike_Mauer mentioned, there is a delay between when an attachment field is no longer considered blank and when the image is actually uploaded. And in some cases, if Airtable cannot retrieve the attachment from the url, the image might not ever become fully attached. setTimeout does work in a scripting app (even though the editor complains about it), but it needs to be called correctly. However, I wouldn’t use setTimeout in a Scripting action f…

[Nafisul_Islam]

Hi, thanks for recommending that solution, i read her comment. But where do i paste that formula?
Sorry, i am kinda new to this.

this is the formula she suggested.

IF(
AND(
{Attachment},
DATETIME_DIFF(
NOW(),
LAST_MODIFIED_TIME(Attachment),
‘minutes’
) > 1
),
“run automation”
)

[Tuur]

You create a new formula field for it. Then you let the automation check for the value in this field.

[Nafisul_Islam]

thanks for your reply.
Could you help me more?

Here is my table i am using. I have marked the two column that are related to the automation trigger.

I want the automation bot send an email to an user 5 minutes after i have written something in the feedback to the writer" column. The last feedback time updates when i add something in the feedback to the writer column.

I need to create a new formula field and insert the formula there, right?
but i am struggling to edit the formula correctly based on my case.

Also, in the automation trigger Details , how should the setting look like?

I appreciate your time in this :slightly_smiling_face:
Nafis

[Tuur]

Nafisul_Islam:

I need to create a new formula field and insert the formula there, right?
but i am struggling to edit the formula correctly based on my case.

Just change the ‘1’ to ‘5’ (it’s the time difference in ‘minutes’).

I would use the first trigger and look for the flag (“run automation”) in the formula field you created in the former step.

[Nafisul_Islam]

okay, since i don’t want the feedback attachment to play a role in the automation, do not I need to adjust the formula accordingly? I am stuck there. :frowning:

[Tuur]

Nafisul_Islam:

Attachment

Ah! So sorry, yeah, just change the two references from ‘Attachment’ into ‘{Feedback to Writer}’.

The first one checks if there’s a value in the field at all, the second one gives you basically the same value as your {Last Feedback time} field (which you don’t need for the setup to work - although it might be interesting for yourself).

[Nafisul_Islam]

thanks mate! Its working! :grinning_face_with_big_eyes: