I've added a custom Geolocation field to Opportunity records and would like to add a detail page link to the same records taking the user to a google maps view for that geolocation.
When in the Custom Button or Link Edit screen the custom field I have created is not showing in the 'Insert Merge Field' for Opportunity so the syntax is failing. However the field is showing on opportunity records as expected.
Any ideas how I could get this field to show so I can create a successful link to a google maps search?
Any help would be greatly appreciated.
Thanks,
Dean
Hi- I don't know why geo fields aren't available in custom links, I see the same thing. Some limitation. But! Tt works if you make 2 Text formulas that display the lat and long values as Text fields and use *those* in the Button. You might even be able to have just one text formula that concatenates the lat/long in a format your google URL needs, but I haven't tested that.
Button formula would look something like this (that's not a full google formula w/ zoom level, etc, just a test):
http://maps.google.com/?ie=UTF8&hq=≪= + {!Opportunity.LatText__c} + "," +{!Opportunity.LongText__c}
(I tested making a text formula that was the whole google URL and having the button call that. It's making the formula correctly, but it won't open w/ a button correctly--puts the google URL after the salesforce URL. There may be a tweak there to do, but I didn't play much. The above lat/long as text worked for me)