Clay Icon

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?

  • Avatar of Clay Team
    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

  • Avatar of Ryane P.
    Ryane P.
    ·
    ·

    Thanks, but the issue with that is wont it run for all leads before the http is attempted?

  • Avatar of Ryane P.
    Ryane P.
    ·
    ·

    *is the issue with that

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey!! Also checking on this one again

  • Avatar of Clay Team
    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

  • Avatar of Ryane P.
    Ryane P.
    ·
    ·

    i ended up deleting it, can you copy the run condition in here and ill add it myself please 🙂

  • Avatar of Clay Team
    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 !== "")