Is there a way to pull data from a Google Spreasheet then prepopulate it to a form?

  • JuggleGod
    Asked on January 15, 2017 at 9:42 AM

    Hi, I was about to ask this same question, but saw that it was answered a few years ago. Has anything changed with this as I'd also like to be able to pull up customer information from a google drive spreadsheet. I don't have any formal programming training, so I'm going at this on my own.

    Thanks!

  • Support_Management Jotform Support
    Replied on January 15, 2017 at 9:59 AM

    I checked the workaround provided on the old thread but I'm seeing the test page doesn't seem to be working anymore. Either Google's API were changed since then or the developer has abandoned the script (last commit I see on Github was 6 years ago).

    Although we still don't have this feature, what we have on the other hand is an Import App that will allow you import an XLS/CSV file. Keep in mind, this isn't meant for a form - What this does is import your existing data as Form Submissions.

    I strongly urge you to carefully follow the guide below. There are certain requirements that need to be met to make this work properly so take your time in following the guide if you will give it a try.

    Complete guide: Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm 

  • JuggleGod
    Replied on January 15, 2017 at 5:45 PM
    Thanks for the answer. I’m not sure this will entirely do what I was hoping, so I’ll describe with an example what I’m looking for.
    Could we store user accounts? So for instance, say that Jane Doe wants to register her son for class A and B for this semester. She’s a new customer, so she creates a username that will be tied to her details and her son’s details. She enters in information such as birthday, name, etc… for her son as well as emergency contact information and completes her registration. Next semester, she wants to sign up her son again, but this time for class A and C. Is there a way to where she could input her username, and then all the information such as birthday, name, emergency contact info, etc… is autopopulated from her previous registration so she doesn’t have to fill it all out again, or can update the record?
    Thanks!
    -Warren
    ...
  • amy
    Replied on January 16, 2017 at 2:32 AM

    Hi Warren,

    If you want to make this happen with only one form, I would like to recommend you to use edit submission link feature. But please note that your user can change all fields with edit submission link. For example, you don't want to be changed first and last name. Then you should create a second form and use prepopulate fields to get data from the previous form. 

    For example, Jane Doe filled out my first form and for the next process, I just want to offer her the ability to change certain areas such as e-mail and text message. So she cannot change her first and last name. To make it happen I open the "read-only" option for the second form.

    Is there a way to pull data from a Google Spreasheet then prepopulate it to a form? Image 1 Screenshot 40

    Is there a way to pull data from a Google Spreasheet then prepopulate it to a form? Image 2 Screenshot 51

    After enabled read-only option, I set the pre-population link to pass automatically form data from the first form to the second one. You can review our user guide which is associated with this issue. Also, you can benefit from our field manager app to copy a field from the first form to your second form.

    Please, would you display my result from the .gif image?

    Is there a way to pull data from a Google Spreasheet then prepopulate it to a form? Image 3 Screenshot 62

    Here is my test form if you want to test it: https://form.jotform.com/63282419198969

    After you send a submission, please click on the pre-populated link which is sent to you via auto-responder e-mail.

    If you need further assistance, we'd be glad to help you.

    Kindest Regards.