JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Is there any advantage between using the excel file option and placing data in my local MySql DB in my web server?Asked by kranai 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.
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.
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.
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!!