Function validation

Custom JavaScript validation function (returns row if valid, null if invalid).

Parameters

• function (string, required) — JavaScript function code. Default: "".

Field selection

• source — Field whose values this operation reads. Omit to apply to all fields on the row.
• target — Optional output field. When omitted, the source field is updated in place.

JSON Configuration

{
  "id": "op-function",
  "type": "validation",
  "action": "function",
  "params": {
    "function": "(cellValue, { row }) => row.status === 'active' ? row : null"
  },
  "testInputs": [
    "hello world",
    "valid row",
    "good value",
    "HELLO WORLD",
    "bad row",
    "invalid value"
  ]
}