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.


  • Profile Image

    Hi can the form support the examine the data from excel or Database?

    Asked by rexjimtw on June 21, 2012 at 05:13 AM

    Hi we have a free gift plane, but we have to avoid repeat phone number or maybe ID .

     

    Please help me.

  • Profile Image
    JotForm Support

    Answered by jonathan on June 21, 2012 at 05:40 AM

    Hi,

    The form have integration feature to google spreadsheet . Maybe this could help already.

    I am not really sure about your inquiry. Would help us very much if you can provide more details on what you needed to do with the form.

    Will await for your response.

    Thanks.

  • Profile Image

    Answered by rexjimtw on June 21, 2012 at 05:46 AM

    Well, I want to have a text area let user to enter there phone numbers, and I can also examination is this phone number was in my database.

  • Profile Image
    JotForm Support

    Answered by jonathan on June 21, 2012 at 06:05 AM

    The form does not really have a 'direct' integration to databases. So, out-of-the-box you cannot easily map the form fields directly to a database fields.

    However, you can generate reports (Excel, CSV, google spreadsheet) out of the forms submissions data. Using the submitted data in the chosen reports format(excel, csv, google), you can now have the means to import or map the data to your database (using query or integration services in ms sql will easily do this)

    Base on your detail, if I am to do it, -- then I will create text fields (phone numbers) on the form, generate the reports, then import/migrate it to my database.

    You can also check this article in our guide -How-to-Insert-or-update-form-submissions-to-your-MySQL-database-using-PHP as it explains how to do it using MySQL db and PHP.

    Hope this help. Feel free to contact us anytime if you have further inquiry.

    Thanks.