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
courtneybcourtneyb 

Google Search

Hello,

 

I am trying to create a simple Google search query from a custom object in Sforce.  I'd like it to pull from three fields on the same record.  

For example, School Name, City, State (site:greatschools.org KIPPAcademy, New York, NY).  

Does anyone know how to implement this code?  Do I need to create a new field on the object?

 

Thanks in advance,

Courtney

sinsiterrulezsinsiterrulez

you append these fields to your google query URL

E.g.

http://google.com?q={!SObject.Schoolname__c}+{!Sobject.City}+{!SObject.State}
Pradeep_NavatarPradeep_Navatar
Create Google Map URL with data typt URL(25) in custom object and use the following code : http://maps.google.com/?q={!SObject.Schoolname__c},{!Sobject.City},{!SObject.State} Hope this helps.
courtneybcourtneyb

Thanks for the replies.  I went ahead and created a new URL field on the custom object with the following formula:

 

http://google.com?q={!SObject.Current_School_Name__c}+{!Sobject.Current_School_City__c}+{!SObject.Current_School_State__c}

 

However, it is giving me a syntax error (Found '/').  I'm not sure what I might be doing wrong?

 

 
Pradeep_NavatarPradeep_Navatar

Try the following :

 

HYPERLINK("http://google.com?q=" &  BillingCountry &  BillingPostalCode &  BillingCity  ,'GOOGLE MAP URL');

 

As per the requirements, you can put the field name in the syntax.

 

Hope this helps.