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

  • Profile Image
    rexjimtw
    Asked 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
    jonathan
    Answered 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
    rexjimtw
    Answered 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
    jonathan
    Answered 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.