When the template for an email notification is modified, configurable list widget data is no longer shown in the body of the email

  • Profile Image
    mgitter
    Asked 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.

  • Profile Image
    david
    Answered 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:

    https://support.google.com/docs/answer/3093340?hl=en

    Then remove the unneeded columns from that sheet.

  • Profile Image
    mgitter
    Answered 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.

  • Profile Image
    david
    Answered 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. 

  • Profile Image
    mgitter
    Answered 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):


    1523034111fullexample.jpg

    -------------------------------------------------------------------------

    1523034131editedexample.jpg

  • Profile Image
    david
    Answered 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.

  • Profile Image
    david
    Answered 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:

    1523036656Capture.PNG

    When I remove any data from the table, the configurable list no longer show in the email notification:

    1523036694Capture1.PNG

    1523036715Capture3.PNG


    I will forward this to our developers to have a look.  We will let you know as soon as we have any updates.