Skip to main content

Field Types and Validation

Spreadsheet Forms support four named cell field types: Text, Number, Date, and Dropdown. Validation applies only to bound cells, not to every cell in the spreadsheet.

Text​

Use Text for names, descriptions, references, remarks, or other free-form values.

Validation:

  • Required check if enabled
  • Export sanitization for values beginning with =, +, or @

Number​

Use Number for amounts, quantities, scores, and numeric calculations.

Validation:

  • Required check if enabled
  • Must be numeric after removing commas
  • Exported as a numeric value
  • Works best with Number, Currency, or Percentage display formats

Date​

Use Date for dates selected by the user.

Validation:

  • Required check if enabled
  • Must parse as a valid date
  • Uses OSPROV's custom DD/MM/YYYY date picker display
  • Stores canonical date values as YYYY-MM-DD
  • Exports as an Excel date

Use Dropdown for controlled choices.

Validation:

  • Required check if enabled
  • Must match one of the configured dropdown options exactly
  • Options are defined one per line in the builder

Checkbox​

Checkbox field metadata appears in earlier spreadsheet form planning notes, but the current builder toolbar does not expose a Checkbox field type. Use Dropdown with choices such as Yes and No when a single-cell choice is needed.