Run trigger if any 1 of multiple fields changes

Posted by Rollbase User on 16-Jul-2012 09:16

I have an "update field value" trigger that I want to run only when any of about 10 fields changes. I know you can set a trigger to run when any single field is updated. However, I would like to run this trigger if any of 10 different fields is updated. Is there a way to do this without creating 10 separate triggers, one for each field that needs to be monitored for updates?

All Replies

Posted by Admin on 16-Jul-2012 11:31

Try formula condition if() which would examine all 10 fields before making action.

Posted by Admin on 16-Jul-2012 15:58

This was my first thought but I do not have any specific value to test against for the 10 fields. Within the if() statement, how do I test for any change?



Testing for a specific condition would be saying something like "if state equals north carolina"



what I am trying to say is "if the state field changes" in the formula condition.





any thoughts on how to accomplish this?

Posted by Admin on 16-Jul-2012 17:13

Use #before option (Chapter 6)





if ({!x} != {!x#before} || {!y} != {!y#before} )...



Posted by Admin on 17-Jul-2012 13:30

This is great, thank you!

This thread is closed