Forum Discussion
- LauraThackerQrew CaptainIf 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()
) - MMQrew Memberi 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... - LauraThackerQrew CaptainDan 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() - MMQrew Memberthis 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. - LauraThackerQrew CaptainThe 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.
- MMQrew Memberthis 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>
<!-- - MMQrew Memberhow 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. - LauraThackerQrew CaptainI 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.
- MMQrew Memberok, 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. - michaelaCorbettQrew MemberDoes 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.