If [A] is checked, change [Multiple Choice] to "Cancelled".
This is the current form rule that I have created, the only problem is that it only forces the change in the "Edit" mode, so I would have to click "Edit' and click "Save" every time I want to change it.
Is there any way to fire this change without having to click "Edit" -> "Save"? I also do not want to change the [Multiple Choice] field to a formula rule.
Maybe script to recognize if [A] is checked, then EditRecord for [Multiple Choice]?
Any help would be appreciated, thanks!