I am working on a simple inventory app and trying to create a virtual column that would represent the available stock for a model based on how many unique serials I have.
- Data Sheet of all my models: screenshot-docs-google-com-2021-05-12-08-20-03 — ImgBB
- Data Sheet of all my Serials: screenshot-docs-google-com-2021-05-12-08-20-32 — ImgBB
and for my second question, would it be possible to remove available stock based on if a serial received a timestamp, PO or my amount?
I gave each Serial an amount of 1 hoping to do something with the stock availability, so when I edited the serial to add a PO # I could just take the Amount of 1 away to adjust the stock #… but my theory failed… and here I am