If you are using the FedEx Ship Manager, you probably love it as much as we at Cyrious do. The time savings are fantastic! We found that we wanted to enable the ability for the user to click on a link on the pricing form and jump to the FedEx page for the status. This article describes how to set that up.

Note #1: This does require modifying the pricing forms, which is only available in the Customizable version of Control or by paying an implementor to do this for you.

Note #2: If you use the UPS Worldship, a similar process should be achievable. You could even modify this to link wherever appropriate … perhaps in another WIKI.

The basics are very easy: Add a URL label to the pricing forma and have it display the results of a formula that computes the URL for that tracked item.

  1. Add the link to the pricing form.
    • Create a sample estimate of the product.
    • Right click on the line item, choose Line Item Options | View Pricing Form. If you don't have this option, then you are not running Control Customizable and will have to talk with an Implementor to do this for you (for a time-based fee).
    • With the pricing form open, click Edit.
    • Add a regular label and set the Caption to “Fed-Ex Link:”
    • Add a URL Label and set the DisplayedInfo to “pmdFormula”
    • Click on the ellipses in the DisplayFormula property and enter the formula below.
    • Change the AutoSize to “False” and size the URL lable to the size you want.
    • Save the Pricing Form.
  2. Test it.
    • Edit the sample estimate.
    • Fill in a tracking number in the “FedEx Tracking Number” UDF.
    • Open the line with the modified pricing form. You should see the link.
    • Click the link and confirm that the status on the entered tracking number is displayed.

The URL formula for FedEx is quite simple“

code_formatpascal|code format="pascal"

IF Len(TransactionUDF(“FedEx Tracking Number”)) > 2 THEN

"http://www.fedex.com/Tracking?tracknumbers="+TransactionUDF("FedEx Tracking Number")

ELSE

""

ENDIF

===== UPS URL Formula =====
The URL formula for URL is also simple"
[[code_formatpascal|code_formatpascal|code format="pascal"]]



IF Len(TransactionUDF("FedEx Tracking Number")) > 2 THEN



  "http://wwwapps.ups.com/WebTracking/processInputRequest?InquiryNumber1="+TransactionUDF("FedEx Tracking Number")



ELSE



  ""



ENDIF



<code>
**__UPS ALTERNATIVE HTTP FORMULA__**
If the formula above for accessing a UPS link directly from the Pricing Form does not work, try the formula below. Note that the UDF name for the Tracking Number may be different in different Control installations; so you need to be sure you have substituted your installation's actual Tracking Number name. This code is for a single tracking number.

IF Len(TransactionUDF(“UPS Tracking Number”)) > 2 THEN

http://wwwapps.ups.com/etracking/tracking.cgi?tracknum=

+TransactionUDF(“UPS Tracking Number”)

+”&accept_UPS_license_agreement=yes&nonUPS_title=QuickBase%20Package%20Tracking%20System“

ELSE

""

ENDIF

<code>

Contributor: who, company (optional) Date: _ _/_ _/2009 Version: Control 4._

You could leave a comment if you were logged in.