Hi there. Valid_If and other type qualifier...

[Tim_Meske]

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?

[Steven_Coile]

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.

[Steven_Coile]

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.

[Tim_Meske]

+Steve Coile thank you!