Bot Triggerd then ignoring Triggers for 5 days

[provisrudd]

Hello,

Is there a solution to stop a bot from being triggered for 5 days after its been triggered once?

[TeeSee1]

I do not think there is a ready way to do this.

You could create a column somewhere that records when the bot is executed and then based on the date, you can set a condition in your bot's event trigger.

[Suvrutt_Gurjar]

May we know how you are currently triggering the BOT?

[provisrudd]

Hello,

The bot is currently being triggered when a question is answered with "YES". 

[Steve]

It's definitely possible.

[Suvrutt_Gurjar]

@TeeSee1 and @Steve have already given a definitive useful guidance.

You may create a "ChangeTimeStamp" type column called say [Elapsed5Days] that tracks the changes in [Question] column and changes timestamp when the [Question] is answered "Yes"

Then your BOT trigger condition can be something like

AND(DATE([_THISROW_BEFORE].[Elapsed5Days])<= (DATE([_THISROW_AFTER].[Elapsed5Days])-5), [Question])

Assumes [Question] is Y/N type column and you have mechanism to reset it before next trigger cycle of the BOT.

https://help.appsheet.com/en/articles/961638-tracking-changes-using-change-column-types

https://www.appsheet.com/templates/Keep-track-of-when-columns-change?appGuidString=8a1572da-c548-418...

The article below has description of _THISROW_BEFORE and _AFTER values

https://help.appsheet.com/en/articles/961707-workflow#sending-email-only-after-adding-a-parent-recor...