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.