How best can my form be able to auto fill customers details?

  • Charlesobi
    Asked on August 19, 2017 at 2:35 AM

    I want to use my form for e-commerce purpose.

    And there will be a part in my form where my customer will have to fill in their details: Name, phone, e-mail, address.

    I don't want a situation where my customers will keep on repeating the process of filling in their address and contact details, each time they (old customers) want to make a new order.

    Is there an autocomplete widget that stores customers contact details once he or she enters it. 

    Such that in the case whereby a customer wants to make a new order, the details can be regenerated once he enters his name and e-mail. 

    I want to know if there's any way this can be achieved.

    Thanks hoping for your helpful reply.

     

  • liyam
    Replied on August 19, 2017 at 6:56 AM

    Hello Charlesobi,

    I noticed this is quite related to the question about autofill on the other thread found here: https://www.jotform.com/answers/1227536 

    To know more about the autofill feature, you can check out this guide: https://www.jotform.com/help/227-How-to-Enable-Auto-Fill-on-Forms

    In addition, you may also make use of the session method. This method uses the server-side saving data but it needs the URL parameter session and a matching identification for that specific temporary submission ID. You can check this guide to know more about this method: https://www.jotform.com/help/97-How-to-Save-Forms-and-Continue-Later

    We have an autocomplete widget but the purpose of this is not for saving a previously filled information by a form user, but a form-based preset data provided by the form owner. Here are some widgets related to this matter: https://widgets.jotform.com/search/autocomplete

    If you have questions, please let us know.

  • Charlesobi
    Replied on August 19, 2017 at 8:11 AM

    Ok, thanks for the reply. The alternative you provided is temporary. That's for a particular form session before clicking the submit button.

    I will be kinda making a suggestion here, I think it will be useful. If a feature can be added in Jotform. A kind of database where a Jotform user can update the contact/address details of his or her clients. 

    This contact details can be fetched when a customer of Jotform user inputs, let's say his / her name and email.

    This will help user experience, especially for e-commerce. Where a customer who likes your product or service will come back to make another order. So that he or she won't be stressed to start filling postal code, nearest land mass, address etc. It also shows that your e-commerce is intelligent enough to recognize them (Jotform Form User's Customer).

    I hope my suggestion is clear enough.

    Thanks.

  • liyam
    Replied on August 19, 2017 at 9:39 AM

    Hello, Charlesobi. I guess I got me confused at some point. I get a clearer picture now where you would like to pull data based from past submissions for them to somehow, pre-fill information based from past submissions such as their full name, email, etc. 

    Unfortunately, there is no way to automate on linking your existing submissions to pre-fill your form. A way which I can think of is to create your own database on your own website, and code the form with AJAX to pull data from your own database to pre-fill fields. Here is how to get your form's full HTML source: https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form 

    Another method is adding a spreadsheet to form widget and import your submissions in the widget. Here is the widget: https://widgets.jotform.com/widget/spreadsheet_to_form

    Here is a link for thee guide for its usage: https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

     

     

  • Charlesobi
    Replied on August 19, 2017 at 8:04 PM

    Ok, thanks.

    I found this helpful.

    "Another method is adding a spreadsheet to form widget and import your submissions in the widget. Here is the widget: https://widgets.jotform.com/widget/spreadsheet_to_form"

    It's very close to what I want. It will be wonderful if it can work with Google Sheets.

    Thanks for your assistance.

  • liyam
    Replied on August 20, 2017 at 12:06 AM

    Thanks for your response, Charlesobi.

    Let me forward a suggestion to the development team for creating a widget or an integration for such feature. But there is no guarantee that this can be implemented anytime soon. However, as soon as we have updates on such development, we'll inform you right away.

    Thanks.

  • rwaldenjr
    Replied on September 10, 2017 at 10:54 PM

    I'm looking for the same thing as Charlesobi, without a lot of backend programming needed! I would think this should be a common request for a lot of us eBusiness form users. Please ask your development team to push this up their To-Do list ASAP!

    Thanks!

  • Nik_C
    Replied on September 11, 2017 at 1:59 AM

    @rwaldenjr,

    I opened a separate thread for you here: https://www.jotform.com/answers/1244043

    I will also check with my colleague about the status of that request.

    Thank you!

  • Nik_C
    Replied on September 11, 2017 at 2:28 AM

    @Charlesobi,

    You can check a workaround I provided in this thread: https://www.jotform.com/answers/1244043

    It might work for you.

    Thank you!