Triggering Column Execution on Previous Column Value Change

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?

3 comments

Channeled
APP
·
·
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.
Sources: Conditional runs | Documentation | Clay University Conditional runs | Documentation | Clay University Comparison operators | Documentation | Clay University
Daniela D.
·
·
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.
Channeled
APP
·
·
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.

Triggering Column Execution on Previous Column Value Change | Clay