If Statement help / Checkbox override | Discussions

Expand all | Collapse all

If Statement help / Checkbox override

  • 1.  If Statement help / Checkbox override

    Posted 02-27-2019 00:50
    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],
    )


  • 2.  RE: If Statement help / Checkbox override

    Bronze
    Contributor
    Posted 02-27-2019 01:17
    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],
    ))))


  • 3.  RE: If Statement help / Checkbox override

    Posted 02-27-2019 19:28
    thanks - i'll give this a go