Help

Creating a matrix in an Airtable form

1476 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Rob_Webbon
4 - Data Explorer
4 - Data Explorer

Hi all,

we’re a custom sportswear company using Airtable to track orders.
At the moment we have a single line item for each garment ordered, and the numbers of each size.
The view is grouped by contract number so we have all garments for each client grouped together. So for example we might have:

Line Contract Garment XS S M L XL
1 1875 Bobs Bikes Cycling Jersey 1 2 3 2 1
2 1875 Bobs Bikes Cycling Shorts 1 1 1 3 1
3 1875 Bobs Bikes Cycling Jacket 0 2 2 1 0

My question is whether I can collect this information in an airtable form to auto populate our airtable? I have tried creating a form for this but under Garment it will only allow me to choose one garment, OR I can setup the garment field to allow the form filler to choose multiple garments . But in the former case I can only collect information about one garment, in the latter then it’s not possible to collect the sizing information for multiple garments because the form will just collect one set of numbers.

Any ideas whether it’s possible to collect this information via an airtable form or do I have to look for a different route?

Rob

1 Reply 1
Mei_Yi_Yeap
5 - Automation Enthusiast
5 - Automation Enthusiast

Would love to know abt this as well, thanks!