Dear Users, happy time we are collecting Geo ...

(adil mansour) #1

Dear Users, happy time we are collecting Geo data (GPS points), we should have a live updated map (location visualization), meant, we we submit form, the points should directly go to the map (google map, GIS online, or google earth), is it possible with Appsheet, if yes, please instruct me? Note: if it is possible with google drive, it would most appreciated.

(Aleksi Alkio) #2

If I understood this correctly, yes it’s possible. You need two things… you need to create a form with LatLong column type. Then you need to create a map view for that data.

(adil mansour) #3

Thank you for your response, but the main issue is the Map, i want to have the map on my drive which could be shared online, then, when i add data (GPS points) via application, it should be added to that map automatically, when i create map view, where that map stored? is it possible to share that map with colleagues?

(Aleksi Alkio) #4

The map itself is not stored, only GPS points when you save the form.

(adil mansour) #5

yes that is the problem, i want to have a map, is there any other way to do this?

(Aleksi Alkio) #6

Maybe it would be possible with writing a script behind the gSheet.

(adil mansour) #7

yes that is right, and unfortunately i have not knowledge of script, script could do this with google fusion table, if any one could help me would be most appreciated.

(adil mansour) #8

thank you for your help, yes that is possible via script, and unfortunately i am not script writer and can’t write script, this is the problem that i can not do so.

(Praveen Seshadri (AppSheet)) #9

If it is a smallish number of points, you can probably use a spreadsheet formula to construct a Google Maps UTL from the points captured in your spreadsheet by AppSheet.

See https://developers.google.com/maps/documentation/static-maps/intro