Unique Formula Generation for Company Domains in Clay

Ammar K. · 2025-03-17 17:02:03.314398+00

Hi everyone, I want to generate a formula in Clay that can run only on unique values. So for example I have a list of prospects with company domains. I want the formula to run only once per company domain while taking into account all the occurrences of that domain in my table. Can someone help me?

Unique Formula Generation for Company Domains in Clay | Clay

9 comments

· Sorted by Oldest

Channeled
APP
·
·
To create a formula that runs only once per unique company domain while considering all occurrences, you can use the Lookup Multiple Rows integration combined with conditional runs. Here's how: 1. Use the Lookup Multiple Rows integration to count occurrences of each domain in your table. 2. Create a new column for your desired formula. 3. In the new column's settings, set up a conditional run using an AI formula. 4. Use the AI to generate a formula that only runs when it's the first occurrence of a domain. For example: IF(ROW() = MIN(FILTER(ROW(), [Domain] = [Domain])), TRUE, FALSE) This approach ensures your formula runs only once per unique domain while still considering all occurrences in the table.
Source: AI Formulas + Conditional Runs [Clay 101] - Clay University
Ammar K.
·
·
Thanks for sharing. However I need a bit more clarification on the steps in the middle. I've ran the look up multiple rows function on the domain. Now I don't know how to plug that output in a formula.
Loading attachments
Channeled
APP
·
·
To use the output of the Lookup Multiple Rows function on the domain in a formula, you can create a new column with an AI-generated formula. Here's how: 1. Add a new column for your formula. 2. Use the AI formula generator to create a custom formula. 3. In your formula, reference the output of the Lookup Multiple Rows function. For example, you could create a formula that counts the occurrences of a domain or performs actions based on the lookup results. The AI can help you generate specific formulas tailored to your needs, such as: "Count the number of rows where {{Lookup Multiple Rows Output}} contains the current domain" Remember to adjust the formula based on your specific requirements and the structure of your lookup results.
Sources: Formula generator | Documentation | Clay University Formula generator | Documentation | Clay University
Ammar K.
·
·
https://app.clay.com/workspaces/463511/workbooks/wb_wU8iiwqpEvZM/tables/t_G7PNjBP9TTsG/views/gv_CxkDuNJWmzrc
Ammar K.
·
·
For the formula I have the fields:
Number of occurrences of the domain
The domain cell
And the output of the Lookup Multiple Rows function - will I reference all of it?
Please tell me exactly how to create that formula and what to input in the fields.
Loading attachments
LuisArturo
·
·
Hey there Ammar thanks for reaching out, made a loom explaining this for you. https://www.loom.com/share/891485b6e7664508b67e0a1eabbe41d4?sid=920a9a45-a576-46bd-8f35-b267921a010f Find Duplicate in table: https://www.loom.com/share/a39a4569d95244b7886026f3c70812c7?sid=a36ad597-1702-423a-8d23-38c47b7d220b
Ammar K.
·
·
Hi Luis, This is exactly what I was looking for! You made my day. Thank you 🙏
Channeled
APP
·
·
Channeled
APP
·
·
Thank you so much for sharing your feedback Ammar K.!

Channeled
APP
·
·
To create a formula that runs only once per unique company domain while considering all occurrences, you can use the Lookup Multiple Rows integration combined with conditional runs. Here's how: 1. Use the Lookup Multiple Rows integration to count occurrences of each domain in your table. 2. Create a new column for your desired formula. 3. In the new column's settings, set up a conditional run using an AI formula. 4. Use the AI to generate a formula that only runs when it's the first occurrence of a domain. For example: IF(ROW() = MIN(FILTER(ROW(), [Domain] = [Domain])), TRUE, FALSE) This approach ensures your formula runs only once per unique domain while still considering all occurrences in the table.
Source: AI Formulas + Conditional Runs [Clay 101] - Clay University
Ammar K.
·
·
Thanks for sharing. However I need a bit more clarification on the steps in the middle. I've ran the look up multiple rows function on the domain. Now I don't know how to plug that output in a formula.
Loading attachments
Channeled
APP
·
·
To use the output of the Lookup Multiple Rows function on the domain in a formula, you can create a new column with an AI-generated formula. Here's how: 1. Add a new column for your formula. 2. Use the AI formula generator to create a custom formula. 3. In your formula, reference the output of the Lookup Multiple Rows function. For example, you could create a formula that counts the occurrences of a domain or performs actions based on the lookup results. The AI can help you generate specific formulas tailored to your needs, such as: "Count the number of rows where {{Lookup Multiple Rows Output}} contains the current domain" Remember to adjust the formula based on your specific requirements and the structure of your lookup results.
Sources: Formula generator | Documentation | Clay University Formula generator | Documentation | Clay University
Ammar K.
·
·
https://app.clay.com/workspaces/463511/workbooks/wb_wU8iiwqpEvZM/tables/t_G7PNjBP9TTsG/views/gv_CxkDuNJWmzrc
Ammar K.
·
·
For the formula I have the fields:
Number of occurrences of the domain
The domain cell
And the output of the Lookup Multiple Rows function - will I reference all of it?
Please tell me exactly how to create that formula and what to input in the fields.
Loading attachments
LuisArturo
·
·
Hey there Ammar thanks for reaching out, made a loom explaining this for you. https://www.loom.com/share/891485b6e7664508b67e0a1eabbe41d4?sid=920a9a45-a576-46bd-8f35-b267921a010f Find Duplicate in table: https://www.loom.com/share/a39a4569d95244b7886026f3c70812c7?sid=a36ad597-1702-423a-8d23-38c47b7d220b
Ammar K.
·
·
Hi Luis, This is exactly what I was looking for! You made my day. Thank you 🙏
Channeled
APP
·
·
Channeled
APP
·
·
Thank you so much for sharing your feedback Ammar K.!