Incorporating Google Sheets

  • Profile Image
    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

  • Profile Image
    BJoanna
    Answered on December 13, 2016 at 01: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. 

    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. 

  • Profile Image
    ASMFORMS
    Answered on December 13, 2016 at 03:00 PM

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

  • Profile Image
    BJoanna
    Answered on December 13, 2016 at 04:10 PM

    You're welcome.

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