Hi there.
Valid_If and other type qualifiers… I’m confused on when to use the Valid_If field (and other type qualifiers)rather than the App formula field.
-please share the simple explanation? -is there a best resource that I can reference?
Use App formula to have the app automatically generate a value for a column.
Columns with an App formula do not allow user input.
The App formula value for a virtual column is reevaluated whenever the app is synced.
The App formula for a normal (non-virtual) column is reevaluated whenever
its row is edited and saved.
Valid_If is used to limit what values an app user may input for the column.
The user’s input is “valid if” the Valid_If expression evaluates as true, or if the user’s input matches one of the list of values the Valid_If expression produces.
A user input that is not valid will be rejected, preventing the user from saving a form until corrected.
+Steve Coile thank you!
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |