Is there a way to check duplicates against another table? For example, I want to create a DNC list in one table and then for any new tables I create, I want to automatically check against that DNC table. What would be the easiest way to do this?
Hey Radu! Thanks for reaching out. Great questionโจ You can do this with Clay's Lookup feature. Here's a quick guide showing how this works: https://www.loom.com/share/ad767e3be9914d19a2f6647efe4dfa85?sid=c8b78c32-9bc1-4501-8124-d6c70d2218cf https://docs.clay.com/en/articles/9672418-lookup-single-row-in-other-table-with-clay To set this up, you'll need your Clay API key. You can find that in the settings section of your workspace. 1. Click on your profile at the top right corner of your screen & select settings 2. Select API key > Copy your API key. Once the key is copied, go back to your table, search for "Lookup single row". 3. Select "+add account", paste your API key into the field that pops and save it as default. Let me know if this helps!