Hello everyone ! I am working on drug inventory management app. here is my tables
1 drugs list
guys I canโt figure out how to update the balance in store table using values from the prescription tables for individual drugs. so that timely stocks can be updated.
pls help, also suggest if there is other way around !
thank you !
Hi @naresh_chauhan1
โCurrent Stockโ should be calculated.
You may want to remove your โbalanceโ column from your sheets, regenerate structure, then add a virtual column โbalance_calculatedโ
[Initial_Quantity]
+SUM([Related Prescriptions][Quantity])
this worked for me exactly the way I wanted thank you so much
in store table I used Related Prescription =REF_ROWS(โprescriptionโ, โDrugโ)
and current stock = [quantity]-SUM([Related Prescriptions][Quantity]) both are virtual column
thanks a lot!
Wouldnโt the [Quantity] have to be -5 in this case? I agree that Current Stock should be calculated. But I wonder what the best way would be to increase the Current Stock and decrease the Current Stock.
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |