- claybjAsked 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.
- CharlieAnswered on December 01, 2014 at 09:15 PM
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.
- claybjAnswered on December 01, 2014 at 09:21 PMCharlie,
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
As I said. I'll update you once Zee gets back to me.