How to use Zee Map service to make map in JotForm

  • Profile Image
    claybj
    Asked 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.

     

  • Profile Image
    Charlie
    Answered 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
    claybj
    Answered 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
    ...