Populate data to database from custom Custom google mymap polygons

[mr8]

Hey Community I have a tough one.

I have maps made using “Google My maps” they are just maps with Polygonal geo fences drawn on them. Each of said geofence has a Label.

2 things I want to be able to do.

1. (Goal) Automate recording which zone an address falls in, whenever used. This data of which zone will be updated in a spreadsheet.
2. (Bonus) Use said map as the view whenever maps are used in my related app(s)

I’ve made a test map that here https://drive.google.com/open?id=1cWUs71QI2Zg8HMURbVRTFADh-dJplBen&usp=sharing

3 zones split between 2 layers.

This is a challenge that I’ve had for some time now. And is my first important goal with starting my project in appsheet.

[Koichi_Tsuji]

I do have app where I generate the KML file on google my map and placed that file onto Appsheet.
See below, fyg.

For the moment, there is no function, expression nor feature available on Appsheet to do “intersect” the map location. What I mean is when we select single point of geocode, like cordinates or postal address, the appsheet have no idea if this single point is inside/outside the polygon the user separately generated.
On programming, it is possible to do kinda of true/false if the point is inside/outside the polygon.

But you could have workaround. Then you add the data to capture the location (address in your case), your row should have fields for the name of polygon.

And then you create another table, which is simple table as polygon master where you have ID and name of polygon + center point as latlong.

Basically my app is made in that way.

[Prasetyo_Mimbor]

tsuji_koichi:

For the moment, there is no function, expression nor feature available on Appsheet to do “intersect” the map location. What I mean is when we select single point of geocode, like cordinates or postal address, the appsheet have no idea if this single point is inside/outside the polygon the user separately generated.
On programming, it is possible to do kinda of true/false if the point is inside/outside the polygon.

But you could have workaround. Then you add the data to capture the location (address in your case), your row should have fields for the name of polygon.

And then you create another table, which is simple table as polygon master where you have ID and name of polygon + center point as latlong.

Basically my app is made in that way.

I really want this feature, displaying polygons on the map.
is there a tutorial?

[Koichi_Tsuji]

Host KML files on Google Drive Tips & Tricks 💡

If you want to use a KML map layer as described here you can host the kml file on Google Drive. Just right-click on it and choose SHARE. Then click on ADVANCED and copy the link. Paste this link here to get the Export Link: http://kolorobot.github.io/permalink/ Copy this Export Link and paste it in your column definition under “Optional Url for KML File”. The kml file does not to be public. It can be private. One thing I noticed: It will not work with https:// but only with http://

[Prasetyo_Mimbor]

nothing appear

[TyAlevizos]

hello, semi-related but a coworker recently posted a solution which may help you, @Malkio

Here is his post:

How to Dynamically Create Smart Areas/Boundaries on a Map Tips & Tricks 💡

Hi Everyone, I have created a sample app that demonstrates how app creators can create apps that lets users create dynamic boundaries or smart objects on an XY map. This app allows users to add new maps and define the scale of the map. They can then draw rectangular areas on the map by defining the top left corner and bottom right corners of the area. The colors of these areas can be changed as desired and the app will also calculate the measured area of the smart area by using the scale define…

[Nicolas_Feldman]

This is all very interesting, thank you!
Is there also a way to calculate if a pin falls inside or outside the uploaded tracks or boundaries of the uploaded .kml ? aka “Optional Url for KML File”.

Thanks!