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.
User | Count |
---|---|
41 | |
29 | |
24 | |
24 | |
13 |