4 Replies Latest reply on May 4, 2016 3:24 PM by g.bathurst

    Evaluate 2 fields with a modifier


      I'm working on a solution to provide notifications when field data matches in 2 different tables, this works fine using the if statement.


      If (GetField ($FieldEvaluation) = $FieldValue) -> send the email notification (No problem)


      I'd like to modify this to evaluate the fields for values GREATER than and LESS than, using a modifier which I have in the table as well ($AlarmModifier), so what I'd like to do is replace the static = and use the modifier to evaluate the 2 fields:


      If (GetField ($FieldEvaluation) & $AlarmModifier & $FieldValue)  (NOT working)


      But this will not work...any thoughts?