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

    Does hiding a column in a Google Spreadsheet break the integration?

    Asked by cumis on June 12, 2013 at 07:20 PM

    I'd like to produce a spreadsheet with only parts of the information listed on the form.  This way I can have one less bulky spreadsheet with just contact/essential information.  The rest of the information is better viewed for my process in the PDF file that is synced to my Google Drive.  I've tried hiding columns in the spreadsheet, but it seems to break the integration and new entries no longer automatically populate the spreadsheet (though their PDF submission comes through to Google docs).  Any remedy or workaround for this?

     

    Thanks for the help!

    Page URL:
    http://www.jotform.com//?formID=31405131222132

    workaround pdf file thanks PDF submission
  • Profile Image
    JotForm Support

    Answered by EltonCris on June 12, 2013 at 10:05 PM

    Hi there,

    Instead of modifying the main sheet, I would suggest to create a subsheet instead and get all the desired data from the main sheet by using excel formula. Example, you can use the following formula.

    =Submissions!A1

    This formula copies all the data under Column A to the subsheet. If you'd like to copy Column B, simply change the "A" in it.



    Hope this helps. Thanks!