How to use Zee Map service to make map in JotForm

  • claybj
    Asked on December 1, 2014 at 6: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.

     

  • Charlie
    Replied on December 1, 2014 at 9: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.

    How to use Zee Map service to make map in JotForm Image 1 Screenshot 20

     

    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.

  • claybj
    Replied on December 1, 2014 at 9: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
    ...