Request for Formula-Based Filtering in Object Lists

Mathew Iacone · 2025-01-06 17:32:00.843311+00

Really need the ability to filter lists of objects using a formula -- using the enrichment is brutal Not sure why there isn't a column type "list" that can handle that

Request for Formula-Based Filtering in Object Lists | Clay

13 comments

· Sorted by Oldest

owen (Clay)
·
·
Hey Mathew, thanks for reaching out and sorry to hear this has been a bit brutal. When you say "filter lists of objects using a formula" are you referring to this menu here? Also would love to hear a bit about what you're trying to filter for in this example so I can share this with our team. :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1323388997/242096fdf472c3f3b36a7e0350fa/CleanShot+2025-01-06+at+13_28_46%402x.png?expires=1736190000&signature=88bab5deda2fe2c1aa9538a3cb2e8cd8c51d3300b0e698772d66c6f0c3fab2d6&req=dSMlFcp2lYhWXvMW1HO4zYSdauj6Ac5RL74sMRndN5%2FMQZ8GWw%2B4Z5SIbyg6%0AHPoo%0A
Mathew Iacone
·
·
No I'm talking about the "Filter list of objects" enrichment
Mathew Iacone
·
·
You shouldn't need an enrichment to filter a list of objects -- it's much easier to do it via formula
Mathew Iacone
·
·
For example, I'm fetching decision makers. I want to run the following filter:
If there is 1 contact in the list, return the contact
If there is 1+ contacts in the list, return the first contact where title does not equal CTO / Chief Technology Officer
Mathew Iacone
·
·
If I could make a formula to filter the objects this would be easy -- almost impossible using the enrichment
owen (Clay)
·
·
Got it, makes sense. Curious, in your example where is the association made between the job title and object? Is it within the same list? or somewhere else?
Mathew Iacone
·
·
What do you mean exactly? Title is a property on the objects in the list
owen (Clay)
·
·
Ahh okay cool, do you mind sharing the URL to the table over would love to take a closer look?
Mathew Iacone
·
·
https://app.clay.com/workspaces/439929/workbooks/wb_iJ5GmFCofPKA/tables/t_DnGYbHBP4ajh/views/gv_D2niJJoij7gc
Mathew Iacone
·
·
I'm filtering the list returned from the "Clay Find Contacts" enrichment
Mathew Iacone
·
·
Right now I need 2 separate enrichment columns (not ideal) and have no way to run the filter I mentioned above
Bo (Clay)
·
·
Hey, thanks for reaching out Matthew - I hear you, let me show you what you can do here instead: https://cln.sh/MM7DSv86 Summary Using JSON.parse({{Input}}) inside of a Write to Other Table (make sure the data you add has [before and after] and add it in the List Input) to then parse all the values that fit your criteria inside of a new table as individual columns.
👍1
Channeled
APP
·
·
Hi Mathew Iacone! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

owen (Clay)
·
·
Hey Mathew, thanks for reaching out and sorry to hear this has been a bit brutal. When you say "filter lists of objects using a formula" are you referring to this menu here? Also would love to hear a bit about what you're trying to filter for in this example so I can share this with our team. :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1323388997/242096fdf472c3f3b36a7e0350fa/CleanShot+2025-01-06+at+13_28_46%402x.png?expires=1736190000&signature=88bab5deda2fe2c1aa9538a3cb2e8cd8c51d3300b0e698772d66c6f0c3fab2d6&req=dSMlFcp2lYhWXvMW1HO4zYSdauj6Ac5RL74sMRndN5%2FMQZ8GWw%2B4Z5SIbyg6%0AHPoo%0A
Mathew Iacone
·
·
No I'm talking about the "Filter list of objects" enrichment
Mathew Iacone
·
·
You shouldn't need an enrichment to filter a list of objects -- it's much easier to do it via formula
Mathew Iacone
·
·
For example, I'm fetching decision makers. I want to run the following filter:
If there is 1 contact in the list, return the contact
If there is 1+ contacts in the list, return the first contact where title does not equal CTO / Chief Technology Officer
Mathew Iacone
·
·
If I could make a formula to filter the objects this would be easy -- almost impossible using the enrichment
owen (Clay)
·
·
Got it, makes sense. Curious, in your example where is the association made between the job title and object? Is it within the same list? or somewhere else?
Mathew Iacone
·
·
What do you mean exactly? Title is a property on the objects in the list
owen (Clay)
·
·
Ahh okay cool, do you mind sharing the URL to the table over would love to take a closer look?
Mathew Iacone
·
·
https://app.clay.com/workspaces/439929/workbooks/wb_iJ5GmFCofPKA/tables/t_DnGYbHBP4ajh/views/gv_D2niJJoij7gc
Mathew Iacone
·
·
I'm filtering the list returned from the "Clay Find Contacts" enrichment
Mathew Iacone
·
·
Right now I need 2 separate enrichment columns (not ideal) and have no way to run the filter I mentioned above
Bo (Clay)
·
·
Hey, thanks for reaching out Matthew - I hear you, let me show you what you can do here instead: https://cln.sh/MM7DSv86 Summary Using JSON.parse({{Input}}) inside of a Write to Other Table (make sure the data you add has [before and after] and add it in the List Input) to then parse all the values that fit your criteria inside of a new table as individual columns.
👍1
Channeled
APP
·
·
Hi Mathew Iacone! This thread was recently closed by our Support team. If you have a moment, please share your feedback: