Hello,I’m new to Airtable and in trouble with airtable forms. For example, here is the situation.I collect weekly requests from my school friends through a Form.In the Form, they write how many of each drink they need and submit it.I then store all of this data in a database.Let’s assume my friend wants to fill out the Form like this: Cola: 5 bottles Water: 154 bottles Orange juice: 30 bottles Wine: 2 bottles Beer: 15 bottles I already have a base where each drink—Cola, Water, Orange Juice, Wine, Beer—is listed.However, it seems that the Form does not allow submitting multiple quantities for a single drink. Since I’ve only been using Airtable for a few days, I may be misunderstanding something.Could you please let me know if my understanding is correct?Or is there something that I can try? Thank you for your help in advance.

Clarification About Quantity Input in Airtable Form

Hello,

I’m new to Airtable and in trouble with airtable forms.

For example, here is the situation.
I collect weekly requests from my school friends through a Form.
In the Form, they write how many of each drink they need and submit it.
I then store all of this data in a database.

Let’s assume my friend wants to fill out the Form like this:

Cola: 5 bottles
Water: 154 bottles
Orange juice: 30 bottles
Wine: 2 bottles
Beer: 15 bottles

I already have a base where each drink—Cola, Water, Orange Juice, Wine, Beer—is listed.
However, it seems that the Form does not allow submitting multiple quantities for a single drink. Since I’ve only been using Airtable for a few days, I may be misunderstanding something.

Could you please let me know if my understanding is correct?

Or is there something that I can try?

Thank you for your help in advance.

Be the first to reply!

Hello,

I’m new to Airtable and in trouble with airtable forms.

Let’s assume my friend wants to fill out the Form like this:

Cola: 5 bottles
Water: 154 bottles
Orange juice: 30 bottles
Wine: 2 bottles
Beer: 15 bottles

Could you please let me know if my understanding is correct?

Or is there something that I can try?

Thank you for your help in advance.

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:

Line Items
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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded