What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Multi- Name forms with Google Spreadsheet

    Asked by danielschmoyer on February 20, 2013 at 08:41 AM

    I am a teacher at a high school and we use jotform to have other teachers refer students to a structured study hall during lunch. At the moment we have 1 student per form submission. I have been asked to have multiple students added to the form so teachers can refer multiple students who are missing the same homework assignment. I created a form that had 8 student name fields but when it integrates into Google Spreadsheet the form is not easy to work with or remove students who have completed their work.

    Does anyone know how I can create a form that will integrate with Google Spreadsheet without creating a ton of student name headers and cause confusion with working with the spreadsheet? I have attached a sample of what the spreadsheet looks like now. I would like the multi-student form to integrate the same way the single student form does. Is that possible?

     

    dan

    Page URL:
    https://sites.google.com/a/isd728.org/royal-dugout-referral-site/

    Screenshot
  • Profile Image
    JotForm Support

    Answered by EduardoMendez on February 20, 2013 at 09:40 AM

    Hi there, 

    Unfortunately, every field that you add to a form will create a header on the spreadsheet.

    However, here is a form that may be a solution for you:

    http://www.jotformpro.com/form/30504150802944?

    I have embedded your form on Free HTML fields on a separate form.  I then deleted the submit button and added some collapse fields for easier navigation.

    Because the embedded form is the same one but in different instances, you will only have one spreadsheet with one name column.

    You can clone this form if you wish.  Simply follow this guide:

    http://www.jotform.com/help/28-Cloning-a-Form-from-a-Web-Page

    I hope that helps!