# Creating a Consolidated Order Form for Items Linked to a Specific Supplier/Category **URL:** \ **Category:** Ask for Help\ **Created:** [July 27, 2023, 9:48pm UTC](https://community.glideapps.com/t/creating-a-consolidated-order-form-for-items-linked-to-a-specific-supplier-category/64436 "2023-07-27T21:48:01Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 28, 2023, 12:27am UTC](https://community.glideapps.com/t/creating-a-consolidated-order-form-for-items-linked-to-a-specific-supplier-category/64436/2 "2023-07-28T00:27:21Z")
I think the main question here is how you want the data to look like after the “submission”. Normally, I still keep them separate in 2 tables, one for “Order Items”, which stores individual items and their quantity, and one for “Orders”, basically a consolidated row, with relations and a joined list of items in that order. If you can live without the “Order Items” table, maybe you can create a flow like this: - Use a method to grab the supplier’s ID to the User Profiles table when you view the supplier’s page. - Add a user-specific column to store the temporary quantity for each supplier’s item. - Create a template like “Item x 5” with Item being the Item name, 5 being the user-specific quantity. - Back to your User Profiles table, create a query using the supplier’s ID to return the supplier’s item rows where the quantity is not empty. - Create a joined list column on top of the query, and submit it to the “order row”. - Find a way to clear the user-specific columns for the next order iteration, if needed. > [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211): > > There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n… Not an easy concept to grab. --- _[View the full topic](https://community.glideapps.com/t/creating-a-consolidated-order-form-for-items-linked-to-a-specific-supplier-category/64436)._