Using buttons to Update tables

⁠

If you find this document useful, please consider buying me a

Ko-fi here.⁠

⁠

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

Buttons

Column A

Column B

Column C

Button 1

Button 2

Button 3

Copy A-B

C+B stored in C

Push 2, Clear B

Copy A-B

C+B stored in C

Push 2, Clear B

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 (

CtrlP

) instead.