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

  • Profile Image
    Charlesobi
    Asked on August 19, 2017 at 02: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.

     

  • Profile Image
    liyam
    Answered on August 19, 2017 at 06: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.

  • Profile Image
    Charlesobi
    Answered on August 19, 2017 at 08: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.

  • Profile Image
    liyam
    Answered on August 19, 2017 at 09: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

     

     

  • Profile Image
    Charlesobi
    Answered on August 19, 2017 at 08: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.

  • Profile Image
    liyam
    Answered 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.

  • Profile Image
    rwaldenjr
    Answered 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!

  • Profile Image
    Nik_C
    Answered on September 11, 2017 at 01: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!

  • Profile Image
    Nik_C
    Answered on September 11, 2017 at 02: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!