Hey there, im pulling in a record from our CRM. It has their domain filled out and I can make a column out of that nested variable. But when i go to reference it for a prompt, it says it doesnt see anything. Why is this?
Hello Alejandro R. You can fix this easily here's what's happening and how to solve it When you pull data from your CRM into Clay, nested variables like domain inside a linked or object field don't always register as plain text so Clay's AI or formula columns can't "see" them directly in a prompt to fix it. add a new Text column and use a formula to extract the domain for example if your CRM field is company domain make a new column and set the formula to =thisRow.company.domain. this flattens the nested variable into a readable text field after that reference the new column in your prompt it'll show up correctly and work with AI or enrichment columns.
If you’ve created a column from a nested variable (like a domain) after pulling a CRM record, but can’t reference it in a prompt, it’s likely because you’re referencing the entire object instead of the specific key. Make sure your prompt variable points directly to the domain field, not the parent object. In the prompt editor, use the curly bracket notation to reference the specific column (e.g., {Domain}), and ensure you’ve mapped the endpoint as its own column, not just as part of a nested object. This allows the prompt to access the value directly rather than an object, which would otherwise result in errors or empty values [1] [2].
Is that what you were looking for?
Thanks for your message. Could you please provide more details or clarify your question so I can assist you better?
i tried both. the domain only shows up under the parent object. When i go to the child object, it shows it as empty, even though the value is there from the record
When you import CRM data, fields like "domain" may initially appear only within a parent object. To use the domain as a standalone column, you need to explicitly add it as its own column from the cell details. If the child column appears empty, it’s likely because it hasn’t been mapped or populated correctly—ensure you use "Add as column" on the specific endpoint in the parent object. Also, when referencing in prompts or formulas, always target the specific key (e.g., domain), not the entire object, to avoid empty or [object Object] errors. [1] [2]
Did that answer your question?
yes, i tried that. still didnt work
I'm sorry to hear that didn't resolve the issue. I'll connect you to a human agent who can assist you further.
Clay Support is sharing a file with you.
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!
Hi Alejandro, thank you for reaching out. Can you share with Clay table URL so that I can take a look? Thanks!
Hi Alejandro, I noticed you also reached out through our in-app support channel. Let’s continue the conversation there so we can keep everything in one place.
