I want to add a collumn in my table, that compares the email address with the website domain, to ensure they are a match. What is the easiest way to do this? I could use claygent Ai of course and write an AI prompt, but was wondering if there is an existing recipe that might be more effective?
๐ค You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Hello there! You can do this using a formula or checkbox column: https://downloads.intercomcdn.com/i/o/1180640586/22f4a5e32204cbbabbed0920/CleanShot+2024-09-15+at+09_29_04%402x.png?expires=1726408800&signature=b72b48d14d4ce59b9894a8513cb8430d6af4383148c51f64afc9bad433df0cbb&req=dSEvFs96nYRXX%2FMW1HO4zfQbNMThNXrpe%2BLQDPtGQV0wTU4BB7StUbO95cK0%0A1tew%0A After selecting one of those columns, you can use the following formula: https://downloads.intercomcdn.com/i/o/1180641168/ad8153db48ba7de3edbfdd8d/CleanShot+2024-09-15+at+09_28_14.gif?expires=1726408800&signature=bc396737fed847e9f30feb40c989df2bc2f9c3b41cd1c09afba31344a5da7a9f&req=dSEvFs96nIBZUfMW1HO4zaVWURFwjxnsrmRtR5fXjKcFCCE8wmymJmgL7PgB%0AVaam%0A The first part of that formula will get everything after the 'Nick D. in the email. Then, it will be compared with the domain. Let me know if this achieves the desired result.
I tested it but coudlnt get it to work its the last two collumns in this clay table - would you mind having a look to see what I did wrong please https://app.clay.com/workspaces/249517/tables/t_wPAXVAVDSCv5/views/gv_mbw4pYm2AN4Z
Hey there Yanick jumping in for Tomi here, the formula you used was correct it just happened to be in the "Text with Tokens" setup rather than in a formula setting. Once the column type was switched to formula, the column started working perfectly. Also the last column was not needed in this situation, so I removed it for you. https://downloads.intercomcdn.com/i/o/1181916391/5d75219fcfc96d53d06173ad/image.png?expires=1726513200&signature=034f1bf9b30e759f6eab3bee1bff2c4dddef6b6352257828c6d56945a16c993c&req=dSEvF8B%2Fm4JWWPMW1HO4zXjHxMDH6WXUmq0FVwKcHHySp%2B9A6L2RQDHSg%2Biv%0AjTc9%0A
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!