Help with Inventory App

[Pro_Nature]

Hi,

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

[Lynn]

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

[Pro_Nature]

did not find any with such a solution

[AlexM · Accepted solution]

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
[qty]<=[stock]