Formula for Handling Timeout in Another Column

·

Hey, I'd like to make a run condition if another column (a https api) times out. Is there a formula I can use for this?

· Sorted by Oldest

Ryane P.
·
·
https://app.clay.com/workspaces/11790/tables/t_RLIZhVdgPWWw/views/gv_yoBxtojpaWkP
Clay Team
APP
·
·
Hey Ryane, thanks for the message! Taking a look... while the formula currently can't pick up the "Times out" message, you could instead give it a condition so that the other column only runs if this HTTP column has no results/is empty
Ryane P.
·
·
Thanks, but the issue with that is wont it run for all leads before the http is attempted?
Ryane P.
·
·
*is the issue with that
Clay Team
APP
·
·
Hey!! Also checking on this one again
Clay Team
APP
·
·
What column did you want to condition this based on the timed out? I'll add a length > 0 condition so it checks if it's empty or not
Ryane P.
·
·
i ended up deleting it, can you copy the run condition in here and ill add it myself please 🙂
Clay Team
APP
·
·
I see, well, it depends on what you wanted to achieve with the condition. If you want a column to run when the previous one is empty (timed out and thus no results), here's one that I use the AI generator to create, to run only if this returns true: Object.values({{MillionVerifier}})?.some(value => value !== "")

Ryane P.
·
·
https://app.clay.com/workspaces/11790/tables/t_RLIZhVdgPWWw/views/gv_yoBxtojpaWkP
Clay Team
APP
·
·
Hey Ryane, thanks for the message! Taking a look... while the formula currently can't pick up the "Times out" message, you could instead give it a condition so that the other column only runs if this HTTP column has no results/is empty
Ryane P.
·
·
Thanks, but the issue with that is wont it run for all leads before the http is attempted?
Ryane P.
·
·
*is the issue with that
Clay Team
APP
·
·
Hey!! Also checking on this one again
Clay Team
APP
·
·
What column did you want to condition this based on the timed out? I'll add a length > 0 condition so it checks if it's empty or not
Ryane P.
·
·
i ended up deleting it, can you copy the run condition in here and ill add it myself please 🙂
Clay Team
APP
·
·
I see, well, it depends on what you wanted to achieve with the condition. If you want a column to run when the previous one is empty (timed out and thus no results), here's one that I use the AI generator to create, to run only if this returns true: Object.values({{MillionVerifier}})?.some(value => value !== "")