Skip to main content
Question

really needs help about the forluma

  • September 9, 2017
  • 0 replies
  • 84 views
I'm wirting a forluma just can not figure it out,

I just try, if Bill if landing No. is not empty(Bill of landing No. is TEXT), then do connect with the tracking web, or just show "not ready yet" Can you help me about it  

If(not Is Null ([Bill of Landing No.]),
Case([Carrier],
"CMA","http://www.cma-cgm.com/ebusiness/tracking/search?SearchBy=Container&Reference="&URLEnco... of Landing No.]),
"COSCO","http://elines.coscoshipping.com/NewEBWeb/public/cargoTracking/cargoTracking.xhtml?CARGO_TRACKING_NUM...; &URLEncode([Bill of Landing No.])&"&REDIRECT=1&uid="
))
    This topic has been closed for replies.

    To test a text field for being blank, use

    If(Trim([my text field])=""

    I suspect that your Bill of Lading field is a text field. Is that correct?
    • Liangxie
    • Author
    • Registered
    • September 9, 2017
    yes, the bill of landing field is a text field
    • Liangxie
    • Author
    • Registered
    • September 9, 2017
    It looks not work.
    If bill of landing is not blank, do tracking, or show "not ready yet"


    If(Trim([Bill of Landing No.])="", Case([Carrier],"CMA","http://www.cma-cgm.com/ebusiness/tracking/search?SearchBy=Container&Reference="&URLEnco... of Landing No.]),
    "COSCO","http://elines.coscoshipping.com/NewEBWeb/public/cargoTracking/cargoTracking.xhtml?CARGO_TRACKING_NUM...; &URLEncode([Bill of Landing No.])&"&REDIRECT=1&uid="
    ),"Not ready Yet")
    To test for not blank use this

    If(Trim([my text field])<>"" ,
    • Liangxie
    • Author
    • Registered
    • September 9, 2017
    Really needs help about it! thanks a lot!
    • Liangxie
    • Author
    • Registered
    • September 9, 2017
    I made this as a buton, if the bill of landing no is blank, how to make the button gone and show the "not ready yet"??
    I suggest just having a separate field with a message if the bill of lading is blank.
    • Liangxie
    • Author
    • Registered
    • September 10, 2017
    i did another file, how to put the end?
    If the bill of landing is blank, show new button?
    If(Trim([Bill of Landing No.])="", "Not Ready Yet")
    Terms & ConditionsAccessibility statement