Clarification About Quantity Input in Airtable Form

Hello ​@Surrender,
You're close! Airtable Forms submit one record per form, so to collect multiple drink quantities, create number fields for each drink (e.g., “Cola Qty”, “Water Qty”) in your table. Then include those fields in the form. This way, users can enter quantities for all drinks in one submission. It’s the simplest and most effective setup for your use case.


Best Regards,
Delia Guzman

Dear ​@delia598guzman ,

Thank you for the explanation.

The method you shared seems effective when the number of items is fixed at around 3 to 5 (e.g., drink orders).

However, if the items to be managed reach dozens or even hundreds (such as a parts list) and continue to increase over time… Does this mean we would need to create a separate column in the table for every single part — “Part A Qty”, “Part B Qty”, “Part C Qty”, and so on — and also add all of those hundreds of fields to the form?

I’m not entirely sure if I understood correctly, but thank you for sharing the method.

Best Regards,

Surrender

Yeah your understanding is fine I’m afraid, at this point we cannot use Airtable forms to create multiple records

Try using Fillout.com (https://www.fillout.com/) for this.  The idea will be to have two tables:

1. Line Items
2. Orders - Linked to Line Items

The Fillout form will be set to create records in the Orders table, and your users will be able to create multiple Line Item records that are linked to a single Order record, which would allow them to create multiple drink requests in one submission

---

Fillout works fine for this, but creating each line item introduces a bit of loading time.  If you don’t need each line item to be tied to an ‘Order’ type record it might be faster to just get your friends to resubmit the form a few times in a row, really

​@Surrender 

That is not possible with Airtable’s forms.

However, you can do that with Fillout’s advanced forms for Airtable, which lets you create new linked records on a form, perform math or other live calculations on your forms, and much more.

I demonstrate this on this Airtable podcast episode:

• Using Fillout to create an order entry form with line items.

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, pre-fetch dynamic data from an Airtable record, customize the style and branding of your form, customize a theme for your form, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, 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 more of the advanced features of Fillout on this Airtable podcast episode:

• Using Fillout to update an existing Airtable record & create an eSignature approval process with PDF file creation.

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

Hello, ​@TheTimeSavingCo  and ​@ScottWorld 

.
Thank you all so much for your help!
It looks like using an external integration tool will solve the issue.
I’ll give it a try. Thank you again for your help.

Hey ​@Surrender,

Make sure to reach out if you hit any challenge whilst building your Fillout setup :D

Completely different matter, but would love to have you join our Airtable Hackathon! Make sure to sign up!!

Mike, Consultant @ Automatic Nation 
YouTube Channel

You might want to consider using a miniExtensions Form for this.

It’s the most advanced form for Airtable and provides full editing capabilities with countless advanced features. You can easily allow users to create records across multiple linked tables, so that each element is its own line item in a main record. You can also have it display values from formula and rollup fields as your friends fill out the form and add line items, for example to see a total amount etc.

It’s super easy to set up and well worth a try!