Incorporating Google Sheets

  • ASMFORMS
    Asked on December 13, 2016 at 12:06 PM

    Hello - Is there a way to use a form to populate fields on a google spread sheet? additionally - multiple tabs??

     

    I am trying to make my outside guys able to populate their spreadsheet as they visit accounts.

     

    Please let me know what the most efficient way to accomplish this or even to communicate further what I am trying to do...we have the free account at the moment but are very willing to Pay,

     

     

    Please reply - thank you!!!

    Paul

    Jotform Thread 1010334 Screenshot
  • BJoanna
    Replied on December 13, 2016 at 1:41 PM

    You can integrate your form with Google Spreadsheet. Inside of this guide you can find how to do it: 

    https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet 

    However I am not exactly sure what you are trying to achieve. If I understood you correctly you want that each submission is sent to new sheet (tab). Unfortunately that is not possible. All submitted data will be sent to same Sheet. 

    Incorporating Google Sheets Image 1 Screenshot 20

    You can edit your spreadsheet, but please note that editing of spreadsheet can sometimes break integration. 

    If you want that each submission is sent to new sub-folder you can integrate your form with Google Drive. 

    You can also download your submissions from submission page of your form: 

    https://www.jotform.com/help/73-How-to-Download-Form-Submissions-as-Excel-CSV-PDF 

    Hope this will help. Let us know if you need further assistance. 

  • ASMFORMS
    Replied on December 13, 2016 at 3:00 PM

    Thank you  - I will study up - I think it will work if to a single page. I appreciate the prompt reply!

  • BJoanna
    Replied on December 13, 2016 at 4:10 PM

    You're welcome.

    Feel free to contact us if you have any other questions.