You are using the "&" incorrectly. It's a text concatenation operator, not a logical operator. Can you describe this test in words?
A01__PKG__Packages::CourierIncoming & A01__PKG__Packages::Courieroutgoing = "Fedex"
Yes, that calculation looks “fishy”. If you mean that both courier fields should be identical, this is the wrong way to test it.
If you want to simplify our calc, use Let(), e.g. like so:
Let ( [
courierIn = A01__PKG__Packages::CourierIncoming ;
courierOut = A01__PKG__Packages::Courieroutgoing ;
courierIdentical = courierIn = courierOut ;
ref = A01__PKG__Packages::ReferenceOutgoing & A01__PKG__Packages::ReferenceIncoming
courierIn = "Fedex" and courierIdentical ;
"http://www.fedex.com/Tracking?" & "tracknumbers=" & ref ;
courierIn = "DHL" and courierIdentical ;
"http://www.dhl.com/en/express/tracking?" & "fasttrack&AWB=" & ref;
courierIn = "UPS" and courierIdentical ;
"HTMLVersion=5.0&Requester=UPSHome&error_carried=true&tracknums_displayed=5&TypeOfInquiryNumber=T&loc=en_US&InquiryNumber1=" & ref; "&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&AgreeToTermsAndConditions=yes&track.x=0&track.y=0";
etc. Don't forget to close the Let() …
Not all sites allow form input as URL parameter.
OTOH, I prefer using Let() function if you use same calculation many times in a formula.
Thanks for your responses.
The funny thing is that the formulas I am using are working the way I would like to . Let me explain what I am requesting them to do. I have 2 tabs one for incoming parcel & the other for outgoing. Then I have a tab with my webviewer that reflects the tracking status. I am asking FM that which ever tab I am on viewing details of a shipment whether incoming our outgoing when I go to the webviewer tab please show the status . Based on the courier : FedEx, DHL or UPS it will go to the correct webviewer. I will take note to use "Let function" for this. My problem is however I am trying to get this work for the following websites but having a problem ; please see websites I would like to get the same URL function for. If anyone can help me to find the right tracking formula for these sites that will be much appreciated:
Only if the site allow GET request, you can use it as URL like as you do in other sites.
The form is designed to be accessed by human, so it is better to search other way (API) for accessed by computer.