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

[JuanIsidoro]

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!

[Aurelien · Accepted 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])

[JuanIsidoro]

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!

[Suvrutt_Gurjar]

You may also want to take a look at the option of USERSETTINGS

https://support.google.com/appsheet/answer/10106760?hl=en

[Suvrutt_Gurjar]

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.

https://support.google.com/appsheet/answer/10106760?hl=en

[MultiTech]

This might be of use, especially if you're planning on expanding your app and building out more functionalities.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Current-User-Slice-How-to-conform-your-app-aroun...

_____________________________

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