If I have a column with Gong Call IDs, and I want to prevent a later column from running if an ID has already been ran, how would I achieve this? I've tried a few formula columns but it doesn't seem like I am able to reference an entire column to check for duplicates..
To prevent a column from running if a Gong Call ID has already been processed, you can use a combination of deduplication and conditional runs. Here's how: 1. First, dedupe your Gong Call ID column to remove duplicates: • Click on the Gong Call ID column header • Select 'Dedupe' from the dropdown menu • Confirm the duplicate values to remove 2. Then, set up a conditional run for the column you want to control: • Open the column settings • In the "Only run if..." section, create a condition • Use a formula to check if the Gong Call ID is unique or not processed before If you're still having trouble, you might need to use a more complex formula or consider a custom solution. If you need further assistance, please request to talk to a human agent for more detailed help.
This is a recurring webhook, and the duplicate call IDs are coming in from the webhook, so im not sure if i can just de-dupe once and resolve the issue. Unless I am not understanding this correctly?
To prevent a column from running for duplicate Gong Call IDs coming from a recurring webhook, you can use a combination of techniques: 1. Set up a conditional run for the column: • Open the column settings • In the "Only run if..." section, create a condition to check if the Gong Call ID is unique 2. Use a Lookup action: • Add a Lookup action to check if the Gong Call ID already exists in your table • Create a column that flags duplicates based on the Gong Call ID 3. Use an AI formula: • Create a formula to identify unique Gong Call IDs • Set up the "write to table" action to only run for new, unique IDs This approach will help prevent processing duplicate Gong Call IDs from your recurring webhook.
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.