Hello. SWITCH(MAX(SELECT(TEMP[changecount], ...

[111]

Hello.

SWITCH(MAX(SELECT(TEMP[changecount], IN(today(),LIST(TEMP[days])))),

0, “READ_ONLY”,

“ADDS_AND_DELETES”)

I use this formula for table permission about updates, adds, deletes, read-only. This is on ‘are updates allowed?’ question in Tables Tab.

I made virtual columns has formula

‘MAX(SELECT(TEMP[changecount], IN(today(),LIST(TEMP[days]))))’ for log.

But when the output of Log is 0, Table permission is not READ_ONLY but ADDS_AND_DELETES.

Instead of changecount type column, When I use just number type column, The result is READ_ONLY! ( log is 0 )

So, I think this problem is about column type. How can I use first formula included changecount column for table permission?

Always Thank your kindness.