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?