Solved: A bot that should be triggered only when a conditi... - Page 2

maretec · 02-29-2024 07:45 AM

I have a non-virtual column called "Gel Pack" in the table AWB. It's an Enum column with 2 values: "Yes" and "No".

I have a bot that must be fired with the "Add" event and when the value of the column "Gel Pack" is "Yes" (if the Gel Pack column is "No", the bot must not be fired).

If I click on "Test", it shows that the Event condition is "False" when the Gel Pack column is "No", and it's "True" when the Gel Pack column is "Yes".

The app is in Prototype mode.

Why is it triggered all the time?

maretec

OK. All of these explanations are useful. Thank you.

Going back to the bot, I found the problem. I tried this:
1- I configured the bot without the condition ([Gel Pack]="Yes").
2- I wrote an IF statement in my script to run the function if [Gel Pack]= "Yes", otherwise, to not run the function.

To my surprise, a due date was still entered into the Google Sheet. That means something was entering the date. I looked at the "Expiration Date and Time" column and found that there was a "Now()" expression in the "Initial Value". The logic and the bot were always fine. The "Now()" expression was the cause of the problem.

I'm sorry. I know you spent time on this. I hope this post can be helpful to someone with a similar issue.

View solution in original post

A bot that should be triggered only when a condition exists, runs all the time.