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.
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],โฆ)
Tried that, makes no difference
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.
Sounds like a bug. Please engage support@appsheet.com.
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
18 |