Re: Creating an entry form - Using multiple options - HELP

657 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am trying to make a competition entry form, I currently have one field where users can select which competition class/section they want to enter.
BUT I need a way where when they click on each class they enter, to say how many entries they are doing per class.

Some people might add 10 selections of different classes, but 3 of these could be in the same class.

I have two tables - 1 with all the entrant data, then 1 which details to the classes and links to the entrant table and form allowing them to pick which class they want to enter.

I’m new to Airtable and could really do with some urgent help.


3 Replies 3
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Joseph,

Do you mean you want to restrict the number of classes a user selects on the form? If so, that’s not possible. You could add a description telling users they can’t select more than X classes.

If you mean you want to count the number of entrants you have per class, you can use the Count field type which will count the number of linked records (e.g. number of entrants per class).

4 - Data Explorer
4 - Data Explorer


No basically I have a field where they can click which classes they are entering in the form. They could enter class 1, 2, 3, for example. But I need a way of them being able to say how many entries they are doing in class 1, 2, 3. Eg 'Sharon might enter 2 lots of cookies in class 1, 4 lots of cakes in class 2, and 1 lot of cheese into 3.
At present she would just select class 1, 2, 3 - with no way to say how many of each class she’s entering.

Hope that makes sense and you guys can help me out!

There are a couple ways to go about this. One is to have a fixed number of possible submissions that one person can make (say no more than 10), and create the appropriate number of fields to accommodate that. With each submission, you’d have three fields: a quantity field, a “type” field (i.e. “cakes”, “cookies”, “cheese”, etc.—either a single-select if it’s a predefined list, or an open text field if not), and a class field (linking to your [Class] table). The downside is that it’ll take a good bit of time to make all of those fields, plus if someone wants to make 11 submissions, they’re out of luck, so you might end up making way more fields than you really need just to accommodate those really ambitious people.

Another option is to keep the form small, with only the three key fields listed above (plus the person’s name and any other contact info you want to collect), and they’ll have to fill out the form once for each submission. Much easier for you, but more cumbersome for entrants because they have to enter their name (and other info) into the form every time, rather than once for all submissions.

You might also be able to use a third-party form tool like Jotform to build this entry form and tie it into Airtable. One of Jotform’s features is a variable-length collection of fields in a row (I don’t know the official name for this, but someone showed it to me the other day in a screenshare). Need a new row? Click the + button on the end to add it. This way entrants can submit as many or as few entries as they desire, with each entry row having its own quantity, type, and class selections, and you’re not taking time to make all of those fields manually. I think there are some possible caveats with this particular feature in terms of tying it into Airtable, but it might be worth a look.