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?
LinkedIn
Twitter
