function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
certi_vimalcerti_vimal 

Google Map to show Address based on "Primary Address" picklist

Hi , 

 

I have a requirement where I want to show Address Location from "Google Map" custom link on an Account record BASED on following criteria :- 

 

- There is a custom picklist field "Primary Address" with values "Business, Home, Other"

- There are 3 sets of addresses : Business (Billing Address set of fields) , Home(Mailing Address set of fields) and Other (Custom Address set of fields)

- Now if "Primary Address" is "Business", when I click on "Google Map" custom link, it should show me only "Business" Address location. If the "Primary Address" is "Home", the custom link will show "Home" Address location and so on.

 

Please advise how can I achieve this?  

 

Thanks, 

 

Vimal

VarunSforceVarunSforce

Add custom LINK AS FOLLWING

 

IF(

                   ISPICKVAL(PrimaryAddresspicklist_field, 'Business'),

                   'http://maps.google.com/?q={!BusinessAddrField}',

                   IF(ISPICKVAL(PrimaryAddresspicklist_field, 'Home')),

                   'http://maps.google.com/?q={!BusinessAddrField}',

                    'http://maps.google.com/?q=?????'

)

     

You can fine tune this.
certi_vimalcerti_vimal

Thanks Varun.

 

I am still struggling with it.

 

I am trying to create a custom link with following code :-

 

IF(                   

ISPICKVAL({!Contact.Primary_Address__c}, 'Business'),

                 'http://maps.google.com/?q=" & OtherStreet & ",+" & OtherCity & "+" & OtherState & "+" & OtherPostalCode",                   IF(ISPICKVAL({!Contact.Primary_Address__c}, 'Home')),

                 'http://maps.google.com/?q=" & MailingStreet & ",+" & MailingCity & "+" & MailingState & "+" & MailingPostalCode" , )   

    )

 

I am getting the error that URL does not exist.

 

 

Thanks,

 

Vimal