Jump to content
Sign in to follow this  
Student Leadership Network

Url Script for looking up UPS Tracking Number

Recommended Posts

Newbie here trying to set up a database of orders that we ship out with UPS. I plan to import the tracking numbers into the database and then I want a button next to the tracking number that I can press to go to UPS's website and lookiup the tracking number without re-entering the tracking number.

The url I need to use is "http://wwwapps.ups.com/etracking/tracking.cgi?tracknums_displayed=5&TypeOfInquiryNumber=T&HTMLVersion=4.0&sort_by=status&InquiryNumber1=&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&track.x=24&track.y=9"

I need to somehow insert the tracking number that is in each field into the url above where it says (InquiryNumber1=TRACKINGNUMBER GOES HERE).

Anyone know how I can do this?

Share this post


Link to post
Share on other sites

Create a calculation field, the result would be the url with the field containing the tracking number inserted at the correct spot.

eg.

"http://www...etc" & TrackingNumberField & "RemainderOfUrl"

Share this post


Link to post
Share on other sites

Sorry, I am a newbie, what would the calculation be?

I have created the following calculation:

"http://wwwapps.ups.com/etracking/tracking.cgi?tracknums_displayed=5&TypeOfInquiryNumber=T&HTMLVersion=4.0&sort_by=status&InquiryNumber1="&"Tracking_Number"&"&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&track.x=24&track.y=9"

The end result is only: http://wwwapps.ups.com/etracking/tracking.cgi?

Share this post


Link to post
Share on other sites

Remove the quotes around Tracking_Number in your URL string (but keep the other quotes.) Since this is a field, it will be substituted into the string.

Share this post


Link to post
Share on other sites

Another suggestion, since tracking numbers show spaces, your users might try using spaces in the Tracking_Number field. With FM7, you can allow that but easily clean up the number so it will work correctly in a URL. Where you have Tracking_Number in your string, use this instead:

Filter(Tracking_Number;"0123456789")

Or if this number could be used in a relationship, then it would be better to remove the spaces automatically within the field itself. To do this, define Tracking_Number to have an Auto-entered calculation = Filter(Tracking_Number;"0123456789"), and uncheck the option to auto-enter only if the field is empty.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.