Creating a Consolidated Order Form for Items Linked to a Specific Supplier/Category

[ThinhDinh]

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

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.