- kranaiAsked on February 17, 2016 at 07:10 AM3. is there any advantage between using the excel file option and placing data in my local MySql DB in my web server? I need to choose one option and I am finding the best option that will give me flexibility in accessing the data and also my historical data is kept safe ? Appreciate your input here.
- CarinaAnswered on February 17, 2016 at 10:36 AM
Connecting the data to a MySql database will need some programming knowledge so the Excel option will be a simpler but effective option.
As long as you don't delete the submissions from your Jotform account and you have a strong password, which you keep safe, your data will be safe inside your Jotform account. You can also access it at any time.
Unless you have any extra reason for the MySql database, the Excel option probably suits your needs, but it's much easier to implement.
Let us know if we can assist you further.
- kranaiAnswered on February 17, 2016 at 10:51 AM
Thank you for your prompt reply. I agree the excel option is much neater and easy to handle. For MySql option it will require me inserting PHP code to get it working. In the meantime I will use the excel option to store my data. I envisage that I will also need the MySql option at some later time for another form but will come to this once I have completed what I am doing now.
- JotForm SupportKiranAnswered on February 17, 2016 at 02:15 PM
Anytime, Kish. You can always get back to us anytime if you need any further assistance. We will be happy to help.
Thank you for using JotForm!!