- CharlesobiAsked 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.
- JotForm SupportliyamAnswered on August 19, 2017 at 06:56 AM
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.
- CharlesobiAnswered 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.
- JotForm SupportliyamAnswered 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
- CharlesobiAnswered on August 19, 2017 at 08:04 PM
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.
- JotForm SupportliyamAnswered 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.
- rwaldenjrAnswered on September 10, 2017 at 10:54 PM
- JotForm SupportNik_CAnswered on September 11, 2017 at 01:59 AM
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.
- JotForm SupportNik_CAnswered on September 11, 2017 at 02:28 AM
You can check a workaround I provided in this thread: https://www.jotform.com/answers/1244043
It might work for you.