Make a form submit to a tab of an existing spreadsheet

  • Profile Image
    timgarrett
    Asked on June 24, 2012 at 08:25 PM

    Hi

    I have a pre- built spread sheet that i use to share some data with work colleages. on thsi spread shhet i have 3 tabs.

    is it possible to make a form to submitt to the 3rd tab on the spread sheet.

    Any help would be awesome.

    Kind regards

    Tim GArrett

  • Profile Image
    jeanettebmz
    Answered on June 25, 2012 at 12:49 AM

    I think a workaround could be the following: 

    1. Create a CSV Report in your form

    2. Insert the following syntax in any cell of your Google Docs Spreadsheet Tab:

    =ImportDATA("http://form.jotform.com/csv/report_id_here")

    Where http://form.jotform.com/csv/report_id_here is path to your CSV report.

    I did some tests and it took some minutes to update the sheet on my side

     

    Let us know if it worked for you

    Jeanette