Make Address Link Clickable in Table Report

Question

I have an address field (which really has Lat/Long coordinates), which is clickable to a google maps when viewing the record. However, in a table report it is not a hyperlink. How would I create a custom Rich Text hyperlink to open the google maps location, like it does when viewing the record?

------------------------------
Mike Tamoush
------------------------------

markshnier__you · Answer

Here is some help
https://developers.google.com/maps/documentation/urls/get-started
here is an example for a URL
https://www.google.com/maps/@?api=1&amp;map_action=map&amp;center="
&amp; URLEncode(List(",", [Latitude], [Longitude]))------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

miketamoush · Answer

Thanks Mark. That worked but I did have to add $query to the parameters.&nbsp;

"https://www.google.com/maps/search/?api=1&amp;map_action=map&amp;center=&amp;query="&amp; URLEncode(List(",", [Latitude], [Longitude]))------------------------------Mike Tamoush------------------------------

Forum Discussion

Make Address Link Clickable in Table Report