Solved: Inventory app - virtual column formula to show ava... - Page 2

nadim_dayoub · 05-12-2021 05:44 AM

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

Marc_Dillon

From your 3rd screenshot it looks like you’ve maybe renamed the “Related Inventorys” REF_ROWS virtual column to just “Inventory”. If that is the case:

COUNT( SELECT( [Inventory][Model*] , ISBLANK( [some column**] ) ) )

* “[Model]” here can actually be any column in the child table, doesn’t matter.
** Replace “[some column]” with whatever column you want to use to exclude a serial from the count when it is filled out.

View solution in original post

Inventory app - virtual column formula to show available stock based on # of serials of a model