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

111 · 01-14-2019 04:00 PM

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.

Steven_Coile

LIST(TEMP[days]) may be a problem. TEMP[days] is a column list, which is a list already. It shouldn’t then be wrapped in LIST().

Steven_Coile

What happens if you wrap MAX(…) in NUMBER()?

111

MAX(SELECT(TEMP[changecount], IN([days],LIST(today())))). Sorry, Again, I used this formula. but problem still exists.

111

When I use ‘MAX(SELECT(TEMP[numberColumn], IN([days],LIST(today()))))’, If the result of log was 0, permission was set to READ_ONLY as intended.

111

Did I lose my chance to get answer?TT

Steven_Coile

Did you try NUMBER(MAX(…))?

111

ahhh, Sorry. I misunderstand your advice. Just now , I try max() in number. but the problem remains. And before save, I tested. Test result is as intended( When criteria is 0, READ_ONLY else ADDS_AND_DELETES ). But after save, the app don’t show that result. It seems to be a bug.

Steven_Coile

Yes, it sounds like a bug. Please report it to support@appsheet.com.