In column types like Address, LatLong, XY we can add an Optional Url for KML File.
It was disused many times, how we can host the KML file.
Now I found a method how you can use your Google My Maps File directly without the need to export it and to host the exported KML file.
The URL should look like this:https://www.google.com/maps/d/kml?mid=YOUR_MY_MAPS_ID
Don’t forget to set your Google My Maps File to “Anyone on the internet with this link can view”.
If you like to show only one layer of your Google My Maps File, you have to:
<href>
It’s the same URL as above, but includes the Layer ID (lid).
Now comes the next step.
A Network Link is like a Bookmark to a KML or a KMZ file.
The idea is: You can use a Parent KML file which will catch a Child KML file.
The result: You will always see the most actual KML file.
By using refreshMode, you can say how often the Child KML file should refresh, like every 30 seconds.
This is working perfectly in Google Earth. But it’s not working in AppSheet!
@Peter Could this be enabled in AppSheet?
Here is a Demo Video
https://www.loom.com/share/bb5f877f87df49cb98dfd50f783d3c39?sid=ce276ac4-cf69-4419-a062-d964fcc7ed87
Thank you for passing on your learnings~!
Yes, this is great! I’ve tested network KMLs and found the same issue. This would definitely be a useful update for when the team is able to revisit the KML functionality and maps in general - I’ll make sure it gets back for consideration.
Hi Peter,
Regarding the use of KML files and the impossibility of getting their most updated version (Appsheet does not refresh its copy even when the KML file is updated). Unfortunately, this makes it impossible to use “live” KMLs on AS. One very important, and I believe not so difficult solution to implement, would be to have a formula field in the “Optional Url for KML File” option in the column type details (instead of just a “hardcode” field). Doing that, we’ll be able to dynamically change the KML file name using a formula, and get its updated versions. PLEASE
Yes @Paulo_Negrao I agree. Having the ability to use an expression would open up a new KML world
Hi @Peter I saw, that after a day, the KML will be updated automatically, when using a Network Link.
Thanks, This video help me to solve my problem in a milk run that my drivers have to follow.
Perfect!!! thanks