User settings and initial value

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.

[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").


Excellent! Thank you Steve.

1 Like