Clay Icon

Tips to Structure Table for Proper Count Rows Execution in Workflow

·
·

Any tips for how to structure this table to only run the Count Rows after the Find People operation has been completed? It's creating a race condition. In screenshot, rows 1-3 I had to manually rerun. Row 4 shows the default result when a new row added

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    You can use Clay's Conditional Run feature to ensure the Count Rows operation only runs after Find People is completed. Here's how to set it up: 1. Click on "Run Settings" for your Count Rows column 2. Select "Conditional Run" 3. Use the AI formula generator to create a condition that checks if the Find People operation has completedThis approach will ensure the Count Rows operation only executes when the necessary data from Find People is available, preventing the need for manual reruns.The conditional run will optimize your workflow by only running the count when the prerequisite data exists, making your table more efficient and automated. Sources: AI Formulas + Conditional Runs [Automated Inbound] - Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University Hunter | Documentation | Clay University

  • Avatar of Faye C.
    Faye C.
    ·
    ·

    3. Use the AI formula generator to create a condition that checks if the Find People operation has completed

    Tried this but the AI formula generator wasn't able to produce a formula that checks if the other column operation was completed

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    If the AI formula generator isn't producing the expected result, you can try these approaches: 1. Iterate on your prompt wording in the AI formula generator - sometimes being more specific or rephrasing can help get better results. 2. You can manually create a conditional formula using the following structure: • Use "/" to reference the Find People column • Apply comparison operators to check if the data exists or is not empty • For example, you could check if specific fields that Find People populates (like work experience or profile data) are not emptyIf you continue having trouble getting the right formula, you may want to request human support to help create the specific conditional formula for your use case. Sources: Conditional runs | Documentation | Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University AI Formulas + Conditional Runs [Automated Outbound] - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!

  • Avatar of Joe R.
    Joe R.
    ·
    ·

    In the run condition of the Count column, could you insert something like !!{{People Search}} which checks whether People Search has run? If that doesn’t work, you could try something like !!{{People Search}}?.numPeopleFound > 0 where you only run the count only if People Search returns a non-empty array of people

  • Avatar of Joe R.
    Joe R.
    ·
    ·

    (Hard to tell you exactly what would work without poking in your table, so please feel free to dm me if the suggested approach doesn’t work)

  • Avatar of Faye C.
    Faye C.
    ·
    ·

    Thanks Joe! !!{{People Search}}?.numPeopleFound > 0 worked but now the count just has a "Run condition not met". I feel like what I actually need is a wait condition

  • Avatar of Channeled
    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.