really needs help about the forluma

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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="
))
Photo of Liang xie

Liang xie

  • 170 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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?
Photo of Liang xie

Liang xie

  • 170 Points 100 badge 2x thumb
yes, the bill of landing field is a text field
Photo of Liang xie

Liang xie

  • 170 Points 100 badge 2x thumb
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")
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
To test for not blank use this

If(Trim([my text field])<>"" ,
Photo of Liang xie

Liang xie

  • 170 Points 100 badge 2x thumb
Really needs help about it! thanks a lot!
Photo of Liang xie

Liang xie

  • 170 Points 100 badge 2x thumb
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"??
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
I suggest just having a separate field with a message if the bill of lading is blank.
Photo of Liang xie

Liang xie

  • 170 Points 100 badge 2x thumb
i did another file, how to put the end?
If the bill of landing is blank, show new button?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
If(Trim([Bill of Landing No.])="", "Not Ready Yet")