icon picker
Using buttons to Update tables

image.png
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)
Buttons
0
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
image.png
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()
image.png
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.
image.png

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.