Hello! Is it possible to save a value in a "s...

(Alessandro Fiorino) #1

Hello! Is it possible to save a value in a “session” variabile (some values read using a lookup based on the user login)

and reuse it later in formulas ?

(Bellave Jayaram) #2

It may be doable with two columns Start and End to trigger scheduled workflows which reset them.

Then, use IFS(AND(ISBLANK ([End], ISNOTBLANK ([Start]), your formula)

(Philip Garrett) #3

@Alessandro_Fiorino

You can use User Setting to store per user values. These values can be used in AppSheet expressions.

User Setting are described here help.appsheet.com - User Settings: The Essentials User Settings: The Essentials help.appsheet.com

(Alessandro Fiorino) #4

The user setting seems to be the right way to do it, but in the example is the user that changes the value of the setting. Is it possible to configure a user setting that can be changed only by the administrator ?