How to Validate Emails in Two Columns with DeBounce

Happy New Year y'all! I'm trying to validate emails with DeBounce and I have two columns with email addresses in them. Here is what I'm trying to achieve:

If Column 1 (AI output) has an email address, validate the email in Column 1
If Column 1 does not have an email address, validate the email in Column 2

I'm playing with the custom formulas and getting close but am getting a "missing input" error when Column 1 is blank.

✅1

9 comments

Bryan S.
·
·
https://app.clay.com/workspaces/163549/tables/t_C7AjuvFDngZN/views/gv_Z5AXIlQqavqK
Clay Team
APP
·
·
Hey Bryan, Happy New Year, and thanks for reaching out! I'll take a look
:thumbsup_all:1
Bryan S.
·
·
Thank you!
Clay Team
APP
·
·
Looks like it's because chatGPT is checking for the Scraped Email column but it's empty and also set to "required to run". If you want it to run even when the column is empty you can toggle this option off by clicking on the input
b9cf69e7-fe48-4697-8244-07b3e1d6080f.png(12 kB)
Clay Team
APP
·
·
QQ, is there another source you want it to extract an email from? Once that's identified, you can pull the emails into a single column and that can be the column Debounce validates in the end.
Bryan S.
·
·
Yes so I want to:
1.
Validate the email in "Email Data"
If there is no email in "Email Data" then 2. Validate the email in "BuiltWith Email"
Bryan S.
·
·
I was also having trouble combining these two columns into one or even copying and pasting from "BuiltWith Email" into another column
Clay Team
APP
·
·
I'd say it's best to add a new column and use the formula generator to achieve this consolidation. Here's an example of how to use the formula generator to clean up or format other columns but instead you can prompt it to first return "Email 1" then try to return "Email 2": https://www.loom.com/share/bbb329dcf708442b9abbdf26e870f596
Bryan S.
·
·
ok thank you Arturo O.!