Can we populate / fetch / import data from a Google Sheet to our form fields?

  • Profile Image
    ProfilGrec
    Asked on August 24, 2018 at 06:24 AM

    Hello great team of Jotform!
    Just to say that your support team guys ROCKS

    So I would like to ask you if you consider providing this Google sheet fetching function anytime soon? I see some other people are asking you so in the forum. The reason why is so important is that it will be super helpful to do a lot of new actions with the form. 

    For instance I want to create an order reception form for my clients, but I have no way to update the products' stock availability (than.. manually of course !). 

    Or another important feature we could effectuate would be to populate some fields after one is filled (like a client puts his name and afterwards the form auto-populates his address, email, phone etc). Doing so with conditional logic is way to hefty if you have tens or a few hundreds of them...

    Thanks for keeping me posted please
    Aggelos

  • Profile Image
    BJoanna
    Answered on August 24, 2018 at 10:32 AM

    Thank you for your kind words. 

    I am sorry but I do not understand your first question: "So I would like to ask you if you consider providing this Google sheet fetching function anytime soon?". Can you please explain in more details what exactly are you trying to achieve. You can also provide us the links of the other forum thread where you saw the same requests.

    Regarding your other question - The form can be prepopulated with the Spreadsheet to form widget and prepopulate app.

    How to Use the Spreadsheet to Form Widget

    https://prepopulate.jotform.io/