Bot problem

[DSolano]

Hi guys.

I'm having trouble with a simple bot, and I can't figure out why.

I just need it to send an email when the value in the "Online Stock" column of a table (NEW PRODUCTS) changes and is less than 4. I've tried everything I can think of, but it's not working, the bot isn't triggering.  If I set a different condition (for example, that the value in the "Online Sale" column changes and is "YES"), it runs without any problems. Where could the problem be?

The "Online Stock" column is of type Number and is the result of adding two other columns from the same sheet.

Thanks in advance

[Steve]

Bots cannot be triggered by changes to values of virtual columns.

[DSolano]

 Hi Steve. Thanks for your answer.

But it´s not a virtual column. 

I have to say that this column is the result of a sum of two columns within the spreadsheet, it is not a value entered or calculated directly from the application. If the problem were this, how could I solve it?

[Steve]

Ah, yeah, that's a problem. Bots also can't respond to changes made outside the app, such as changes made directly in or by the spreadsheet. Consider doing the computation within the app instead.