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!
Solved! Go to Solution.
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])
User | Count |
---|---|
31 | |
13 | |
3 | |
3 | |
2 |