Import data real time from Google Spreadsheet to form fields

  • samliramex
    Asked on July 12, 2019 at 2:38 PM

    Dear support team!

    I have a question, i hope you could help me.

    Is that posible to import information from a data base on a google spreadsheet into a form with some widget? 

    Regrats!

  • Mike_G JotForm Support
    Replied on July 12, 2019 at 3:13 PM

    I'm not sure yet how would you like to use the imported data. But if you want to have the imported data to fill form fields based on input in another field, then you can download the data from Google Spreadsheet as an Excel file. Then upload that Excel file to a Spreadsheet to Form widget. For more information on how it works, please see this guide — How-to-Use-the-Spreadsheet-to-Form-Widget

    However if, in any case, I have misunderstood your concern, please do not hesitate to let us know and give us more details.

  • samliramex
    Replied on July 12, 2019 at 4:07 PM

    Thanks for the answer, Mike. I already used that widget but I would like to know if there is another widget to do the same but in "real time". For example, a form to create a clients data base, in this form when i sumbit through an integration i receive the data on a google spreadsheet, but is posible that this data could be import as an input into another form field where i could select the actual clients and add new data?

    Regrats

  • Mike_G JotForm Support
    Replied on July 12, 2019 at 4:26 PM

    I'm afraid that the feature you are looking for isn't available.

    Right now, it is not possible to import data from Google Spreadsheet into the form and it is not possible to set field options coming from an outside source, like databases.

    Kindly confirm if I have understood what you are trying to accomplish correctly so I can forward it to our developers as a feature request.

  • samliramex
    Replied on July 12, 2019 at 5:31 PM

    I confirm, thanks! It could be an awesome feature. 

  • Mike_G JotForm Support
    Replied on July 12, 2019 at 5:55 PM

    Thank you for confirming.

    I have forwarded your concern to our developers as a feature request.

    Although we cannot provide a timeframe for when the feature will be implemented, please be assured that once there is an update we will notify you in this thread the soonest.