Skip to main content
Question

Track a shipment using URL formula for - Pegasus, CEVA, OMNI, and others

  • August 7, 2013
  • 0 replies
  • 110 views

i have the formula for Fed Ex, UPS, DHL... but i was wondering if something extra needs to be done to get the following into the "Track It" button

Pegasus:
http://www.plg.cc/tracking.asp

OMNI:
http://www.omnilogistics.com/tracking.html

CEVA:
http://www.cevalogistics.com/EN-US/TOOLSRESOURCES/Pages/CEVATrak.aspx

This topic has been closed for replies.

Forum|alt.badge.img+12
  • Registered
  • August 7, 2013
If you go to those website's pages and type in an actual trackable number and then copy the URL you can embed this into QuickBase, and subsitute the values with URLEncode ([field name]), which should work.

Here's some I've built in the past for FedEx and UPS.

Case([Shipping Source],
"Fed-Ex","https://www.fedex.com/fedextrack/?cntry_code=us&tab=1&clienttype=wtrk&tracknums="&URLEncode(),
"UPS","http://wwwapps.ups.com/WebTracking/track?loc=en_US&utm_campaign=website&utm_source=sendgrid.com&utm_medium=email&trackNums="&URLEncode()
)

  • Author
  • Registered
  • August 7, 2013
i followed the above and entered the "search by" as HAWB Number, and "NUMBER" as 5836271 and i got the tracking information, but the URL only shows this:
http://www.shiptrax.com/sneak/public/custom_quicktrax.asp?A=OMNILOGISTICS

so i can't copy & paste it into my URL formula and substitue "&URLEncode(blahblahblahfieldname]),

i looked at the source code of the tracking page and discovered that the the name of the "Search By" field is called cboSearchBy so i tried adding it to the URL formula like this:

"http://www.shiptrax.com/sneak/public/custom_quicktrax.asp?cboSearchBy=HAWB";,

just to see if i could get the correct option selected...

Forum|alt.badge.img+12
  • Registered
  • August 7, 2013
Dan Diebolt may be able to provide you with a free or paid solution to this; but in the meantime you can post the link to the site as you have it already.

For CEVA, you should be able to build it this way:

"http://www.cevalogistics.com/EN-US/toolsresources/Pages/CEVATrak.aspx?sv=" & URLEncode()

  • Author
  • Registered
  • August 7, 2013
this works great for CEVA, thank you.

I guess i'm getting stuck trying to populate the "Search By", "Customer Code:", and "Number:" on the OMNI site. I think the problem is that i don't know what the fields are called on the OMNI site...or how to figure out how to determine them.

Forum|alt.badge.img+12
  • Registered
  • August 7, 2013
The problem is they are using custom code for you to enter.  You should try reaching out to Dan Diebolt (dandiebolt@yahoo.com); as he may have a solution that will allow you to bypass their aspx code to generate the results page you want.

  • Author
  • Registered
  • August 12, 2013
this is the source code from the OMNI Logistics tracking page:




<td class=clsNormtext width="22%">Search By:</td>
<td class=clsNormtext>

<select name="cboSearchBy" id="cboSearchBy" size="1" onchange="Set_CompanyCode()">
<option value="Tracking" >Tracking Number</option>
<option value="HAWB" >HAWB Number</option>
<option value="ShipperRef" >Shipper Reference #</option>
<option value="ConsigneeRef" >Consignee Reference #</option>
<option value="ThirdPartyRef" >Third Party Reference #</option>
</select>
</td>
</tr>
</table>



<div id="CompanyCode" style="display:none">


<table border=0 class=clsNormtext width="100%">
<tr>
<td class=clsNormtext width="22%">Company Code:</td>
<td class=clsNormtext><input type=text name=txtConsumerCode size=24 value=""></td>
</tr>
</table>
</div>

<table border=0 class=clsNormtext width="100%">
<tr>
<td class=clsNormtext width="22%">Number:</td>
<td class=clsNormtext><input type=text name=txtTrackingNumber size=24 id=txtTrackingNumber value=""></td>
</tr>
<tr>
<td></td>
<td class=clsNormtext><input type=submit value="Track Shipment" class=clsButton></td>
</tr>
</table>
</form>
<!--

  • Author
  • Registered
  • September 17, 2013
how do i get multiple tracking numbers into the UPS tracking formula? i've tried adding the line break ("\n") but the UPS tracking comes back with an error message when i use the formula in the quickbase userguide.

when i use your UPS formula above the tracking numbers get entered on multiple lines, but it doesn't actually "track" i still have to click the "track" button on the UPS website.

Forum|alt.badge.img+12
  • Registered
  • September 17, 2013
I haven't tried it, but usually you can enter multiple tracking numbers separated by a comma, so if you had multiple tracking numbes in a single record you could concatenate them with commas between them in a formula field.  However, if your tracking numbers are stored separately in single records you wouldn't be able to launch the button natively to pull from multiple records because the data would be stored across multiple records.

  • Author
  • Registered
  • September 23, 2013
ok, so i figured it out, and it was pretty simple once i figured out how to figure it out haha.

i went to OMNI's home page and tried to track a package without entering a HAWB number. i was brought to the main search page and i clicked "View Source" from the right-click menu. then i searched through the source code for the fields that need to be populated and entered them into the browser with different characters to try to make multiple fields populate with data.

finally, i realized that i needed to add the & symbol between the search parameter in the web browser and WHAMMO!

"http://www.shiptrax.com/sneak/public/custom_quicktrax.asp?HAWB="&[QBfieldforHAWB]&"&ConsumerCode=OMN..."

just took me a while to figure out what to do with this part:
"http://www.shiptrax.com/sneak/public/custom_quicktrax.asp?A=OMNILOGISTICS"
since i don't know anything about programming i wasn't really sure what the whole .asp?A was supposed to represent.

Does anyone know a URL for Pegasus besides "http://partners.pegasuslogistics.com/Tracking/TrackingWithoutLogin" We need the tracking number in the URL so we can use something similar to the "track It" button on our site.