If you find this document useful, please consider buying me a
Buttons are wonderful tools.
The community was requested to show three steps using buttons:
Copy a value from A to B (Button 1) Add B to C, and store in C (Button 2) Automatically clear B after adding to C (Button3)
Button 1 - This is relatively straightforward, use the modifyrow button
Button 2 This is also relatively straightforward, use the modifyrow button.
It is possible to also make B=0 using this button, by simply clicking on the blue + and adding a rule for B. But then I wouldn’t be able to explain runactions()
Button 3 While still not complicated, this is a step up from the first two buttons.
I went into the formula editor, and combined the two steps using the action RunActions(). With RunActions() you can string together as many formulas as you can come up with, and the system will create them one after the other.