bespokeappstt
Hubstaff freelancer
I am looking to use Fabrik for an inventory application. So I generated a list that stores all the equipment stock. I have another list that is used whenever stock is sold to a customer. The list that records the sale to the customer has a column that is a database join to the stock list. So lets say the dropdown for the database join shows 3 items in stock, when an entry is made into the sale list can it decrement from the stock list so that on the next sale transaction the dropdown will show only 2 items in stock instead of 3.
I guess another scenario envisioned will be the stock list has a field element representing the amount of items in stock. And every time a new entry is made in the sale list, it decrements from the stock list field element. Is this possible to build in Fabrik?
I guess another scenario envisioned will be the stock list has a field element representing the amount of items in stock. And every time a new entry is made in the sale list, it decrements from the stock list field element. Is this possible to build in Fabrik?