Formulas Overview

Unqork supports over 300 formulas in the Calculator component and Data Workflow formula operations. Formulas follow standard Excel syntax: they begin with = and use parentheses for arguments.

Note: The formulas listed here are recognized by Unqork's formula engine. Most Excel-compatible formulas behave exactly as they do in Excel. Unqork-specific formulas should be verified in the environment before using in production — some might require Unqork's execution context to function correctly.

=SUM(field1, field2)
=IF(status="Active", "Yes", "No")
=DATEFORMAT(submittedDate, "MM/DD/YYYY")

Formula Categories

• Excel Formulas: Standard Excel-compatible formulas for math, text, logic, dates, and more.
• Unqork Formulas: Formulas unique to Unqork, including data manipulation, encoding, formatting, and regex utilities not found in Excel.
• Moment.js Formulas: Date parsing, formatting, and arithmetic using the MOMENT() and DATEFORMAT() functions.

Syntax Rules

• Formulas begin with =.
• Arguments are separated by commas.
• Text values are wrapped in double quotes: "value".
• Field references use the component's Property ID directly: fieldName.
• Nested formulas are supported: =ROUND(AVERAGE(score1, score2), 2).

All Formulas