Transfer Error Messages from One Column to Another

Sergio S. · 2026-01-09T18:25:22.825Z

How Do I get the error message from a column into another one I tried to do it with Sculptor but It was not able to do so

Transfer Error Messages from One Column to Another | Clay

Clay Support
APP
·
·
You can extract error messages from cells into a new column. Click on the error cell to open the Cell details panel, then hover over the error message field and click "Add as column". [1]
You can either create a new column by entering a description and clicking "Create column", or map it to an existing column which will overwrite those values. [2]
Since you mentioned the error contains JSON-like structure, you might also want to try our built-in Sculptor tool again - it's in the top-right corner and can help build workflows for extracting specific data from error messages.
Clay Support
APP
·
·
Is that what you were looking for?
Sergio S.
·
·
I tried that without success. There is no add as column when I click the error cell I tried the sculptor to help with a formula and it was just not able to retrieve the error message
Clay Support
APP
·
·
Since you're seeing JSON in that error message, can you copy and paste the full JSON error from the cell details panel into this chat? That'll help me troubleshoot what's happening.
Also, try clicking directly into the specific error cell to expose more details about the error message - sometimes additional options appear when you drill down into the cell.
If the "Add as column" option still isn't showing up, you can try using a Formula column instead. Add a new column, choose "Formulas," and describe what you want to extract from the error messages.
Sergio S.
·
·
[{"duplicateResult":{"allowSave":true,"duplicateRule":"Account_Same_Name_Soft_Warning","duplicateRuleEntityType":"Account","errorMessage":"Another Account with a similar Name exists. Please review the existing record(s) and compare website/domain before creating a new Account.","matchResults":[{"entityType":"Account","errors":[],"matchEngine":"FuzzyMatchEngine","matchRecords":[{"additionalInformation":[],"fieldDiffs":[],"matchConfidence":91.0,"record":{"attributes":{"type":"Account","url":"/services/data/v55.0/sobjects/Account/0013l00002CLN5GAAX"},"Id":"0013l00002CLN5GAAX"}}],"rule":"Account_Same_Name_Soft","size":1,"success":true}]},"errorCode":"DUPLICATES_DETECTED","message":"Another Account with a similar Name exists. Please review the existing record(s) and compare website/domain before creating a new Account."}]
Clay Support
APP
·
·
Perfect! Now I can see the JSON structure. You can extract the error message using a Formula column:
1.
Add a new column and select "Formulas"
2.
In the AI Formula Generator, type: "Extract the errorMessage from /[your error column name]"
3.
Click "Generate Formula"
The formula should pull out "Another Account with a similar Name exists. Please review the existing record(s) and compare website/domain before creating a new Account."
If that doesn't work, try this specific approach: reference the JSON path like /[column].errorMessage or /[column].duplicateResult.errorMessage in your formula description. [1]
Clay Support
APP
·
·
Did that answer your question?
Sergio S.
·
·
None of the options works
Clay Support
APP
·
·
I'm sorry to hear that none of the options worked. I'll connect you to a human agent who can assist you further.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!

image.png(93 kB)
Sergio S.
·
·
This is the table: https://app.clay.com/workspaces/861922/workbooks/wb_0t6nt03xidNSqbFDBam/tables/t_0t8lz1g4kZxo6qvWB7y/views/gv_0t6nt0tVPYvejXemdvn
Sergio S.
·
·
Hey there?
LuisArturo
·
·
Hey there Sergio thanks for reaching out, sorry for the delay here, currently you are not able to extract Error messages into columns inside of Clay, Apologies for the confusion from the AI here
Sergio S.
·
·
Thanks! Is there a workaround for this? I can extract and work in gsheet if that’s an option
LuisArturo
·
·
At the moment outside copying the text that appears in the window and pasting it somewhere else is the only way, although this is something we are currently looking into adding into Clay although there is no ETA for when this could happen

18 comments