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

    Is it possible to choose which fields are integrated into google sheets

    Asked by Ceh on May 20, 2017 at 06:45 PM

    Is it possible to choose which fields are integrated into google sheets? Basically my form will have around 500 fields and when mapped to google sheets the submissions will quickly eat up their 2 million cell quota.

    This is a re-post of a comment on How to Integrate Form with Google Spreadsheet

  • Profile Image
    JotForm Support

    Answered by jonathan on May 21, 2017 at 12:28 AM

    Currently it is not possible to do within the google spreadsheet integration configuration. 

    The integration is configured by default to carry all the form fields into the Google spreadsheet submission sheet.

    If you need to filter the form field's data that will be available in the google spreadsheet, you will have to do it in the Google spreadsheet application instead.

    You can use a separate Sheet and use the Import Range function of google docs to import the selected fields data(column in the Sheet) to the new Sheet.

    Let us know if you need further assistance.