If Statement help / Checkbox override

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
I currently have the following If Statment in my field called [terminal - internal]

long story short there comes a time where I need to override this information with the info from another field called [alternative terminal]

I've created a checkbox and I wanted to see if I can modify this if statement so that when the checkbox is checked the value in [terminal-internal] becomes the value that in [alternative terminal]

I hope this makes sense - pretty much override the the [terminal-internal] with the [alternative terminal]

If(
[Port of Loading]="Vancouver", [Voyage Dates - Terminal2],
[Port of Loading]="Seattle", [Voyage Dates - Terminal 3],
[Port of Loading]="Tacoma", [Voyage Dates - Terminal 3],
)
Photo of oliver mah

oliver mah

  • 930 Points 500 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Micro Dev

Micro Dev

  • 1,444 Points 1k badge 2x thumb
I would do:

If([new checkbox field]=true,[alternative terminal],
If(
[Port of Loading]="Vancouver", [Voyage Dates - Terminal2],
If([Port of Loading]="Seattle", [Voyage Dates - Terminal 3],
If([Port of Loading]="Tacoma", [Voyage Dates - Terminal 3],
))))
Photo of oliver mah

oliver mah

  • 930 Points 500 badge 2x thumb
thanks - i'll give this a go