The Data Mapper now includes a built-in AI Assistant for Custom Columns. Previously, building or reverse-engineering formulas required searching through the knowledge base or using external assistant to find the correct syntax.

The new AI Assistant helps you easily understand, optimize, create, and troubleshoot formulas directly within the mapper, significantly reducing the time it takes to get the right output.

How it works 

The AI Assistant is context-aware. It has pre-configured knowledge of all available formulas within the data releases environment. It automatically knows:

• Which custom column you are currently working on.
• The exact formula currently inside the column.
• The metadata of the entire table (meaning it knows exactly which other columns are available to use).

Creating a new formula

You can use the AI Assistant to generate complex formulas from scratch using natural language.

1. Open the AI Assistant within your custom column.
2. Type a prompt using natural language describing what you want to achieve.
   • Example: "Provide a formula that will return the end of the month, unless the year is 2024, in which case return the start of the month."
3. The AI will generate the correct formula based on your requirements, along with a brief explanation of how it works.
4. Click Insert to apply the formula directly into your input box with one click.

Explaining an existing formula 

If you inherit a complex formula from a colleague or a customer, the AI Assistant can help you reverse-engineer it to understand its expected output.

1. Open a custom column that contains an existing formula.
2. Ask the AI Assistant to Explain the formula.
3. The AI will provide a full breakdown of the inputs, the logic, and the expected outcomes across different scenarios.

Fixing syntax errors

Instead of manually debugging a long, complex formula, you can use the AI Assistant to automatically spot and resolve errors.

1. Open the custom column containing the broken formula.
2. Ask the AI Assistant to Find issues within the syntax.
3. The AI will scan the formula, identify exactly where the error is (e.g., a missing equal sign in a true statement), explain the syntax error, and provide a suggestion to fix it.

Optimizing complex formulas

If you have written a lengthy formula and want to ensure it runs as efficiently as possible, the AI can clean it up for you.

1. Open the custom column with your working formula.
2. Ask the AI Assistant to Optimize the formula.
3. The AI will suggest a cleaner, optimized version of your logic.
4. Click Insert to replace your old formula with the optimized version.

🔒 Important note on data privacy

While the AI Assistant has full context of the table's metadata (such as column names and structure) to help build your formulas, it does not access or read any Personally Identifiable Information (PII) or underlying cell data. 
* The tool maintains strict data privacy while running over your metadata.

Updated March 19, 2026 10:36