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)
Buttons
0
Search
Column A
Column B
Column C
Button 1
Button 2
Button 3
Column A
Column B
Column C
Button 1
Button 2
Button 3
1
4
4
38
Copy A-B
C+B stored in C
Push 2, Clear B
2
5
5
20
Copy A-B
C+B stored in C
Push 2, Clear B
3
6
6
18
Copy A-B
C+B stored in C
Push 2, Clear B
There are no rows in this table
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.
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (