I have this custom list to create requests of items from the image above
The inventory database should automatically update whenever a request is filed. For example, After filing for 10 A4 Bond Paper, it should automatically change the quantity of my inventory database to 4990.
How can I make this happen?
I've come up with this workflow but I thinks it wouldn't be a good practice since for example I have 500 items in my inventory, that would let me do 500 if-else's and everytime I will add new item, I will have to edit my workflow.