Address Field IDs are a marvelous feature and work perfectly for me in

  • Profile Image
    FCMG1996
    Asked on July 10, 2019 at 06:15 PM

    Address Field IDs are a marvelous feature and work perfectly for me in a Text Field.

     

    I'm having trouble, however, with Address Field IDs in the Location field of JotForm's Google Calendar Integration (JGCI) at https://form.jotform.com/91900673684161. When Location field = {address} in JGCI, Google Calendar's "Location or Conferencing" field results in this ...

     

    : Mayflower Public Library, Ashmore Street, Mayflower, AR, USAStreet Address: Mayflower Public Library, 6 Ashmore StCity: MayflowerState / Province: ArkansasPostal / Zip Code: 72106Country: United States

     

    Note the three problems in the JGCI output above:

     

    1) an extra ": " preceding the address

    2) field names mixed in with values

    3) complex address with duplicated values

     

    Ideally I'd like JGCI to match Google Calendar's autocomplete address format. Here's Google Calendar's autocomplete address format for the location above ...

     

    Mayflower Public Library, 6 Ashmore St, Mayflower, AR 72106, USA

     

    I've been unsuccessful in using Field IDs - {address:addr_line1}, {address:city}, {address:state} {address:postal}, {address:country} - in Form Calculation field, Substring widget, Conditional Update/Calculate Field or Location field of JGCI.

     

    Can someone please help me troubleshoot these Address problems?

     

    Thanks!

     

    Dawn



    This is a re-post of a comment on How to Strip Headers from Postal Addresses in Email Alerts

  • Profile Image
    jherwin
    Answered on July 10, 2019 at 07:53 PM

    How about transferring the data/value of the address field to the textbox? You can then use substring widget to stripped the value and combine it like the way you prefer using the form calculation widget.

    Please give it a try and let us know if that works.

  • Profile Image
    FCMG1996
    Answered on July 11, 2019 at 11:43 AM
    Thanks for the suggestion. I'm unable to find the Text field name or ID to
    give the Substring widget. Thoughts?
    ...
  • Profile Image
    Nik_C
    Answered on July 11, 2019 at 01:17 PM

    Here is how you can do that:

    1562865400screencast.gif

    Related guide: https://www.jotform.com/help/146-How-to-Find-Field-IDs-and-Names

    Let us know if you have any further questions.

    Thank you!

  • Profile Image
    FCMG1996
    Answered on July 11, 2019 at 11:43 PM
    Nik, the suggestion was for me to use a Text field with the Substring widget. Text fields don't appear to have field naames or IDs.Dawn
    ...
  • Profile Image
    jherwin
    Answered on July 12, 2019 at 01:14 AM

    Sorry, but I realized that stripping values ​​in the address field ​​will not work because the number of characters in the address field is not fixed. Unfortunately, there is no workaround to organize the value of the address field the way you want at the moment.

    If you like, we can make a feature request with your requirements. However, we cannot guarantee that the feature will be implemented or cannot provide any time frame for implementation.

  • Profile Image
    FCMG1996
    Answered on July 12, 2019 at 10:43 AM
    Thanks everyone for your help. Two of my {address} field problems were solved at https://www.jotform.com/answers/1886393-How-to-strip-headers-of-the-address-field-when-sent-to-Google-Calendar.The third problem of duplicate values has been moved to a new thread at https://www.jotform.com/answers/1888142-Address-Properties-gt-gt-Autocomplete-the-values-are-being-duplicated-Dawn
    ...
  • Profile Image
    jherwin
    Answered on July 12, 2019 at 10:53 AM

    Great! If you need more help please do not hesitate to open a new thread/ticket here: https://www.jotform.com/contact/