How to import data from Google Spreedsheet to your form

  • AgilityAssoc.Canada
    Asked on November 27, 2017 at 1:28 PM

    Is it possible to to get data from a integrated google sheet to fill certain form fields?

    I would like to put the course count accumulated for a month on the sheet into 73214149108956 courses count for each CA.

    I suspect this would have to be done with the form being setup on site and not at JotForm.

    Regards, Robert 

  • TREVON
    Replied on November 27, 2017 at 2:57 PM

    If I understand you correctly you want to be able to use google sheet document with submissions and use it to fill date into form 73214149108956. This can be possible but its a manual process.

    You can use the guide below on how you can achieve this.

    https://www.jotform.com/help/308-Import-App-Easily-Import-Your-Excel-or-CSV-Data-into-JotForm

    So in short what will happen is you export/download the google sheet submission and then in the form 73214149108956 you create the correct fields as in the excel sheet then use the http://import.jotform.io/ app to import the data.

    Kindly do let us know if this will work for you.

  • AgilityAssoc.Canada
    Replied on November 27, 2017 at 5:26 PM

    So I would have to fill each column with data for that form's input. Then import the data. Much simpler just to fill in the form.

    I was hoping I could get the data from a spread sheet that has the data, and have it dump the data directly into each correct input. 

    So, now I have a list of each input I need data for. I then Import data from the spread sheet into the correct column of a new sheet then import the new sheet it to the form. Is this possible?

    Now what if I have a row for each month, Aug to Nov for example. How could I get data for Sep only? I do have a field that is for Dates from-to. Could that be utilized?

    Probably getting a head of my self.

    Thank you, Robert

  • David JotForm Support Manager
    Replied on November 27, 2017 at 8:15 PM

    So, if you are not looking to import submissions from your spreadsheet into your form, and you are actually seeking to prepopulate fields with the values from your spreadsheet, then that would not be possible to be accomplished automatically.

    You would need to export your Spreadsheet to Excel format(.xlsx), and then you could use the "Spreasheet to form" widget: https://widgets.jotform.com/widget/spreadsheet_to_form 

    Here is a complete guide that shows how to set it up: https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget 

    Try the example shown on the guide: https://www.jotform.com/71642066575965 

  • AgilityAssoc.Canada
    Replied on November 30, 2017 at 10:26 AM

    Hi, None of this really helps. Thanks for the feed back. Regards, Robert 

  • TREVON
    Replied on November 30, 2017 at 11:48 AM

    Apologies for any trouble caused. Kindly let us know if you would like us to make a feature request for the issue.

    If I understand the feature is  for users to be able to use Google Spread Sheet to automatically update another form since the workarounds suggested earlier does not resolve the challenges you are facing.

  • AgilityAssoc.Canada
    Replied on November 30, 2017 at 1:15 PM

    No apologies required. I think it would be a valuable feature, but that's me.

    I have suggested many features over the years and none of them have ever been implemented. I understand that requests are weighed based on demand and other criteria. If others don't see suggested features how can they add there comment. I made a suggestion years ago to have a suggestion box forum where users can see what has been submitted, and voice an opinion or vote on it. It was one that was never submitted to management.

    I guess what I'm saying is, sure make a feature request for what's worth.

    Thank you for getting back to me.

    Best Regards, Robert.

    PS: No Response Required.