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.

Check this out.

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”

)

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

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

Nafis

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.

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.

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).

thanks mate! Its working! :grinning_face_with_big_eyes: