number_range validator

Faithful summary of lib/validators.ts. Validators are pure functions and run identically in the worker, the Workbench, and the MCP server.

function validNumberRange(value, params) {
  const n = Number(value)
  if (!Number.isFinite(n)) return fail('number_invalid', 'not a number')
  if (params.min != null && n < params.min) return fail('number_too_small', `< ${params.min}`)
  if (params.max != null && n > params.max) return fail('number_too_large', `> ${params.max}`)
  return OK
}

Validators attach to a field on a custom template. The cascade runs them after mapping but before commit; failures surface in the per-row validation report.

fields:
  - column: deal_score
    type: number
    validators:
      - type: number_range
        min: 0
        max: 100

• Empty string coerces to 0 in JavaScript — but the upstream "empty bypass" rule means blanks skip validation entirely. `"0"` is valid; `""` is skipped.
• Locale-formatted numbers (`"1,234.56"` or `"1.234,56"`) become NaN. Normalize in your transform.
• Bounds are inclusive — `min: 0` accepts `0`.

• Opportunitiesopportunities_v1

  Deals in pipeline: amount, stage, probability, close date, owner.

  Fields: probability

Validators add no AI cost — they are pure functions. Every map bills a small flat per-map fee from your prepaid token wallet ($10 minimum, shared across our suite); only columns that reach the metered LLM layer, plus any-to-any convert and reshape, bill real AI tokens. See pricing →

Back to the documentation index or browse the template catalogue.