Valid_If chaged?

AppSheet AppSheet Q&A
1

Just spent 30mins trying to diagnose a problem that didn’t even exist…

As far as I knew Valid_If functions are calculated on each change made in a form. In the App I’ve just been working on they don’t show up until you click save. Then they show on every change.

I’ve been going in circles because even this simple formula didn’t show the default red error message UNITL you clicked save.
IF(
AND([Location]=“All”,[Stage]=“All”,[SubSection]=“All”,[Item]=“All”),
FALSE,
TRUE)

All 4 columns were clearly “ALL” and you could even edit text boxes and other items in the form without the message showing.

2

If you are using the expression for the current row’s form ebtry filling and checking valid_if, I believe you may wish to add [_THISROW] before each column AND( [_THISROW].[Location],…)

3

Tried that, makes no difference

4

Hi @1minManager,

I am unaware what could be challenge. My testing shows it works. And it works even without [_THISROW]

Someone else may have inputs for you.

1 Like
5

Sounds like a bug. Please engage support@appsheet.com.

1 Like