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

    How to use Zee Map service to make map in JotForm

    Asked by claybj on December 01, 2014 at 06:55 PM

    Sorry.. It's ZEE Maps that needs two fields.  But Zee is the only service that automatically updates the Map from a Google Sheet.

    Here's what I'm doing:

     

    1.  Collect data via Jotform.

    2.  Post data to Google Sheet.

    3.  Use Zee to grab data and make map.

     

    Seems easy enough but it's not.  Zee wants two fields for Lat and Long.  Google's on map engine doesn't automatically update from their own sheets.

     

    zee map google spreadsheet
  • Profile Image
    JotForm Support

    Answered by Charlie on December 01, 2014 at 09:15 PM

    Hi,

    I'm not sure if I understood your concern correctly. Currently, I believe we do not have an integration to Zee Maps, although I see that the Google Spreadsheet can be integrated on it? Is that correct?

    I cloned your form for testing purposes. When I made a submission, the entries will take a couple of minutes before it will show in the Google Spreadsheet.

     

    What you can do is add separate columns for Lat and Lang, to extract the data from column "Geolocation" and separate them, I believe the SPLIT function of Google Spreadsheet would work, you can find more here: https://support.google.com/docs/answer/3094136

     

    I hope this helps or at least gives you an idea on how to proceed. Let us know if you need further assistance on this.

    Thank you.

  • Profile Image

    Answered by claybj on December 01, 2014 at 09:21 PM
    Charlie,
    Thanks for the response. I'm working on this now. I'll continue and let
    you know how it works out.
    The goal is for the maps to auto-update when a user completes a jotform.
    Google doesn't allow that w/ their new fusion product. I'm waiting to hear
    back from Zee currently. They have a "Location Code" which is supposed to
    be Lat,Long in the same field (due to Google's geocoding legal
    requirements)... but it's not working as they state.
    Seems like this would be easy.
    1. Create jotform w/ Jotform Geospatial widget
    2. Insert into Google Sheet.
    3. Use Zee or GMap for plotting AND for updating when Jotform posts new
    data.
    It's not.
    As I said. I'll update you once Zee gets back to me.
    - clay
    ...