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
natinstorenatinstore 

UPS/FedEX Lookup

It is discussed in the 100 custom field guide... But everytime I type it in it gives me an error - has anyone been able to use it?
KaushikKaushik

Hi

The one given in the sheet doesn’t contain the actual URL.I guess it is just a pointer. Another difference is that, SFDC has changed the way a variable is referenced

Instead of {!tracking_id__c}  it is tracking_id__c.Always remember to put an & before the variable. If the URL  continues after the variable ,then add an & after the variable too.

I have given the exact formula which you could use. But have to create the tracking id and the Shipping Method Variables

CASE(  Shipping_Method__c ,
"Fedex",
HYPERLINK("http://www.fedex.com/Tracking?ascend_header=1&clienttype=dotcom&cntry_code=us&language=english&tracknumbers="&  tracking_id__c ,"Track"),
"UPS",
HYPERLINK("http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&loc=en_US&Requester=UPSHome&tracknum=" & tracking_id__c & "&AgreeToTermsAndConditions=yes", "Track") ,"DHL",HYPERLINK("http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber="
 &tracking_id__c ,"Track"),
"")

 

Hope this will help you out
WPCMSWPCMS
What would the USPS (United
States Postal Service) tracking URL be?