Hey everyone, I'm trying to find a way to make a column execute only if the previous column's value has changed. The previous column holds a numeric value. I’ve tried setting the run condition like !!{previous_column} or {previous_column}.some_value, but in both cases, the cell does not re-run, even when the data has changed. Is there a way to force the cell to re-evaluate based on value change?
You can use conditional runs with a comparison operator to check if the previous column's value has changed.
1. Go to the Run Settings of your column
2. In the "Only run if" box, use a formula that compares the current value with a previous value
3. Try using comparison operators like !=
(not equal to) to detect changes
For example, you might use a formula that compares the current value to what it was before, triggering the column to run only when they differ.
Hey Bhanu! Thanks for reaching out. Happy to help✨. Could you share more about your use-case? If you can share your table and the column you're trying to configure this, we're happy to review this and share suggestions. For context, if a column's field is being used as a condition for another column, it will only automatically re-evaluate if the value no longer exists. However, if the cell still has a value, the specific value changing will not impact this, unless the condition specifically references the value itself. For example, if the formula says an enrichment should only run if {{domain}} exists, it will not re-run if the specific value for domain changes because it is only checking for the presence of a domain. However, if the formula says "only run if {{domain}} is google.com, and some cells that previously did not have this, now have that value, the column will re-run.
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.