USERSETTINGS() Error

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

3 1 679
1 REPLY 1

Thanks Fabian!

Top Labels in this Space