Skip to content
More
Share
Explore
Using buttons to Update tables
Using buttons to Update tables
Buttons are wonderful tools.
The community was requested to show three steps using buttons:
Buttons
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.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.