RunActions
RunActions
RunActions()Have a single button run multiple actions
or stated otherwise...
RunActions() has one repeating parameter:
action
RunActions(action)
The action you want your button to perform.
RunActions() simply allows a single button to perform multiple actions with a single push and can only be used in the formula configuration of a button.
Want to see a crazy formula? Hide Formula
This formula is running 6 actions!
All thanks to RunActions()
While it looks complex this action allows a really smooth work-flow that enables project managers to draft soon to be projects in a systematic and controlled way.
The Project Management system with this button is below and you are going to get to see the power of RunActions() by drafting your own quick project!
Go ahead and and draft yourself a project!
Hide this pop-up
Draft a Project
Please fill out each select below to draft your project:
Project Complexity
Give an estimate as to the complexity of this project
Blank
Project Group
The general bucket or type of your project
Blank
Project Start Date
When do you estimate the project will begin
3/26/2023
Project Name
Give a name to this project
Project Manager
Who will be managing this project?
Blank
Fill out all fields above
RunActions causes your document to recalculate between runs
Another unique feature about RunActions() is that it causes your document to recalculate between runs. This feature is better shown than explained.
Each of the two buttons below uses a ForEach() loop to add three random names to a table. But one button uses RunActions() while the other button does not. Press them both and watch how they behave differently
Add names With RunActions
Add names without RunActions
Press the buttons above to fill me with 3 random names
Name
1
Bradley Rosales
2
Stacy Young
3
David Adams
4
Susan Holden
5
Cody Brown
6
Pamela Gibson
7
Pamela Gibson
8
Pamela Gibson
9
Pamela Gibson
10
Ashley Alvarez
11
Lisa Saunders
There are no rows in this table
How to use RunActions
RunActions() cannot be used inside the regular visual editor of a button. To use RunActions(), open the formula editor of your button using the little italic f button.
Once you have done that, merely type in RunActions() and in the parenthesis of that formula type in as many different actions that you want your button to perform all separated by a comma.
RunActions() can be used anywhere actions are used including automations!
Practice: Cause a button to set two different date controls with the push of a button
Done
Create a logging table to know every time a button was pushed
Done
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.