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.
I would like to change add and remove fields from forms without loosing the data...Asked by mastergohring on March 15, 2013 at 11:13 PM
I would like to change add and remove fields from forms without loosing the data as I am constantly tweaking my forms ... yes, I know I can do a work around and clone the form ... which also means I need to edit my webpage to change the code ... which also means it starts over with it's statistics of how many people filled it out ... can you please create that feature ... it seemed to exist before ... is my request making sense?
Maybe we can help you better if you can give us more details on which form you want to do this, which fields you want to change and add.
We all know that deleting fields will result to losing data in the form's submissions. There is no workaround to this for now.
At most, you can always make a backup of the form's submissions data by downloading the submissions or integrating to google docs. Once you have a backup copy of your data, you can then proceed with your form modification.
Will await your response.
You answered my question. I guess you must have just added the warning of data being deleted and I thought that it was something new. I regularly update my data.
Ideally I want my data to stay with you for archival and analysis later.
And for that data to be unchanged even if I edit or add a field.
To answer your first question abou "more details":
I was a newbe, I created fields with just a text box with the form tools function... fields like "name" "birthday" "today's date" etc ... then with more experience I noticed you had a better option under quick tools for "name" "birthday" and "today's date" oh actually "datetime" under power tools ... anyways also for the address field ... I had them all separate ... so I went to change these and got the warning about loosing data ... if I am not clear I specifically added the quick tools for "Full Name" and then went to delete the form tool text box that I was using for the name and a warning came up ... I thought ... this sucks ... I will loose the 100 or so peoples names to change the form.
I am not looking for a work around ... I know I can clone the form redo and re-add it. But I will likely always be tweeking certain forms.
oh, also ... i had to dig through the support forum to find my question ... it would be great to get an email when you have posted a response ... I am only suggesting these things because y'all seem to be on a constant mission to make jotform better ... i love jotform and am now a paying customer that prepaid for the longest term you offered.
I am also aware that even if you used same name fields, it will still not retain your data for the original field that was deleted.
if you delete a textbox field that you named "Your Email" and replaced it with an Email field from quick tools, and still used "Your Email" as name -- you will still loose the submission data.
The best solution will be to backup the data and proceed with the needed changes. Specifically, if you download the data to Excel or CSV or integrate to google spreadsheet, you can always append or add the backup submissions to the new submissions (after modification). I am referring to the Excel or google spreadsheet data (not in the My Forms / Submissions as you cannot edit this database)
You are suppose to recieve email at email@example.com when this thread is updated. Are you not recieving the emails?
I too would like to make some changes but without losing the data (but also would prefer not to have to have two areas collecting data for the same form - one being a back up of the original).
It would be great if when deleting a field we are given the option to keep the data associated or delete if preferred.
In my case I have to change the 'full name' field for the purpose of using the first name only in the auto responders (too tricky trying to pull just the first name from the full name).
So I wonder is there a way I can keep the full name field to avoid losing the data, but make that field invisible to anyone who completes the form from now on? For now I've placed it below the submit button and put it under a form collapse field set to "hidden".
Is there an easier way?
If you delete a form field it will also delete the associated submission data as well. Actually your approach is correct to achieve your requirement. If you need to change an existing question, making a field hidden is the only option available to retain the past submission data and then you should add a new question.
Instead of hiding it under form collapse field, you can use custom css to hide the entire question. Upon checking your form "Who wants to be a Cheeky Face artist.", I found that you have moved the question "Full Name" in form collapse to hide it.
Please inject the following custom css to hide the "Full Name" question:
Basically the idea is to find the id of your question / div and hide it with the help of custom css. Here is a guide to help you find out field ids and name: http://www.jotform.com/help/146-How-to-find-Field-IDs-Names
Here is a guide to help you inject this custom css in your form: http://www.jotform.com/help/117-How-to-Inject-Custom-CSS-Codes
Hope this helps.
Do get back to us if you have any question.