Using a Table to fill data on a form

[bmayers]

I have a Table with  following that has all the data and new products being added.

i have a form set up to request parts with the following.

i am trying to make it where the user can enter Department, Machine Center, Part Number, Part Desc or scan the barcode to retrieve the data from the table that matches and auto fills in the other ones. 

In a perfect world they could just use the barcode to find the part they are wanting to reorder but not all our parts are in with a barcode and it might be easier to find by department, machine center etc... 

so i have tried to ref the 2 barcode columns from each table and using dereference to the other columns which works great if i only wanted to use the barcode column to filter my data. 

[TeeSee1 · Accepted solution]

Yes, there are limitation, especially UX, to what AppSheet can do.

I have modified the previous app to demonstrate some of the capabilities.

The first sequence is where the barcode is available.

The second sequence is where you see dropdowns getting narrowed down first and then when you see what you do not want, you manually enter values to both request a part and a also update a new part creation.

I am not sure how much more can be done with AppSheet but it is I believe very close to what you are looking for.

Hope you can find a workable solution with your not so PC savvy maintenance people.