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…
Solved! Go to 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]
Hi @Pro_Nature
Did you check out any of the sample apps? There are a few Inventory ones.
did not find any with such a 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]
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |