Strip address field sub-headers in Google Drive folder name

  • amherst_building
    Asked on June 17, 2020 at 7:55 PM

    When I use the google drive integration and set the folder name to be address it adds subtitles.  How do I clean this up?

    Jotform Thread 2396066 Screenshot
  • Mike_G JotForm Support
    Replied on June 17, 2020 at 10:38 PM

    Since the option to strip address field values is not applicable in the Google Drive integration settings.

    How-to-Strip-Headers-from-Postal-Addresses-in-Email-Alerts

    A workaround that I would suggest is to pass the value of the address field in your form to a hidden Short Text field first using conditions

    How-to-Insert-Text-or-Mathematical-Calculation-into-a-field-using-a-Condition

    1592447802zt200617 223436 Screenshot 10

    and use that field as the folder in the Google Drive integration instead.

    1592447854zt200617 223722 Screenshot 21

    Result:

    1592447814zt200617 223552 Screenshot 32

    Feel free to let us know if you need any further assistance.

  • amherst_building
    Replied on June 18, 2020 at 3:08 AM

    THANKS!!!!!!