Prepopulate data from Google Sheets

  • Profile Image
    cludlowb
    Asked on December 14, 2016 at 01:59 PM

    Hi, i would like to create a form where if the client its registered in my google sheet with a client code the registration section autocompletes so he doesn't need to fill all data every time. it's that possible?

  • Profile Image
    John_Benson
    Answered on December 14, 2016 at 03:39 PM

    This is not possible to achieve in the Form Builder. The available process here is exporting the data from the submissions to your database. Here's a guide: How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    Please check this app Field Prepopulator, it might be useful for what you're trying to achieve. This will pre-populate the fields with data when your user opened the form.

    You might also want to check Webhooks. Here are the guides:
    How-to-Setup-Webhook-with-JotForm 
    Webhook-Samples

    Hope that helps. Let us know if you need further assistance. Thank you.