I am working for a charity night now, they are using a smartsheet to store their data. The data contains information of address, what they want is to show points of these data on a map in smartsheet. I can easily convert the data into points using Google Map/Earth to extract the long and lat. However, I am using the basic license that does not support the web content widget. I could also make a html page with all these points showing on the map. This is not the optimal result that I want as the charitys want to integrate the map into Smartsheet, and use smartsheet to have the following functionalities: - when click on the zip code, there is a pop up window showing the area - when click on the data point, a window of point located map show pop up
To what I understand, this is not possible with my basic license. And python smartsheet API does not do these (if I can't import map into Smartsheet by logging in, then I can't do this using python either). What I can think of right now to solve the problem is to make a html page and import the link to smartsheet through web content widget.
I wonder if anyone has done something similar with Smartsheet or any suggestions? I think ultimately, no matter what I make (a html, a web application) I would have to integrate it back to smartsheet.
I am still trying to learn what smartsheet can do and am doing tutorials of python API as well as learning so Google Map API for the html page. any feedback would help.
Regards
You won't be able to build functionality into Smartsheet itself. But, if you can use the data in the sheet with data from the Google Maps API to create a URL of the location you can add that URL as an attachment to a row in the sheet. Then someone can click that link to go to the page and see the data in Google Maps. You can also add a hyperlink to the a cell via the API which could be put into the cell with the zip code by your application. Your application could create views of HTML with URLs for each of them and as someone visits them it shows them the data based on what is in the sheet.