You need to sign in to do that
Don't have an account?
phiberoptik
Has anyone created a formula for deciphering the Carrier based on a tracking number's format?
I currently have a Text field that accepts a tracking number for a shipment. My thought was that I could create a formula field that would look at the format of the tracking number and display the carrier's name. I am stuck in that I cannot use REGEX() for a formula field and I am not sure how to compare the format of the value in the text field to get the Carrier.
Has anyone found this solved elsewhere? I have not yet considered a workflow rule as I wanted to post this first.
Nevermind, I solved it myself and for your reference, my solution is below. If you see any reason why this might be flawed please let me know.
Tracking Number is a Text field.
Carrier is a Text field.
Created a workflow rule on the object these fields reside on.
Run Criteria: created and everytime its edited.
Evaluation Criteria:
Workflow Action: Field Update
Field to Update: Carrier
Use formula to specifiy new value: