Inventory App

[Liam_663]

Good day ,

I was using this app from appsheet as a example .

https://www.appsheet.com/samples/Scan-items-with-quantities-to-keep-a-running-inventory-count?appGui...

But is there away to make it that a user cannot make the inventory stock go into a negative ?

Regards
Liam

[Lynn]

Hi @Liam_663
You can set the valid if of your quantity sold column.

[Liam_663]

Thank you very much for the Reply Lynn.

However I keep getting a error that the column cannot be located.

[Lynn]

Hi @Liam_663
This was just an example from my app. Your column names may be different.

[Liam_663]

Hi Lynn ,

No my Column names are the same , is your Current Stock a Virtual table ?

[Liam_663]

This is how the data is set up

[Lynn]

Hi @Liam_663
I have a current stock column in my sales table as well(I probably shouldn’t have two columns with the same name) it is another virtual column which has this formula
ANY(SELECT(Products[Current Stock],[Product Barcode] = [_THISROW].[Product Barcode]))

[Lynn]

@Liam_663
You may check out the Stock management2 app demo
here
https://www.appsheet.com/portfolio/129805

[Aurelien]

Hi @Liam_663

@Lynn just exposed how to get the current stock with a virtual column

ANY(
  SELECT(Products[Current Stock],
    [Product Barcode] = [_THISROW].[Product Barcode]
  )
)

You may want to try this expression as well in the valid_if of the column [Quantity], from the table Sales:
[Quantity]<=[Product barcode].[Current Stock]
Because your Product Barcode si of type Ref, you can use dereference expression to get its current stock.

Please see also:

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

[Aurelien]

Hi again @Liam_663

At looking at previous posts, I found this one:

How to prevent a user from selling more stock than we have? Questions

Hello , New to appsheet here . I am trying to make a Inventory Management app I have a sheet which totals my Stock the Columns are ( Details and Inventory(which is just a Sumif formula in my google sheets that sums the purchases and subtracts the sales) . I then have a sheet that records all my transactions which has Columns ( Date , Time , Details , Purchase , sales ) Then created 2 slices for the Purchase and sale forms and added them as action buttons. However Sometimes Users sell mo…

If my understanding is correct, you ask the exact same question, twice: this is redundant.
I understand you did not find out how to solve your situation, but a simple reminder would have done the job

I understand also that you are very new to AppSheet, this is why I suggest you have a look to this post explaining good practices on the community:

Guide on How To Create a Community Post Tips & Tricks 💡

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…

So, I wish you a warm welcome, and can’t wait to see if you managed to solve your situation !