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 |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |