I’m trying to track how many stock materials go to any number of different jobs. Example if I have 3 stock products (A, B, C) and 5 different jobs they can be used on (1, 2, 3, 4, 5) I’m wanting to use an app to select the product (B) the job that it will be used on (3) and the quantity of the product (B) that will be used.
I have a table that lists all of my products. I have a table that lists all of my jobs. I’m hoping to generate a new table for each product that lists the date, time, job and quantity that has been applied. I can see that this is a relatively simple process but in my infancy on AppSheet I still can’t seem to put it all together.