Condition

  • switch function - more efficient case of if to replace multiple old value by new value

    switch([field], ‘default value’

    , ‘x’, ‘i’

    , ‘y’, ‘ii’

    , ‘z’, ‘iii’…)