Are there temporary variables or is it possible to implement a temporary column in AppSheet?

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 Solved
0 5 755
1 ACCEPTED SOLUTION

Aurelien
Google Developer Expert
Google Developer Expert

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])

 

 

View solution in original post

5 REPLIES 5
Top Labels in this Space