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

    Separating the latitude and longitude values using map widgets

    Asked by minenight on March 02, 2015 at 02:40 AM

    Hi, I think Jotform is great - but with respect to map widgets, I can only find

    one wich gives me back a URL to Google Maps, although lat+long is included.

    I would like to get those two values separately, i.e. like 2 separate text fields.

    Is that possible?

     

    Thanks,

    Michael.

  • Profile Image
    JotForm Support

    Answered by Jan on March 02, 2015 at 09:44 AM

    Hi there,

    If I understand you correctly, you are using the Geolocation Map Widget and you want to get the information of the latitude and longitude right?

    Geolocation map widget will not show a separated value.

    However, the Address Map Locator will show that the latitude and longitude is separated.

    You can use the Address Map Locator Widget: http://widgets.jotform.com/widget/address_map_locator

     

    Hope this helps. Let us know if you need any help.

    Thank you.

  • Profile Image

    Answered by Burkhart on July 16, 2015 at 02:12 PM

    This does show it separated on the form itself, but when you export it to excel, it shows up in 1 column. Is there a way to make this go into separate columns when the info is exported out of JotForm?

     

    Thanks!

    B

  • Profile Image

    Answered by Ben on July 16, 2015 at 03:54 PM

    To do that Michael, you should use 2 different fields to capture the value, or to split the value once in Excel - for example, if you use GeoLocation widget, you could split the data by splitting it on comma and have it set to return latitude and longitude only.

    The same applies with the Address Map Locator widget - you will need to split the data up in the Excel.

    Now it would be possible to get latitude split to a new field, but it is not possible at this time to separate the longitude as well, using the tools / fields available on your jotform, but if you are embedding the jotform on your website, you could simply add a bit of code to it after grabbing the forms source code, that would make the split to several hidden textboxes, which would then cause the data to show separated in Excel as well.