Working with USERSETTINGS() can bring Error messages in the expression builder.
This may happen when you use a “&” in the Usersettings column name like “Cats&Dogs”.
Function 'USERSETTINGS' should have exactly 1 parameters, the name of an option from the user settings
Or when you have a column named “Today”.
could not be parsed due to exception: #VALUE!.
In this case you just have to wrap the column name in double quotation marks like:
USERSETTINGS(“Cats&Dogs”)
USERSETTINGS(“Today”)
@Santiago Maybe you want to update the doc. https://help.appsheet.com/en/articles/901334-user-settings-the-essentials
Thanks Fabian!
User | Count |
---|---|
15 | |
10 | |
10 | |
8 | |
3 |