Is it possible to load the value of a field and use that to compare it to another field and based on that add a new field with a value?
if [temperature] > [alert1] add field "outcome => normal" if else [temperature] > [alert2] add field "outcome => high"
Something like the below will work but it will be a lot of work to maintain as I have many different alert values. The above should be more flexible as I'd only need one line for each alert.
if [alert1] == "1000" and temperature >1000 add field "outcome => normal"