Transform Expressions

Add Fields

Add your form fields

Write Transform Expression

Use JSONata to modify the form data. The expression should return the transformed object.

Example: Add Computed Field

Count selected projects and add timestamp:

$merge([
  $,
  {
    "total_projects": $count(projects),
    "configured_at": $now()
  }
])

Input:

{
  "warehouse_id": "wh-123",
  "projects": [{"value": "1"}, {"value": "2"}]
}

Output:

{
  "warehouse_id": "wh-123",
  "projects": [{"value": "1"}, {"value": "2"}],
  "total_projects": 2,
  "configured_at": "2024-01-15T10:30:00Z"
}

Example: Flatten Values

Extract just the IDs from selections:

{
  "warehouse_id": warehouse_id,
  "project_ids": projects.value
}

Output:

{
  "warehouse_id": "wh-123",
  "project_ids": ["1", "2"]
}

Function	Description
`$merge([a, b])`	Combine objects
`$count(array)`	Count items
`$now()`	Current timestamp
`$sum(array)`	Sum numbers
`$join(array, sep)`	Join strings

Function

Description

$merge([a, b])

Combine objects

$count(array)

Count items

$now()

Current timestamp

$sum(array)

Sum numbers

$join(array, sep)

Join strings

Getting Started

How Handled Works

Integrations

Unified APIs

Integrated Accounts

Webhooks

Link SDK

RapidBridge (Sync Jobs)

RapidForm

Workflows

Platform

Transform Expressions

Enable Transforms

Write Transform Expression

Example: Add Computed Field

Example: Flatten Values

Common Functions

​Enable Transforms

​Write Transform Expression

​Example: Add Computed Field

​Example: Flatten Values

​Common Functions

Enable Transforms

Write Transform Expression

Example: Add Computed Field

Example: Flatten Values

Common Functions