Discussions

Expand all | Collapse all

really needs help about the forluma

  • 1.  really needs help about the forluma

    Posted 09-09-2017 15:41
    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="
    ))


  • 2.  RE: really needs help about the forluma

    Posted 09-09-2017 15:48
    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?


  • 3.  RE: really needs help about the forluma

    Posted 09-09-2017 15:52
    yes, the bill of landing field is a text field


  • 4.  RE: really needs help about the forluma

    Posted 09-09-2017 15:56
    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")


  • 5.  RE: really needs help about the forluma

    Posted 09-09-2017 16:04
    To test for not blank use this

    If(Trim([my text field])<>"" ,


  • 6.  RE: really needs help about the forluma

    Posted 09-09-2017 16:07
    Really needs help about it! thanks a lot!


  • 7.  RE: really needs help about the forluma

    Posted 09-09-2017 16:10
    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"??


  • 8.  RE: really needs help about the forluma

    Posted 09-09-2017 16:22
    I suggest just having a separate field with a message if the bill of lading is blank.


  • 9.  RE: really needs help about the forluma

    Posted 09-09-2017 20:28
    i did another file, how to put the end?
    If the bill of landing is blank, show new button?


  • 10.  RE: really needs help about the forluma

    Posted 09-10-2017 02:46
    If(Trim([Bill of Landing No.])="", "Not Ready Yet")