Clay Icon

Creating Conditional Runs Based on SFDC Lookup Results

·
·

Hi Support - I am trying to create a conditional run where I want the column to only run if the SFDC look up column is "No records found" My question is when I am using a SFDC lookup column and it returns "No records found" is this considered "blank" ? I am not sure what to prompt when I'm using the AI formula generator

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Yes, but here’s a more efficient approach. Instead of checking if the SFDC lookup column is “blank” or “No records found,” I recommend referencing a value that is always present when there’s a result, like a company name or contact information. This way, you can set your condition to check for the presence of that reliable field. It ensures the run only happens when there’s no valid record, making the process smoother. Let me know if you need any help with the formula! 😊

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Allister P.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: