Forum Discussion

  • 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()
    )
  • MM's avatar
    MM
    Qrew Member
    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...
  • MM's avatar
    MM
    Qrew Member
    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.
  • 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.
  • MM's avatar
    MM
    Qrew Member
    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>
    <!--
  • MM's avatar
    MM
    Qrew Member
    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.
  • 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.
  • MM's avatar
    MM
    Qrew Member
    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.