Is there a way to do something like "show only 3 of this exact value" For example if we have 5 data points with the same value (e.g. website), is there a way to filter on the whole table how many per unique value should be shown?
Yes, you can filter a table to show a specific number of data points per unique value. Here's how you can do it: 1. Use the Lookup Multiple Rows function to identify duplicate values. 2. Create a formula column that assigns a number to each occurrence of a value. 3. Use table filters to show only the rows with the desired occurrence numbers. For example, to show only 3 instances of each website: 1. Set up the Lookup Multiple Rows for the website column. 2. Create a formula that returns 1, 2, 3, etc. based on the occurrence order. 3. Apply a filter to show only rows where the formula result is 1, 2, or 3. This approach allows you to control how many instances of each unique value are displayed.
Not really what I was getting at. Lets say if there are also 10 instances of the same value, I would still like the possibility of filtering for 3 only (or any random number, similar to how we can do it with hte job search)
If this doesn't exist yet, I'd like to suggest it as a feature, for GTM particularly it will be incredibly useful, let's say you want to reach out to only 3 people from the same company, but have more than 3 in the company table, this way you could do mass selections way easier.
Hey Lazar,
Absolutely — Here’s a quick tutorial and a formula that can help:
{{Unique ID}}?({{Lookup Multiple Rows in Other Table}}?.records?.findIndex(r=> r['Unique ID']?.toString()==={{Unique ID}}?.toString())> -1?{{Lookup Multiple Rows in Other Table}}?.records?.findIndex(r=> r['Unique ID']?.toString()==={{Unique ID}}?.toString())+1:2):2
This helps track the order of each person within a group, so you can apply a condition like “only reach out if the number is less than 3
Let me know if you want help setting it up!
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.
I have tried to replicate but running into issues. This is where I am:
Generating a random number for each row ✅
Utilizing the Lookup Multiple Rows in Other Table to find occurrences ✅
Using this prompt to label the occurrence correctly ❌ :
Only run if /Random 10-Digit Number is not empty, then return a number label depending on which number of occurrences any of the "Random 10-Digit Number" fields from /records match /Random 10-Digit Number. For example, if the first value of "Random 10-Digit Number" you find from the array is true, then return 1, if it's the second value then return 2 and so on.
Attached are a few screenshots of the formula generator and the output, could someone let me know what I am doing wrong 🙂
UPDATE: Found why the Formula wasn't labeling the occurrence correctly (adding this hear just incase others come across a similar issue) I needed to force run the lookup multiple rows in other table column so the name "Unique ID" or "random 10-digit number" was being searched properly within the formula. Remember the lookup multiple rows function is not dynamic and wont pick up name changes after its run!
.png){kind=logo}
