Are there temporary variables or is it possible to implement a temporary column in AppSheet?
The doubt has arisen, because I need a temporary variable. Is there any alternative solution, I’ve been looking and I haven’t found anything similar.
If it does not exist, would the solution of creating a new column or a new sheet called “temporary data” be feasible?
Thank you! All the best!
Hi @JuanIsidoro
“If it does not exist, would the solution of creating a new column or a new sheet called “temporary data” be feasible?”
I would go for this solution indeed.
Create a new table with:
one unique row
columns: key, variableName1, variableName2, etc
update mode: “Update only”
Everytime you will want to refer to it, use:
ANY(myVariableTable[variableName])
You may also want to take a look at the option of USERSETTINGS
There are always solutions or alternative ways.
Thank you very much for the recommendation! ^^
I’ll give it a thought to see if it’s feasible dynamically.
Thank you very much!
In addition to excellent suggestion by @Aurelien , another approach that faintly touches the user specific variables, you may want to familiarize yourself is User Settings.
This might be of use, especially if you’re planning on expanding your app and building out more functionalities.
You might also considering adding your vote to getting Global variables added to the system:
https://www.googlecloudcommunity.com/gc/Feature-Ideas/Global-Variables/idi-p/429121