How to get latitude and longitude?

  • Profile Image
    querycity00
    Asked on May 29, 2020 at 03:26 AM

    i have 2 fields hidden in my form and i want to add FORMULAs to save in my spreadsheet!

     

    the formulas i want to use are:

    =LEFT(B:B,FIND(",",B:B)-1)

    and =RIGHT(B:B,FIND(",",B:B)-1)

    but in my spreadsheet it saves

    '=LEFT(B:B,FIND(",",B:B)-1)

    '=RIGHT(B:B,FIND(",",B:B)-1)

    add a ' that i don't want!

     is it possible to remove them?

     

    Otherwise is it possible in anyway to split the values of the widget "Ubicazione GPS":Collect accurate GPS locations through your form in 2 values of the spreadsheet? 1 for lat and 1 for long?

    i tryed to use the substring widget but i am not able to find the id of the locationgps that contain lat,lon 

     

  • Profile Image
    Bojan_J
    Answered on May 29, 2020 at 06:30 AM

    Greetings and thank you for your message.

    Unfortunately, it is not possible to remove the apostrophe when data is sent.

    If you need to extract the latitude and longitude, you can use the Geolocation widget which will retrieve this information.

    Please let us know if you have any additional questions.