Long time no update. I know, I know..
We’ve launched an opensource project to help you generate web forms for the live collection/insertion of data in any standard or custom Salesforce.com object.
Although Salesforce.com Sites will soon be in Developer Preview, we thought that some Salesforce.com customers could find it useful.
Check the project website for details at Google Code: http://code.google.com/p/sfdc-web2anything/
Many have asked me how to integrate Google Maps in a Salesforce.com page to pinpoint a specific address on the map. The example we’re going to see today is how to add an inline map to pinpoint an Account billing address.
Here’s a screenshot of what we are going to get:
Right so, let’s see what we need:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
<script src="http://maps.google.com/maps?file=api&v=2.x&key=YOUR-GOOGLE-MAPS-API-KEY-HERE" type="text/javascript"></script>
<script type="text/javascript">
var map = null;
var geocoder = null;
var address = "{!Account.BillingStreet}, {!Account.BillingPostalCode} {!Account.BillingCity}, {!Account.BillingState}, {!Account.BillingCountry}";
function initialize() {
if (GBrowserIsCompatible()) {
map = new GMap2(document.getElementById("map_canvas"));
map.addControl(new GSmallMapControl());
geocoder = new GClientGeocoder();
geocoder.getLatLng(
address,
function(point) {
if (!point) {
document.getElementById("map_canvas").innerHTML = address + " not found";
} else {
map.setCenter(point, 13);
var marker = new GMarker(point);
map.addOverlay(marker);
marker.bindInfoWindowHtml("{!Account.Name}");
}
}
);
}
}
</script>
</head>
<body onload="initialize()" onunload="GUnload()">
<div id="map_canvas" style="width:100%;height:300px"></div>
</body>
</html>
Navigate to one of your Account records and verify the map is displaying correctly!I’m not going to analyse the S-Control line by line, with a little knowledge of HTML and JavaScript you should be able to modify it to suit your needs, but please let me know if you have any issues.
I like Google, infact, I really love many of Google’s apps. There are many reasons to use Gmail – Google’s ‘new kind of webmail’ – and one of those is that it offers IMAP access. This is great for those of you who’ve been waiting to use the Salesforce’s Email2Case tool, and today I’m going to explain how to configure it to be used with Gmail.
Email2Case ‘is a toolkit that pulls emails from your mail server and uses the Force.com API to create new cases or append to an existing case‘. In order to get more information about the tool and download it, please navigate here (note you will need a free developer account to access the page, you can subscribe for one here).
<configFile> <server1> <url>imap.gmail.com</url> <protocol>imaps</protocol> <userName>username@gmail.com</userName> <password>gmail_password</password> <interval>1</interval> <inbox>Inbox</inbox> <readbox>Processed</readbox> <errorbox>Error</errorbox> </server1> </configFile>
<configFile> <sfdcLogin> <url>https://www.salesforce.com/services/Soap/u/9.0</url> <userName>salesforce_username_here</userName> <password>salesforce_password_here</password> <loginRefresh>30</loginRefresh> <timeout>5000</timeout> </sfdcLogin> <notify> <notifyEmail></notifyEmail> <from></from> <host>smtp.gmail.com</host> <port>465</port> <user></user> <password></password> <service>com.sforce.mail.SMTPNotification</service> </notify> <attachments> <largeAttachmentDirectory>C:\EmailAgent\LargeAttachments</largeAttachmentDirectory> <largeAttachmentURLPrefix>file:\\C:\EmailAgent\LargeAttachments</largeAttachmentURLPrefix> <largeAttachmentSize>1</largeAttachmentSize> </attachments> <services> <com.sforce.mail.EmailService>C:\\EmailAgent\\email2case.txt</com.sforce.mail.EmailService> </services> </configFile>
If you need further help setting up the Email2Case Agent, please refer to this Salesforce.com Help page.
Decoding Salesforce is back with a brand new look! We’ve been busy during the last few months, but we’ll find some time to write something new in this space. Let us know what you think about the new skin; stay tuned for more
Often people ask me how to get fields IDs in order to build their custom links. I thought it would have been helpful to write a post about this. Let’s see how to get a field ID for custom and standard fields.
In order to get the ID of a custom field proceed this way:
Easy enough, isnt’t it
Salesforce.com provides a list of the field’s name for its standard fields, which can be found attached to the solution “How do I create custom links?” and that I decided to paste here as a quick reference:
| EVENTS | Field Type | ID |
|---|---|---|
| Assigned To | ID | evt1_lkid |
| Text | evt1_lkold | |
| Subject | evt5 | |
| Who | Picklist | evt2_mlktp |
| ID | evt2_lkid | |
| Text | evt2 | |
| What | Picklist | evt3_mlktp |
| ID | evt3_lkid | |
| Text | evt3 | |
| Private | IsPrivate | |
| Activity Currency | evt9 | |
| Location | evt12 | |
| Date | evt4 | |
| Time | evt13 | |
| All Day Event | evt15 | |
| Type | evt10 | |
| Show Time As | ShowAs | |
| Description | evt6 | |
| TASKS | Field Type | ID |
| Assigned To | ID | tsk1_lkid |
| Text | tsk1 | |
| Subject | tsk5 | |
| Due Date | tsk4 | |
| Status | tsk4 | |
| Who | Picklist | tsk2_mlktp |
| ID | tsk2_lkid | |
| Text | tsk2 | |
| What | Picklist | tsk3_mlktp |
| ID | tsk3_lkid | |
| Text | tsk3 | |
| Comments | tsk6 | |
| Notify by Email | ||
| CAMPAIGNS | Field Type | ID |
| Campaign Name | cpn1 | |
| Type | cpn2 | |
| Status | cpn3 | |
| Start Date | cpn5 | |
| End Date | cpn6 | |
| Expected Revenue | cpn8 | |
| Budgeted Cost | cpn9 | |
| Actual Cost | cpn10 | |
| Expected Response % | cpn11 | |
| Campaign Currency | cpn7 | |
| Number Sent | cpn13 | |
| Active | cpn16 | |
| Description | cpn4 | |
| LEADS | Field Type | ID |
| Salutation | Picklist | name_salutationlea2 |
| First Name | name_firstlea2 | |
| Last Name | name_lastlea2 | |
| Company | lea3 | |
| Title | lea4 | |
| Lead Source | lea5 | |
| Industry | lea6 | |
| Annual Revenue | lea7 | |
| Campaign | ID | lea20_lkid |
| Text | lea20_lkold | |
| Description | lea17 | |
| Phone | lea8 | |
| Mobile | lea9 | |
| Fax | lea10 | |
| lea11 | ||
| Website | lea12 | |
| Lead Status | lea13 | |
| Rating | lea14 | |
| # of Employees | lea15 | |
| Email Opt Out | lea22 | |
| Street | lea16street | |
| City | lea16city | |
| State/Province | lea16state | |
| Zip/Postal Code | lea16zip | |
| Country | lea16country | |
| Use Assignment Rule | lea21 | |
| ACCOUNTS | Field Type | ID |
| Account Name | acc2 | |
| Account Site | acc23 | |
| Account Number | acc5 | |
| Type | acc6 | |
| Industry | acc7 | |
| Annual Revenue | acc8 | |
| Account Currency | acc24 | |
| Rating | acc9 | |
| Phone | acc10 | |
| Fax | acc11 | |
| Website | acc12 | |
| Ticker Symbol | acc13 | |
| Ownership | acc14 | |
| Employees | acc15 | |
| SIC Code | acc16 | |
| Billing Street | acc17street | |
| Billing City | acc17city | |
| Billing State/Province | acc17state | |
| Billing Zip/Postal Code | acc17zip | |
| Billing Country | acc17country | |
| Shipping Street | acc18street | |
| Shipping City | acc18city | |
| Shipping State/Province | acc18state | |
| Shipping Zip/Postal Code | acc18zip | |
| Shipping Country | acc18country | |
| Description | acc20 | |
| CONTACTS | Field Type | ID |
| Salutation | Picklist | name_saluatationcon2 |
| First Name | name_firstcon2 | |
| Last Name | name_lastcon2 | |
| Account | ID | con4_lkid |
| text | con4_lkold | |
| Title | con5 | |
| Department | con6 | |
| Birthdate | con7 | |
| Reports To | ID | con8_lkid |
| Text | con8_lkold | |
| Lead Source | con9 | |
| Contact Currency | con21 | |
| Phone | con10 | |
| Home Phone | con13 | |
| Mobile | con12 | |
| Other Phone | con14 | |
| Fax | con11 | |
| con15 | ||
| Assistant | con16 | |
| Asst. Phone | con17 | |
| Email Opt Out | con23 | |
| Mailing Street | con19street | |
| Mailing City | con19city | |
| Mailing State/Province | con19state | |
| Mailing Zip/Postal Code | con19zip | |
| Mailing Country | con19country | |
| Other Street | con18street | |
| Other City | con18city | |
| Other State/Province | con18state | |
| Other Zip/Postal Code | con18zip | |
| Other Country | con18country | |
| Description | con20 | |
| OPPORTUNITIES | Field Type | ID |
| Name | opp3 | |
| Account | ID | opp4_lkid |
| Text | opp4_lkold | |
| Type | opp5 | |
| Lead Source | opp6 | |
| Forecast Category | ForecastCategory | |
| Opportunity Currency | opp16 | |
| Amount | opp7 | |
| Close Date | opp9 | |
| Next Step | opp10 | |
| Stage | opp11 | |
| Probability | opp12 | |
| Campaign Source | ID | opp17_lkid |
| Text | opp17_lkold | |
| Description | opp14 | |
| CONTRACTS | Field Type | ID |
| Account | ID | ctrc7_lkid |
| Text | ctrc7_lkold | |
| Customer Signed By | ID | ctrc16_lkid |
| Text | ctrc_lkold | |
| Customer Signed Title | CustomerSignedTitle | |
| CustomerSignedTitle | ctrc6 | |
| Contract Currency | CurrencyIsoCode | |
| Price Book | ctrc17 | |
| Status | ctrc15 | |
| Contract Start Date | ctrc5 | |
| Contract Terms(months) | ctrc40 | |
| Owner Expiration Notice | ctrc13 | |
| Company Signed By | ID | CompanySigned_lkid |
| Text | CompanySigned_lkold | |
| Company Signed Date | CompanySignedDate | |
| Billing Street | ctrc25street | |
| Billing City | ctrc25city | |
| Billing State/Province | ctrc25state | |
| Billing Zip/Postal Code | ctrc25zip | |
| Billing Country | ctrc25country | |
| Special Terms | SpecialTerms | |
| Description | Description | |
| CASES | Field Type | ID |
| Contact | ID | cas3_lkid |
| Text | cas3_lkold | |
| Type | cas5 | |
| Case Reason | cas6 | |
| Case Currency | cas24 | |
| Status | cas7 | |
| Priority | cas8 | |
| Case Origin | cas11 | |
| Visible in Portal | cas27 | |
| Subject | cas14 | |
| Internal Comments | Cas15 | |
| Assignment Rules | cas21 | |
| Send notification to Contact | cas22 | |
| SOLUTIONS | Field Type | ID |
| Name | SolutionName | |
| Details | SolutionNote | |
| PRODUCTS | Field Type | ID |
| Name | Name | |
| Product Code | ProductCode | |
| Quantity Scheduling Enabled | CanUseQuantitySchedule | |
| Product Currency | CurrencyIsoCode | |
| Description | Description | |
| Active | IsActive | |
| Product Family | Family | |
| Revenue Scheduling Enabled | CanUseRevenueSchedule | |
| Quantity Schedule Type | pQST | |
| Quantity Installment Period | pQSI | |
| Number Of Quantity Installments | pQSN | |
| Revenue Schedule Type | pRST | |
| Revenue Installment Period | pRSI | |
| Number Of Revenue Installments | pRSN | |
| DOCUMENTS | Field Type | ID |
| Name | Name | |
| Internal Use Only | iuo | |
| Externally Available Image | pub | |
| Folder | pid | |
| Description | desc | |
| Keywords | key |
Questions? 
Sponsored Links