Submit-blocking validator
Display a message and prevent form submission if a Boolean formula fails
Ingredient Family: formIngredients
Outline Display: Display {{getText}} and prevent form submission if validation formula {{formula}} is not met.
Local scope
The parent slot binds these (look up the slot in the parent to see how):
$parentTable– The table (if any) that this form is based on$formFieldsTable– A table of form fields that is built up through the sequence of form ingredients
Settings
Required
-
formula: formula (returns bool; required, non-nullable)
The formula that checks form validity
Scope: all columns of$formFieldsTable(reference as[ColumnName], e.g.,[Name],[Price]) -
getText: formula (returns formatted text; required, non-nullable)
The text to display when the user tries to submit an invalid form. Note that because the output is richtext, any math-like operators, such asIF, must be wrapped in $$…$$.
Scope: all columns of$formFieldsTable(reference as[ColumnName], e.g.,[Name],[Price])