Inventory form material/quantity/unity

[Benjibenjo]

 Hello, I am making an application to allow my workers to fill out a form on appsheet. The goal is to allow them to select several materials from the app and to associate to each of these materials the unit and the quantity. The problem is that I can't associate to each material a unit and a quantity. The problem is that I can't associate each material with a unit and quantity, so I would like help to add multiple materials with the quantity and unit by filling out one form and not filling out one form per material. Thank you for your help

[dbaum]

Try sharing a mock-up of the forms you envision and some sample rows of data. That would likely enable someone to understand your need enough to provide targeted guidance.

[dbaum]

Now that you added screenshots to your original post, my best inference is that you want users to be able to select multiple values in the Material column as well as enter a unit and quantity for each of those values. There are probably ways to accomplish that, but they'd be highly complex and fragilely prone to error.

By "not filling out one form per material" maybe you mean that for some reason you don't want to use a child table, but that's seemingly the right approach for your data. ICYMI: The "item-detail" data pattern - AppSheet Help.