How to design fields for a shopping list

Hi

I hope someone can help, I am new to Airtable and have a project for a customer and wondered the best way round creating the solution.

My customer is wanting to create a list of blocks that when exported as a CSV will create a shopping list for the actual ordering of the material.

For example, they could have a number of orders per week for different products and they then need to create a list of all the parts to purchase.

My initial idea was to create drop-down lists of the options across all their products and then my customer as they get orders will select the part and the number required for each part, but there could be a number of sections to the list on each order line so could have multiple of the same items (let’s use different screw sizes as an example)

My other thought was, as I am new I don’t know if this is possible, they create somewhere all the parts for each product and then when they get an order, they select the product against the order and it auto-populates with the items required for that one order within the one product and then they can export a CSV and pivot it to create their full order list for the week

Not sure if I have explained this well, but hoping someone can help

Many thanks in advance

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.