What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Make a form submit to a tab of an existing spreadsheet

    Asked by timgarrett 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

    Answered by jeanettebmz 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