Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Reset Variables to Default Values?

Is it possible to have a single action that resets all variables to default values vs having to manually input each "Set Variable" in the actions? Would like to avoid having to manually create an action for individual variables

Thanks!

1 Solution

Accepted Solutions
marcus_sommer

You could use a bookmark for this - the values from variables could be included in a bookmark if by each variable the option "store in bookmark" is enabled.

- Marcus

View solution in original post

4 Replies
Not applicable
Author

Easy way is declare the variables in script or in an excel & load.

Hard way is use a macro to read variables from excel which will read default values.

jolivares
Specialist
Specialist

No... you have to clear one at a time.

marcus_sommer

You could use a bookmark for this - the values from variables could be included in a bookmark if by each variable the option "store in bookmark" is enabled.

- Marcus

Not applicable
Author

Thanks Marcus!!

I was able to store the default values for the variables using the bookmarking feature and a hidden input box. What I also did to take it a step further and "automate" the reset was to have the sheet apply the bookmark on activation.

-Jason