Bot doesn't trigger to change value

[Yogi_Hayate]

Hi community, i am new and try to automate things using bot.

I have two tables, one as Inventory Logbook and other as Stock Item Database.

My Inventory Logbook used to record inflow and outflow of my item. 
Stock item Database used to show total amount of my item.

In Stock Tables, I used virtual column [Total Amount Item] to sum all activities in Inventory logbook. And I also have a [Minimum Quantity] for each item, and [Stock status]
 
I want to make a bot that change a [Stock status] to "Stock Empty" every time
[Total Amount Item] < [Minimum Quantity] 
[Stock status] to " Stock Available" every time
[Total Amount item] >[Minimum Quantity]

I have tried to create a bot in Stock item Database that trigger by an event
[_THISROW_AFTER].[Total Stok Tersedia]<[Quantity Minimum]
then run data action set a value in this column [Stock Status] to "Stock Empty"

But when i try to send some item from my stock until the stock Empty. The bot didn't trigger.

How can i fix this?

[Marc_Dillon]

Bots trigger on data changes. The re-calculation of a Virtual Column is NOT a data change. You would need to set up your Bot's Event to trigger on the table that is actually changing, the Inventory Logbook in your case it sounds like.

[Yogi_Hayate]

Thanks from the reply

From Inventory Logbook, I have tried to use action : execute an action to set a values in columns  [Status Stock] in Stock Database.  However, there were nothing happens. 

Do you have any idea how link an event from Inventory Logbook and trigger Status change in  [Status Stock] ?