Help with Inventory App

AppSheet AppSheet Q&A
,
1

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

2

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

4 Likes
3

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]

1 Like
4

did not find any with such a solution