I have a KML file in my app and I've read from different AI sources that yes you can & no you can not DIRECTLY EDIT existing MyMaps Data in appsheet.
So I'm reaching out to actual humans who may have knowledge on which of them is true?
I'd love to be able to directly edit the contents and keep building it in appsheet that way if its possible.
Thank you for your responses.
Solved! Go to Solution.
I found a solution.
For anyone who may need a similar solution.
1. Download Google My Maps as KML
2. Use a KML>CSV converter(just convert the KML to a CSV however you know how)
3. Upload into existing spreadsheet used in app.
4. Create a formula to put the X & Y into one coordinate in a separate column, once created, may have to copy & paste special values only.
5. Upload to appsheet & create your view(Note: Make sure the column with the combined LatLong is set as LatLong Type)
6. Should see your map pings, I had to play around with my Key for them to appear.
Probably simpler ways to do this but it worked for me.
I found a solution.
For anyone who may need a similar solution.
1. Download Google My Maps as KML
2. Use a KML>CSV converter(just convert the KML to a CSV however you know how)
3. Upload into existing spreadsheet used in app.
4. Create a formula to put the X & Y into one coordinate in a separate column, once created, may have to copy & paste special values only.
5. Upload to appsheet & create your view(Note: Make sure the column with the combined LatLong is set as LatLong Type)
6. Should see your map pings, I had to play around with my Key for them to appear.
Probably simpler ways to do this but it worked for me.
User | Count |
---|---|
18 | |
11 | |
7 | |
3 | |
2 |