Make a field required or validated

Validation rules are defines in the Rules_ sheet in your workbook. Each row names a field and a rule type; SheetApps enforces it in the form.

How to make a field required or validated?

• In your workbook, add a Rules_ sheet
• In the Rule Type column enter the rule type — e.g. required, min, max, between, "conditional / validation
• Enter the rule logic in Value column.
• Open the app and click Change app to upload the edited workbook.
• The form now enforces the rule.

Common rules

• required — the field must be filled in.
• min / max — numeric or date bounds (e.g. quantity ≥ 1).
• between — a start/end date pair is validated end ≥ start automatically.
• sensitive — mask the value (last 4 digits) like SSN or card fields.
• conditional or validation — validation logic using AND, OR, etc.

Add rules

• If your workbook does not include a Rules_ sheet, add one.
• Enter the field name and the rule type.
• Enter the rule logic in Value column.
• Re-upload through Change app; the form now enforces them.

Tip

• Date pairs such as start_date/end_date are validated automatically — no rule needed for checking end_date is greate or equal to start_date
• See User Guide for more details on all available rule types.