YES/NO column returns to TRUE for apparently no reason

I have an action that turns a YES/NO cell from FALSE to TRUE which triggers a bot that creates a pdf. The last action in the bot switches the TRUE back to FALSE. Soon after the cell switches from FALSE back to TRUE. I searched all the actions and I don’t see anything that would do this. Any ideas? Thank you in advance!

What do you have in the part where it says Trigger another bots?

How did you configure the event?

Is the column value set to reset every time the row is edited?

1 Like

Trigger another bot is disabled.

The event is triggered when [Update Save]=TRUE

[Update Save] does not reset on edit.

1 Like

When you use a flag column (Yes/No column) to trigger a Bot, You want to set the flag to TRUE and then immediately set it back to FALSE.

What could be happening is the flag is left as TRUE for too long and there are additional edits happening on that same row. IF those additional edits, with the flag state as TRUE, are then submitted AFTER the Bot finishes, the flag column will be overwritten with TRUE.

A second reason to immediately reset the flag is to prevent un-desired triggers of the Bot.

I can’t be 100% this is your issue but resetting the flag is a good start to analyzing the source of the problem.

I hope this helps!

4 Likes

Thank you WillowMobileSys!! That seems to have fixed the issue. Much appreciated!

2 Likes