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

  • FCMG1996
    Asked on July 10, 2019 at 6: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

  • jherwin
    Replied on July 10, 2019 at 7: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.

  • FCMG1996
    Replied 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?
    ...
  • Nik_C
    Replied on July 11, 2019 at 1:17 PM

    Here is how you can do that:

    1562865400screencast Screenshot 10

    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!

  • FCMG1996
    Replied 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
    ...
  • jherwin
    Replied on July 12, 2019 at 1: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.

  • FCMG1996
    Replied 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
    ...
  • jherwin
    Replied 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/