Evaluate 2 fields with a modifier

Discussion created by g.bathurst on May 4, 2016
Latest reply on May 4, 2016 by g.bathurst

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?