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?

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"

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?

You're missing an &.

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.

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.

Where am I missing an &?