Prefill form in a table format with multiple entries

I have a challenging situation that I'm hoping I can build a jotform for. Ideally, I would use the spreadsheet to form widget and prefill a table, but I don't think it has that functionality.

The user needs to enter their company number which will prefill a list of employees associated with that company, including the employee name and a unique ID code. The user then needs to provide wage amounts for the listed employees. Can you think of a way I can accomplish this? There might be as many as 100 employees at a company, and as many as 500 companies.

Hi jplount,

Thanks for reaching out to Jotform Support. The Spreadsheet to Form widget is a great way to prefill 100 employees based on the Company Number. However, the Input Table field type is not supported for prefill, so you will need to use individual fields or other supported elements like Short Text or Dropdowns for employee names and IDs. Wage amounts can be entered by users in the form fields accordingly. Check out the sample spreadsheet that I created for my demo form:I used Short Text fields for all the fields in my demo form with the same label as the columns on my sheet. Check out the screencast below to see how it works after:

This method allows users to enter the company number and have the employee data prefilled, then they can input wage amounts for each employee.

Give it a try and let us know how it goes.

Another challenge is that some companies may have 5 employees while others have 50. Ideally, when a company logged in with their company number they would see fields for their employees but no extras. There's probably not a way to do that, is there?

Hi jplount,

Jotform's Conditions feature lets you dynamically show or hide fields based on user input, making it possible to tailor the form experience for each company. Let me show you how to set it up:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.

2. Click on Conditions on the left of the page.

3. Now, click on Add a New Condition and then click on Show/Hide Field.

4. Set the conditions like you see below:

Set up Conditions for all of the employee fields. Check out the screencast below to see how your form will work after setting up the Conditions:

Give it a try and let us know how it goes.

Yes, I know how to set up conditions. I was just hoping there was a way for me to accomplish this without building hundreds of fields and conditions.

Hi jplount,

Unfortunately, this will need to be configured manually for each set of fields. However, to help minimize the number of conditions, you can review your records to identify the smallest number of employees.

For instance, if the smallest company has 20 employees, you can assume that the first 20 employee fields will always be shown. From there, you only need to create conditional logic starting from the 21st employee field onward. This approach helps reduce the total number of conditions you need to set up.

Let us know if you have any other questions.