USERSETTING and security filter not working with 1 table

[Wojciech_Redman]

Hello,

I’ve added usersetting “ZASIĘG WPISÓW” (datetime type) which I’m planning to use with Security filter like:

[DATA]>= DATETIME(USERSETTINGS(ZASIĘG WPISÓW))

Its working with almost all of my tables.
I have problem only with one table. When I’m trying to use this security filter I can see following error:

Any ideas how to fix that?

[Suvrutt_Gurjar]

Does the following help?

[DATA]>= USERSETTINGS(ZASIĘG WPISÓW)

Assumes column[Data] and the User settings column (ZASIĘG WPISÓW) both are of datetime type.

[Wojciech_Redman]

Still the same
ofcorse both are datetime type.

[1minManager]

I had an issue last week where UserSettings() had to use the Initial Value formula in order to work. Using the App formula and a virtual collumn to just mirror the UserSetting() gave a blank result.

Usersettings not working Questions

I’ve read this by @Fabian but I’m not sure its the same issue I’ve created a TEXT type UserSetting column called User_Type which gets the user permission level with the following set as the App formula ANY(Select(Staff[Type],[Login Email]=UserEmail())) I then wanted to use this to create a Show_If for a column with something like these: UserSettings(“User_Type”)="Retailer" Errors after save with: Column Name ‘Job Number’ in Schema ‘Bookings_Schema’ of Column Type ‘Text’ has an invalid Edi…

[Wojciech_Redman]

In my case there is initial value from the begening.
This usersetting is working well with the same security filter in another tables, where DATA field is the same column type… I have no idea why its not working with this one table.

I’ve been trying with changing column type from datetime to date, also to text… still the same.

[Wojciech_Redman]

The problem was there were two references in User Settings to table WYNIKI PRODUKCJI.
When I cleared out those two expressions, that resolved the error.

I recieved that tip from AppSheet support, thank you guys!