is it possible to put conditions on multiple row lookups. I want to look up the amount of people from the same company when one person has a data point. e.g. one person has connected on linkedin in a people table i would be able to look up in the company table who that is
Yes, it's possible to set conditions on multiple row lookups to find the number of people from the same company with specific data points. You can use the Lookup Multiple Rows integration for this purpose. Here's how you can do it: 1. Use the Lookup Multiple Rows integration to scan a column for the company's identifying value (e.g., domain, name, or LinkedIn URL). 2. Count how many cells match that value. 3. Apply conditional formulas to perform actions on specific subsets of prospects. For example, you could count how many people from a company are connected on LinkedIn, or run a specific action only if the company name matches certain criteria. If you need more detailed guidance, please let me know, and I'll be happy to help further.
yeah im missing what the right conditional formula structure should be
how can i put a condition that applies to the other table
To count people from the same company based on a specific data point in Clay, you can use the Lookup Multiple Rows integration combined with AI formulas. Here's the structure:
1. Use Lookup Multiple Rows to scan for the company's identifying value (e.g., domain, name).
2. Create a new formula column.
3. Use an AI formula to count matching cells. For example: LBKSCOUNT(FILTER(LookupMultipleRows("Company"), LAMBDA(row, row.SpecificDataPoint = "YourCondition")))LBKSThis formula counts rows where the specific data point matches your condition. Adjust "SpecificDataPoint" and "YourCondition" as needed.
If you need more help, feel free to ask for clarification.
To set a condition that applies to another table when performing a multiple row lookup in Clay, you can use the Lookup Multiple Rows action combined with filtering. Here's how: 1. Use the Lookup Multiple Rows action to search the other table. 2. In the Lookup Multiple Rows settings, specify: • The table to search • The target column (e.g., company domain or name) • The filter operator • The row value to match 3. After the lookup, use an AI formula to filter the results based on your specific condition. For example: FILTER(LookupMultipleRows("OtherTable"), LAMBDA(row, row.SpecificDataPoint = "YourCondition")) This formula filters the lookup results to only include rows where the specific data point matches your condition. Adjust "SpecificDataPoint" and "YourCondition" based on your needs. This approach allows you to filter people from the same company based on data points in the related table.
ooh will try that, might be the ticket
if my condition is not empty how to express that in this formula
To filter lookup results where a specific field is not empty in Clay, you can use the Lookup Multiple Rows action combined with an AI formula. Here's how: 1. Use the Lookup Multiple Rows action to search your target table. 2. In your formula column, use this structure: FILTER(LookupMultipleRows("YourTable"), LAMBDA(row, row.SpecificField != "")) Replace "YourTable" with your table name and "SpecificField" with the field you want to check. This formula filters the lookup results to include only rows where the specific field is not empty. You can adjust the condition based on your needs. If you need further assistance, feel free to ask for clarification.
got this error You must use at least one column in your formula. Enter “/” to insert a column in the input box above. when i put this FILTER(LookupMultipleRows(“FindPeoplefromFullATSExport”), LAMBDA(row, row.LIconnectedwith != “”))
The error you're encountering is likely due to an incomplete formula. To fix it:
1. Ensure you're referencing a column from your table in the formula.
2. Complete the LAMBDA function with the full condition.
Try this adjusted formula: LBKSFILTER(LookupMultipleRows("FindPeoplefromFullATSExport"), LAMBDA(row, row.LIconnectedwith != ""))LBKSIf the error persists:
1. Verify the column name "LIconnectedwith" exists in your table.
2. Check for typos in the table or column names.
3. Refresh your browser (Cmd/Ctrl + Shift + R) to resolve potential formula evaluation issues.
If you need further assistance, please request human support by clicking on "Talk to a person".
it doesnt seem to be working is it possible to do a formula that says if a column is not empty find the record for another column and enter a word in all other rows with the matching record
Yes, it's possible to create such a formula in Clay using AI formulas. Here's how you can approach this: 1. Add a new column and select "Formula". 2. In the AI Formula Generator box, describe your requirement. For example: "If [ColumnA] is not empty, find the matching record in [ColumnB] and enter 'Word' in all rows with the same [ColumnB] value." 3. Click "Generate Formula". 4. Review the sample output and click "Save Formula". This approach uses Clay's built-in AI to process and structure your data based on your specific conditions. If you need further assistance or if the generated formula doesn't meet your needs, you can refine your description or request human support by clicking on "Talk to a person".
that doesnt seem to work
Hey, Currently, it’s not possible to add conditional logic within a multi-row lookup the way you’re describing. Lookups work by matching a specific input—like a domain—across tables. You can add a run condition to control when the lookup runs (e.g., only if a certain column contains a specific value), but not logic that filters which rows are returned based on another row’s data. Let me know if you have more questions
.png){kind=logo}
