Skip to main content

Help!

L

Hi! I need help. I am attempting to connect a Jotform to my Airtable. Here is the problem: on the Jotform, users can submit multiple students to nominate on one form (ex: student 1, student 2, etc). From there, I want the data to populate on my airtable base as separate students. Right now, it only gives me the option to link one student to airtable base. does this make sense?

Basically, I just need to figure out a way to configure my Airtable to accept multiple submissions of students. 

We have used Airtable to collect event participants info, etc. Now, when a jotform collects multiple participants info on one form, I am unsure how to populate that onto airtable as seperate  people.

5 replies

TheTimeSavingCo
Forum|alt.badge.img+18

Hmm, so you want one JotForm submission to create multiple records in Airtable, one for each nominated student, is that right?  Could you provide screenshots of the relevant tables and the JotForm itself?  That would provide an idea of what your workflow is like and what your data setup is

Adam, Consultant @ The Time Saving Co
L
TheTimeSavingCo wrote:

Hmm, so you want one JotForm submission to create multiple records in Airtable, one for each nominated student, is that right?  Could you provide screenshots of the relevant tables and the JotForm itself?  That would provide an idea of what your workflow is like and what your data setup is


Yes! That is correct. 

Here is the jotform! https://form.jotform.com/241916511805151

1 Attachments
TheTimeSavingCo
Forum|alt.badge.img+18
Lindsey_Twining wrote:

Yes! That is correct. 

Here is the jotform! https://form.jotform.com/241916511805151


Thanks for the details!  If it's possible I'd suggest just using Fillout.com for this (https://www.fillout.com/) as they have the functionality you want (https://www.fillout.com/help/create-new-linked-records)

If you want to use JotForm, I think I'd:
1. Create all the fields needed per nomination for each student, e.g. "Student 1 Name", "Student 2 Name" etc
2. Rename the main table to be "Form submissions"
3. Create a new table called "Nominations" and link it to "Form Submissions"
4. Create automations that would trigger based off of whether those fields had values
  - e.g. if Student 1 Name has a value, create a record in "Nominations" with the appropriate data
  - if Student 2 Name has a value, create a record in "Nominations" with the appropriate data

Setting up Fillout.com for this would be faster / less complicated overall I think

Adam, Consultant @ The Time Saving Co
L
TheTimeSavingCo wrote:

Thanks for the details!  If it's possible I'd suggest just using Fillout.com for this (https://www.fillout.com/) as they have the functionality you want (https://www.fillout.com/help/create-new-linked-records)

If you want to use JotForm, I think I'd:
1. Create all the fields needed per nomination for each student, e.g. "Student 1 Name", "Student 2 Name" etc
2. Rename the main table to be "Form submissions"
3. Create a new table called "Nominations" and link it to "Form Submissions"
4. Create automations that would trigger based off of whether those fields had values
  - e.g. if Student 1 Name has a value, create a record in "Nominations" with the appropriate data
  - if Student 2 Name has a value, create a record in "Nominations" with the appropriate data

Setting up Fillout.com for this would be faster / less complicated overall I think


Thank you so much!!! I would love to book a time with you, as I am still struggling. The only times I'm seeing is at 11:00pm tomororw night. Do you have anything during the 9-5 day?

TheTimeSavingCo
Forum|alt.badge.img+18
Lindsey_Twining wrote:

Thank you so much!!! I would love to book a time with you, as I am still struggling. The only times I'm seeing is at 11:00pm tomororw night. Do you have anything during the 9-5 day?


No worries!  Hmm, could you DM me your timezone please?  We might just be in really difficult to match timezones I'm afraid 

Adam, Consultant @ The Time Saving Co

Reply


Most helpful members this week

Terms & Conditions