Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

UPS-FEDEX Tracking Number - clickable

 I have a table that contains shipment records.  It contains a UPS or Fedex tracking number.  I know that field can launch a URL but in my case I need to concatenate the tracking ID with URL:

 

The field contains: 1ZRV22390344023950

 

And the URL for UPS would be: 

 

http://wwwapps.ups.com/WebTracking/track?track=yes&trackNums=1ZRV22390344023950

 

Any help is appreciated.

  • Anonymous - You should be able to create a new column like this:

     

    New Column = "http://wwwapps.ups.com/WebTracking/track?track=yes&trackNums=" & [Column]

     

    Here [Column] is the name of the column that has your tracking id in it.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Anonymous - You should be able to create a new column like this:

     

    New Column = "http://wwwapps.ups.com/WebTracking/track?track=yes&trackNums=" & [Column]

     

    Here [Column] is the name of the column that has your tracking id in it.