Here's a fairly detailed tip on adding a field link to a Google Map in GoldMine Enterprise Edition (AKA GMEE) that searches on a postcode:
Important Notes:
- Appropriate backups and testing in a development system should be carried out before applying to a live GMEE system
- You will require prior knowledge on adding fields to GMEE
Steps:
-Backup
-Open a new Definition Set in the Admin Module
-Select the Address.Mail Object
-Add a new text field to the Object
Name: GoogleMapPostcode
Type : Text
Length: 1000
-Place your field in the Address.Mail Panel. This will appear similar to the following
-Select... Definitions | Expressions
-Press ‘New’
-Select ‘Script’ and choose ‘Ok’
-Type the name: AddressGoogleMapPostcode
-Delete the pre-generated script and paste in the following code...
import System
import Fusion
import Fusion.Api
class FusionScriptWrapper implements IScriptWrapper
{
function FusionScriptWrapper()
{
}
function Process(currentBusinessObject : Fusion.Api.BusinessObject, currentField : Fusion.Api.Field) : Object
{
var objReturn : Object
var ZIP = new String(currentBusinessObject.GetField('Zip').NativeValue);
var DisplayText = new String()
ZIP=ZIP.replace( /\s/g, "" );
DisplayText = "http://maps.google.co.uk/maps?q="+ZIP
objReturn = DisplayText
return objReturn
}
}
-Your script should now appear like the image below
- Press OK to close the script window.
-On the left hand side of the screen located the Address.mail object. Expand fields and highlight the new field ‘GoogleMapPostcode’
-Right click and choose Edit Field, then select the advanced tab.
-Tick ‘The value in the field is calculated’ and select Named Expression and choose your new script
-Select Apply and Close
-You will now need to add the field to the Account Object Panel. Locate Account in the tree and highlight the Account(panel)
-The easiest way to add the new label is to copy an existing one. Highlight ‘City’ in the form right click and choose ‘Copy’
-Now right click and choose ‘Paste to place a copy of the city field
-Now right click on the new label and choose ‘Properties’
-Select the Behaviour Tab
-In Associated field name pick ‘Primary Address Link: Mail.GoogleMapPostcode’
-Tick ‘URL Support then Choose Close
-Check you have placed a text box for the new control. Then commit the edit set
