Inventory check

Hi all
After some help please on capabilities on the app.

I am trying to move a manual paper based inventory check onto a cloud based app.

Basically a user will provide a pick sheet containing several products and the quantity provided. This is then checked when produced and someone will input the quantity counted. (We have a problem with human error and stock going missing).

So what I want to do is to show in a view the product code along with the stock quantity. Then adjacent to it a editable field to input the count.
There will be anywhere from 1 to 200 different products to count so they need to be listed under each other.

If I imagine an excel sheet I would have column a with product name, column b with stock quantity and column c blank waiting for the user to input the value. I want the same view really.

Can this be done.
Thanks

2 Likes

Absolutely. you should check out the Sample Apps, I’m sure there is plenty of inventory apps that would give you a basic understanding of relevant features you could have implemented into an app.

2 Likes

@Simon_Perks Welcome to AppSheet!!

In particular, for your use case, I would consider the use of an Editable Table. This feature takes a normal looking table view from this:

to this! The table is editable so you could go right down the list updating the number in each row. And yes you can control which column can be edited!! I love this feature!!

5 Likes

Honestly thank you very much, this is just what I was after. I’ll have a look at how you create it but looks spot on

3 Likes

so i am trying to get this working. Can you do a view within a view?

For example - i have several orders on the go, each one then contains a different inventory count.

I want a simple view to start with to select the order, then inside this for it to show the editable table

1 Like

@Simon_Perks, try to create the views that you would like, display them as ‘ref’ to include them into another dashboard type view.
Enable the dashboard to be ‘interactive’ and this should help you get you to where you want to be.

2 Likes

As @Chris_Jeal mentions an interactive Dashboard would be very nice approach.

Another approach would be to have a Deck View (or even a table) of the Orders and then customize the Row Selected behavior to navigate to your table view showing the list of items.

2 Likes

Hi, What is the sample app that is used here?

The images I included above were from a custom built Inventory app - not a sample app.

Hi,
Will you be kind enough to send me a screen shot of under the hood for your app the overall column edit page and also for one of the entries edit page? Does your inventory values that you key in overwrite the previous values entered?