Skip to main content
Question

URL Encode question

  • September 9, 2017
  • 0 replies
  • 57 views
I try creat one button to connect with some website to tracking shipping
http://elines.coscoshipping.com/NewEBWeb/public/cargoTracking/cargoTracking.xhtml?CARGO_TRACKING_NUMBER_TYPE=BILLOFLADING&CARGO_TRACKING_NUMBER=&REDIRECT=1&uid=

But the i need Encode the number atter "CARGO TRACKING NUMBER=" IT'S IN THE MIDDLE of the web, how can i  creat one FORMULA URL to do it ?
    This topic has been closed for replies.

    Try this
    "http://elines.coscoshipping.com/NewEBWeb/public/cargoTracking/cargoTracking.xhtml?CARGO_TRACKING_NUMBER_TYPE=BILLOFLADING&CARGO_TRACKING_NUMBER=" & URLEncode("REDIRECT=1&uid=" & [your tracking number field])
    • Liangxie
    • Author
    • Quickbase Alumni
    • September 9, 2017
    has problem, the website will be :
    http://elines.coscoshipping.com/NewEBWeb/public/cargoTracking/cargoTracking.xhtml?CARGO_TRACKING_NUMBER_TYPE=BILLOFLADING&CARGO_TRACKING_NUMBER=REDIRECT%3D1%26uid%3D6157691370
    • Liangxie
    • Author
    • Quickbase Alumni
    • September 9, 2017
    The number did not encode the right place
    Try this
    "http://elines.coscoshipping.com/NewEBWeb/public/cargoTracking/cargoTracking.xhtml?CARGO_TRACKING_NUMBER_TYPE=BILLOFLADING&CARGO_TRACKING_NUMBER=" & [your tracking number field]
    • Liangxie
    • Author
    • Quickbase Alumni
    • September 9, 2017
    without last "REDIECT=1&UID="  The website does not show it correctly 
    • Liangxie
    • Author
    • Quickbase Alumni
    • September 9, 2017
    and some web. need encode two numbers at two differnt place, it's also one question 
    The problem is that the website will now allow you to do that.  Even if you paste in the URKL that you see after you do a search, it does not work.  So trying to replicate that URL will not be successful.

    Try it. do a manual search and observe the URL.  Copy and paste it manually and you will see that it does not work
    • anomDiebolt
    • Quickbase Alumni
    • September 9, 2017
    I am guessing this is the type of URL formula field you are looking for:
    "http://elines.coscoshipping.com/NewEBWeb/public/cargoTracking/cargoTracking.xhtml"; &
    "?CARGO_TRACKING_NUMBER_TYPE=" & URLEncode([BILLOFLADING]) &
    "&CARGO_TRACKING_NUMBER=" & URLEncode([CARGO_TRACKING_NUMBER]) & 
    "&REDIRECT=1" &
    "&uid=6157691370"
    You are better of formatting a URL formula with one query parameter per line even in situations above the last two parameters are constants and could be written as one string:
    "&REDIRECT=1&uid=6157691370"
    You may think you are shortening the formula if you do this or you may not think you don't need any greater generality but you will just be making your formula more difficult to read and maintain in the future.
    • Liangxie
    • Author
    • Quickbase Alumni
    • September 9, 2017
    I figure it out
    thanks a lot
    Terms & ConditionsAccessibility statement