Multiple entries from a single source

  • Profile Image
    cg08016
    Asked on March 11, 2021 at 03:17 PM

    I am setting up a registration system where a teacher will register multiple students for an event. I would like to have each student's information as a separate row in a table along with a field for the teacher id.

    Ideally the teacher enters their id, or it is passed to the form. The teacher then fills out the form and clicks submit creating a new table row. The form then reloads for the teacher to enter another student's information.

    Is there an example similar to this?

  • Profile Image
    Jessica_H
    Answered on March 11, 2021 at 10:19 PM

    Hello cg08016, thank you for reaching us.

    You may want to take a look at our Configurable List widget instead. Kindly refer to this for the detailed steps and instructions: How to Set Up the Configurable List Widget.

    In addition, you may want to consider using Input Tables too. You may want to take a look at the following guide too: Input Table's New Type - Multi-Type Columns 

    Please give it a try and let us know how it goes.


  • Profile Image
    Jessica_H
    Answered on March 12, 2021 at 12:27 AM

    Hi cg08016, thank you for your updated response.

    To clarify, would you like the ability to add many column lists and allow your user to add as many rows as they need are what you are looking for? If that's the case, Configurable List should fulfill your need.

    1615526582_604afab6c1daf_

    Kindly also refer to the following demo I have created: 210700483380043. Please give it a try (test submissions, etc) too.


    Is there some way for the submit button to take you back to the form with Teacher prepopulated?

    Could you kindly elaborate further on this? You can pass from A to form B by using the URL parameter. However, in order to make sure, could you provide us the detailed workflows on what you are trying to achieve?

    Kindly let us know so we can better assist you with your problem. 

  • Profile Image
    cg08016
    Answered on March 12, 2021 at 05:06 PM

    Hello Jessica_H,

    Thank you for your response.

    My goal is to generate a table with one row per student and a column for each form field including a single common unique id/key for all registrations entered by a teacher.

    For example:

    T-01 registers two students, T-02 registers 1:

    1615585614_604be14eb5768_

    As I recall, when I downloaded the table result as an Excel spreadsheet from my earlier Configurable list test the spreadsheet contained a single row with all of the Configurable list data in a single cell.

    I was not able to find the table generated by your Input list demo, so I can't tell whether that generates separate rows for each row in the Input list although I believe I tried this previously and all the results ended up in a single row in the table. Regardless, I would ideally like to avoid having the teacher retype the Teacher ID to reduce the chance of errors. I would also prefer not to have a set number of rows in advance.

    Form https://www.jotform.com/build/210678452380053 is an example of the form I would like to use. However, instead of a SUBMIT button it might have NEXT and DONE buttons. Ideally when NEXT is clicked the current form is submitted generating a new row in the result table but instead of getting the confirmation screen the form clears, except for Teacher email (id) and they enter information for another student. This continues until they click DONE at which point they get a confirmation screen.

  • Profile Image
    Patrick_R
    Answered on March 13, 2021 at 07:06 AM

    Hello! You can achieve auto-filling of values with pre-population.

    As an example, please check this form: https://form.jotform.com/210712441493045

    The teacher field in this form can be prepopulated from the URL itself (examples provided below).

    1. https://form.jotform.com/210712441493045?teacherId=T-01
    2. https://form.jotform.com/210712441493045?teacherId=T-02
    3. https://form.jotform.com/210712441493045?teacherId=T-03

    The data generated in this way would be in separate rows and can be downloaded in Excel spreadsheets as separate rows itself. This is because every entry will be a different submission. So, basically all of your teachers will have their own URL which they'll use for entering student information. They'll still need to submit the form.

    Apart from this, we can also implement a functionality that can redirect user back to the same form and with the teacher id value set to what it was set last time. We can use redirection technique here. As an example, if you submit this form with whichever value in the 'teacher id'; user will be redirected to the same form with the same value set (you can try any of the above URLs).

    You can try it by submitting a test entry using any of the URLs provided above.

    Redirection URL of this form is set to: https://form.jotform.com/210712441493045?teacherId={teacherId}

    Please give it a try and let us know if this doesn't solve your purpose. If you want to clone this form into your account; then you can do so by following these instructions.

    I hope this solves your purpose, in case it doesn't or if you have any further questions, let us know.

    Thank you!

  • Profile Image
    cg08016
    Answered on March 14, 2021 at 11:38 AM

    The redirection technique should do what I need. Thank you.

  • Profile Image
    cg08016
    Answered on March 15, 2021 at 10:55 AM

    I was able to loop through the registration process using conditional logic and a redirection URL.

    At this point I am exiting the loop by based on whether the student name field has been populated. However, this results in an empty record in the table.

    I would like to clean things up a bit by having a Done/Exit button that goes to the Thank You page without submitting the current record.

    Is it possible to avoid submitting empty records?

    If so, Is there a way to change the functionality of the Submit button based on whether a field is populated?

  • Profile Image
    Nik_M
    Answered on March 15, 2021 at 04:15 PM

    It is not possible to go to the Thank You page without submitting the form.

    You can prevent users to submit a blank form, by making the form fields required.

    Related Guide: How to Set a Field as Required or Non-Required

    The function of the submit button can't be changed, but you can hide it with conditional logic if a field is empty.

    Related Guide: How to Show or Hide Fields Base on User's Answer