User settings and initial value

[tcanelli]

I am using the user settings to filter certain slices and am wondering if it’s possible to have the initial value for a column in a form auto fill based on the user settings as well. So far I haven’t been able to make this work.

Here is what I tried - and it just made the column invalid as it filled in true or false. True if no user setting was selected and false when it was.

[Steve]

[EvacCenter]=USERSETTINGS("Evac Center")is an expression that asks the question, “is the EvacCenter column value equal to the Evac Center user setting?” Hence the TRUE/FALSE result.

If you want the column’s initial value to be the value of the Evac Center user setting, set the initial value expression to, simply, USERSETTINGS("Evac Center").

[tcanelli]

Excellent! Thank you Steve.