Why the address field is sending hidden fields along with visible fields to Google spreadsheet?

  • Profile Image
    mcculloughr
    Asked on August 16, 2018 at 10:49 PM

    I created a form and added the Form Element "Address".  Under the Address Properties> Options I selected "Street Address" and "City".  How do I stop Street Address 2, State, Postal/Zip Code, and Country from coming through the Google integration and inserting columns into my submission spreadsheet that I don't want or need?  I know I can hide the columns, but I would prefer to remove them all together since the submission spreadsheet is shared with several other people.  Its confusing where there are numerous columns hidden.

    Thank you!

  • Profile Image
    Kiran
    Answered on August 17, 2018 at 03:56 AM

    I have checked the Google integration with an address field and was able to replicate the issue. However, as I check the form, it seems that the unchecked fields are hidden from the form with CSS and so, all the field IDs are actually sent to to the integrated application.

    153449237617082018_130814.png

    At the moment, the only workaround is to hide the columns on the integrated spreadsheet without making any changes to any of the headers. If you want we can send a feature request to our backend team for evaluation. However, we cannot guarantee that it shall be implemented or any ETA for implementation if accepted. 

    Let us know if you need any further assistance. We will be happy to assist.