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
Chris ValkoChris Valko 

Formula Field With URL and APEX Code - Syntax Error

How can I get this to work, trying to create a URL within records to bring employees to a tracking page for shipments:

https://www.fedex.com/apps/fedextrack/?tracknumbers=LEFT(Auto_TrackingNum_Step1__c,find(' ',Auto_TrackingNum_Step1__c))

This doesnt seem to be working as I get a syntax error
Best Answer chosen by Chris Valko
UC InnovationUC Innovation
Hi Chris,

What is the error? If you're pasting that string into the formula then it will probably error out because you didn't surround your string in single quotes.

'https://www.fedex.com/apps/fedextrack/?tracknumbers=' + LEFT(Auto_TrackingNum_Step1__c,find(' ',Auto_TrackingNum_Step1__c))

Try pasting the above and see if it works.

All Answers

UC InnovationUC Innovation
Hi Chris,

What is the error? If you're pasting that string into the formula then it will probably error out because you didn't surround your string in single quotes.

'https://www.fedex.com/apps/fedextrack/?tracknumbers=' + LEFT(Auto_TrackingNum_Step1__c,find(' ',Auto_TrackingNum_Step1__c))

Try pasting the above and see if it works.
This was selected as the best answer
Chris ValkoChris Valko
Thanks, that worked!