What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    GeoLocate Lat Lon issue

    Asked by aidanmagee on May 27, 2015 at 02:30 PM

    Hi Guys, I'm using the neat widget Geolocation and it returns the Lat and Lon into 1 field in a google sheet, but I need to have the lat and lon in seperate fields, I was going to use a substring widget to try and seperate them but the Geolocate doesn;t have a proper ID output field.

     

    Any Suggestions

     

    Thanks

     

    Aidan

    Page URL:
    http://form.jotformeu.com/form/51456616202348?

    thanks and sheet in
  • Profile Image

    Answered by Sammy on May 27, 2015 at 04:15 PM

    Hello Aidan,

    You can accomplish the splitting by utilizing jtoform's conditions and substring widget.

    Hera are the steps you can take.

    1. Create a text box to hold the raw value of the latLong

    2. Create a form condition that will take the coordinates and populate them into the textbox above

    3. Create two substring widgets one will hold the Lat and the other the Long

    4. For the first substring set the following settings

    5. On the second substring

    I have included a copy of the form that you can clone and modify the settings,

    http://form.jotformpro.com/form/51466054431955

     

    Feel free to contact me in case of any issues or inquiries