- mgitterAsked on April 06, 2018 at 10:15 AM
Is it possible to have certain form fields not integrate with a Google spreadsheet? I have conditional logic set up on my form where if they check the box, dropdown selections appear below it. Everything is coming over correctly on the Google spreadsheet, but we don't really need to collect the checkbox data (whether they checked the box or not). We just want to collect the selection dropdown data that appears after they check the box. Is this possible?
It would help clean up the Google spreadsheet to only include the information we actually need.Page URL:
- JotForm SupportdavidAnswered on April 06, 2018 at 11:20 AM
The Google Docs spreadsheet integration needs all form fields to be included in the sheet to keep the structure of the sheet. If any columns are removed from the sheet, it will likely break the integration.
You could use the import range function to import your data to another sheet:
Then remove the unneeded columns from that sheet.
- mgitterAnswered on April 06, 2018 at 11:28 AM
OK, I will look into that. Thanks! Also, are all of the fields required to be shown on the autoresponder email as well? When I tried to remove the fields from the email that we didn't need to send to the customer, it seemed to "break" certain parts of the dynamic content.
- JotForm SupportdavidAnswered on April 06, 2018 at 11:29 AM
Fields are not required to be included in emails, however, hiding empty fields in the email only works properly with the default email template.
- mgitterAnswered on April 06, 2018 at 01:03 PM
These wouldn't be empty fields. The empty fields do hide correctly. I am talking about fields the customer filled out but don't necessarily need to see again in the autoresponder email. I tried to take those fields out of the email, but it seems making any changes to the autoresponder email breaks the dynamic content (even just editing the font and size broke the dynamic content). Examples below show everything working correctly in unedited version and then will not show up at all in edited version (even though I made no changes to that specific field):
- JotForm SupportdavidAnswered on April 06, 2018 at 01:27 PM
I am able to reproduce this on my end and am checking why this is occurring. I will update you as soon as I find a resolution.
- JotForm SupportdavidAnswered on April 06, 2018 at 01:48 PM
There does appear to be something odd with the configurable list widget when in emails when the table is modified. When it is not modified, everything comes through:
When I remove any data from the table, the configurable list no longer show in the email notification:
I will forward this to our developers to have a look. We will let you know as soon as we have any updates.