Finish my APPSHEET app for Clothes Factory inventory management

Job ID: 30715072

Budget: $10 – $30 USD

My app is inventory management, but a little bit more complex because need to work with a little bit more variables for each product, like size and color
There is three issues to finish my app,
- >First it is fix a deppend dropdown(Products), to automatic update the next input (REF of product) when the user select an option on the dropdown.
->The second is fix the ScanBar id input is working well for any product, that means thar checks if scanbar_id is availible, and unique, remember there is 3 variable for each product (REF,Size,color)
->Help me code the final inventory sheet view, that shows the product and colors on a line, and all the sizes as column, to create the final sheet show quantity for that exactly cell.