Help with Inventory App


I have created an inventory app where in 1 sheet i have current stock

in another sheet i have all stock issue…

i want a way so that when i am entering stock issue form when an entry is made for more than the current stock it must give a warning saying qty entered is more than current stock…

if that is not possible…how do i ref…a virtual column that is current stock in current stock sheet to stock issue sheet…so that whenever the product is selected…before entering qty of issue i can view current stock level…

@Aleksi @Suvrutt_Gurjar

Hi @Pro_Nature
Did you check out any of the sample apps? There are a few Inventory ones.


I am working on a similar thing but not there yet.
For your issue I thought about having a valid if condition for the qty field

1 Like

did not find any with such a solution