Multiple entries from a single source

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?

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.

Hello Jessica_H,

Thank you for your response. Unfortunately the options you suggested all seem to generate a single table row.

I am effectively trying to loop a form keeping just the heading so that I get multiple rows without having to reenter the heading:

Teacher Name Age Level

Mr. A bob 10 I

Mr. A carol 15 A

Ms. jan 12 LE

Teacher would only be entered once. Name, Age and Level would be entered for each student

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

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.

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. 

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:

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.

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!

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

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?

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