How to Create Separate Columns for Different Product List Data in Form Tables

Hi Benjamin,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

Regarding your question about converting a form with multiple selections in one field into separate columns for each selection, this can be achieved by using multiple individual fields instead of a single multiple-selection field. Each event or option would have its own field (such as checkboxes or dropdowns), which will then appear as separate columns in your form submissions and tables.

If you want, I can guide you on how to set this up or help you modify your existing form accordingly.

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

am I able to modify already captured data on forms already returned

Hi Benjamin,

Thanks for your follow-up question.

Regarding modifying already captured data on forms that have been submitted, Jotform does not allow direct editing of submissions once they are received. However, you can export the submission data from the original form and then import it into a new form using the Import Data feature. This way, you can manage and update the data as needed in the new form.

If you need assistance with exporting and importing submission data, I can guide you through the process.

yes please guide me

Hi Benjamin,

To copy submissions to a new form and modify your captured data, here’s what you need to do:

1. Export the submissions from your original form. This will give you a file containing all the data collected so far.

2. Import the data into the new form using Jotform’s Import Data feature. This allows you to transfer the submission data into the new form where you can manage and update it as needed.

If you want, I can provide more detailed steps or help you with this process.

yes please

Hi Benjamin,

Here are the detailed steps to export your submissions from the original form and import them into a new form for editing:

Exporting submissions:

1. Go to My Forms and select your original form.
2. Click on Submissions to open the submission data.
3. Use the Export button to download your submissions as an Excel or CSV file.

Importing data into a new form:

1. Create a new form with the desired fields arranged as you want (each event in its own column).
2. Go to Tables in your Jotform account.
3. Click on Import Data and upload the exported file.
4. Map the columns from your file to the corresponding fields in the new form.
5. Complete the import and your data will be available for editing in the new form.

If you need, I can assist you further with any of these steps.

yes please

Hi Benjamin,

One of our Support Team members has taken over this thread and will assist you further. I will no longer be responding here.

thank you, i would like to separate the data in the screen shot which is only a portion of the multiple data in the column

Hi Benjamin,

The Product List is treated as one single field, so its data can’t be split into separate columns in Jotform Tables. Since you're working with multiple selections tied to event options, it’s better to use the Multiple Choice element and set up each option individually. Let me walk you through it:

1. In Form Builder, click on Add Element on the left side of the page.

2. In the Form Elements menu, under the Basic tab, scroll down to Multiple Choice, and drag and drop a Multiple Choice element to your form.

3. Click on the Gear icon on the right side of the multiple choice and go to the Options tab.

4. Finally, enter the option as an individual, and that's it.

Now, each option you add using the Multiple Choice field will show up in its own column in your form’s Tables.

While the feature you're looking for isn't available at Jotform right now, we've gone ahead and escalated your request to our developers. Exactly when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll circle back to this thread and let you know.

Thanks for your patience and understanding, we appreciate it.



Hi Jason

Thank you for this, my big question is this something I can do with currently registered forms or only new entries once I make the changes

Hi Benjamin,

The setup will only apply to new submissions after you’ve added the individual Multiple Choice field. If you set them up, avoid deleting the Product List field from your form, as that will also remove its data from Jotform Tables. Another option is to create a new form and follow the steps above to ensure you’re starting with a fresh setup.

Give it a try and let us know if you need any help.