- CehAsked 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
- JotForm SupportjonathanAnswered 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.