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.
Editting Bulk submissions options at once?Asked by funkyfro on February 25, 2017 at 01:33 PM
Hi there, we'd like to edit bulk submissions. For instance, on our Team Registration form, we have 'Division 5' as a choice, we wanted to list it as 'D5' so we can view it easier in our Excel Spreadsheets. I know if we change the option in our form, the future submissions will accept the new naming convention, but it doesn't change the existing submissions. Is there a way to do this? Thanks very much for your time.
You're correct, you can't change the name of the selected checkbox for existing submissions. Since you mentioned Excel, you can get around this by using Find & Replace All.
Find 'Division 5' then Replace All instances of it to 'D5'
Related article: Find-or-replace-text-and-numbers-on-a-worksheet
In case you need more help, don't hesitate to let us know.
This doesn't accomplish my result as I'm pretty advanced in Excel and easily know how to do that. I'd like to change every existing result in my submissions, and then match them with my future submissions so I can export the doc or display the form results dynamically on our webpage.
Is there anyway to import submissions? So I'd change them in Excel, delete all the existing submissions on Jotform, then import them from Excel into Jotform.
Yes there is a way to import submissions. You can use the import app: https://www.jotform.com/help/308-Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm