Skip to main content

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

Would love to know abt this as well, thanks!

That is not possible with Airtable’s forms.

You can only do that with Fillout’s advanced forms for Airtable.

You have 3 different ways of doing that:

  1. Use Fillout’s choice matrix field type. 
  2. Use Fillout’s table field type.
  3. Use Fillout to create an unlimited number of line items (i.e. linked records)

To see how to do #3 above, check out my video demonstration here:

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, display Airtable lookup fields on forms, create new linked records on a form, control access to a form via SSO or email domains or a list of email addresses stored in Airtable, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I show how to use a few of the advanced features of Fillout on this Airtable podcast episode:

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Terms & Conditions