Skip to main content

The Dynamic Formula Editor: Monaco, AI Generation & Validation

The Dynamic Formula Editor: the Monaco-based editing experience, formula validation, and AI natural-language formula generation.

The Dynamic Formula Editor is where you write and validate the C#-based formulas that power dynamic mappings across iPaaS.com. It's built on the Monaco editor - the same editor that powers VS Code - so it brings real code-editing conveniences to formula authoring, plus an AI assistant that can generate formulas from a plain-language description. While this is focused on dynamic formula mappings, it also applies to mapping filters, error filters, export mappings, and translations.

This is the canonical article for the editor itself. For where dynamic formulas fit in mapping, see Getting Started with Dynamic Formulas. Surfaces across the platform that open the editor should link here rather than re-describing it.

The Monaco Editor

When you choose the Dynamic Formula mapping type, the formula opens in the Monaco editor. It provides:

  • Syntax highlighting for C#, so structure is easy to read.

  • IntelliSense / autocomplete for available fields and functions as you type.

  • Inline error indicators that flag problems before you save.

  • Standard editor conveniences - line numbers, bracket matching, find and replace.

Validation

The editor validates your formula so you catch errors at authoring time rather than at runtime. If a formula won't compile or references something unavailable, the editor surfaces it before the mapping is used in a transfer.

AI Formula Generation

You don't have to write formulas from scratch. Describe what you want in plain language - for example, "combine first and last name with a space" or "format the date as MM/DD/YYYY" - and the AI assistant generates the corresponding formula for you to review, adjust, and save.

  • Describe the transformation you want in your own words.

  • The assistant proposes a formula in the editor.

  • Review and edit the result, then validate and save. Always confirm the generated formula does what you intend before using it in a live mapping.

Related Articles

Did this answer your question?