- iondjpAsked on August 31, 2017 at 09:09 PM
I have a question where I used a Numeric field. I now wish I had used a short text field to allow for alpha numeric entries.
The only way I can see around this is to create another field, then hide the current field because I realize if I a delete the current field I will loose the data for the submissions already made with that field (ie. column).
It would be nice if I could convert the field without having to have two fields of data. I'm not sure if the database actually stores the field data in specific datatypes or if it is just the form element that is particular to the type.
- JotForm SupportliyamAnswered on August 31, 2017 at 11:02 PM
Unfortunately, there is no option on switching a of question to a different field type. So yes, for your case, you can just hide the original field and add a new one.
Another method is by using the import app. Using this method, you will need to get a back-up of your data to Excel or CSV. Then use the import app to import data back into your form, but this time by assigning the column in your spreadsheet to a certain field. But before you jump into action, try to check this guide first and likewise do some preliminary tests to practice on how to use the app: https://www.jotform.com/help/308-Import-App-Easily-Import-Your-Excel-or-CSV-Data-into-JotForm