Order of Execution: Understanding, Observing, and Controlling the Logic Flow

I am getting some strange/unexpected behaviour (from a logic perspective) and am wondering if the order of execution is having an effect a) How is order of execution determined b) How can we see what the order of execution is c) If we need to, how can we control the order of execution?

5 comments

Clay Team
APP
·
·
Hey Ian! Columns will follow a dependency logic, where if you give inputs that come from a different source to another column it will wait for that information before it fully runs as long as they are not optional inputs in some cases (like in chatGPT or a Googler Search you can set inputs as optional and others as required).When conditions are met then columns and data is available, columns should run if they're set to auto-update.
Clay Team
APP
·
·
A way to visualize this is the graph view of a table which will show you what columns depend on and what comes next if anything is connected to that result.
Clay Team
APP
·
·
To control the order of execution, conditional formulas are usually the easiest way to ensure your workflow runs as you need it to.
Ian M.
·
·
Does this apply when we are doing a Lookup and a Write to another table?
Clay Team
APP
·
·
Yes, if you won't need it to run after certain triggers, you can set those conditionals to check for them. Unfortunately, though, there's no "delay" function yet but the team has some of those concepts in mind; hopefully soon.