Add Regex Option to Filter List of Objects Column Configuration

Mathew I.

·

Is it possible to add a regex option to the "Filter List of Objects" column configuration?

17 comments

· Sorted by Oldest

Bo (.
·
·
Not at the moment, but what exactly are you trying to do? That way I can send this to our team! :)
Mathew I.
·
·
Filtering a list of people by title -- can do it with comma separated values but gets excessive when filtering for a bunch of titles
Mathew I.
·
·
For example, CEO, Chief Executive Officer, founder, co-founder, COO, etc.
Bo (.
·
·
And what are you trying to filter this for? If it's to extract the data, you can use the extract values from data with custom regex ! https://downloads.intercomcdn.com/i/o/w28k1kwz/1261215214/3f39cca7a5ff505f43985aff50ac/CleanShot+2024-11-21+at+_34bTddRMUH%402x.png?expires=1732220100&signature=d8c48b23c2c3a7c56e8f0bd5930c292a82f7e44ae7df2529d26efd084d26a588&req=dSIhF8t%2FmINeXfMW1HO4zT84mwUZBnSuPibWjvj7x3UJXfZjID7PBvC5QKa6%0AlRwi%0A
Mathew I.
·
·
I'm trying to filter a list of objects to only those objects where title = a specific regex Getting a runtime error using "extract values from data"
Loading attachments
Bo (.
·
·
Hey Mathew! Sorry that's happening. When you reach out, could you send the table URL instead of photos? Makes it way easier for us to check exactly where things are going wrong! 😊 Mind sharing the link to your table so I can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1732221000&signature=754c06b364eba247004d6da93bbd38618af1ef9bb20bb85647e5c6668e8da76c&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSn%2BBJYW2BKsam%2FhVPv1Bg%3D%3D%0A
Mathew I.
·
·
Np: https://app.clay.com/workspaces/423342/workbooks/wb_2yzrNp8cphiU/tables/t_joDRMAex4v39/views/gv_xD76GqtETeAK
Mathew I.
·
·
The goal here is starting with companies:
Run Clay's Find People
Filter Clay's People for target titles
If no people with target titles, run "Proxycurl Find Contacts"
Write unique values (i.e. matched contacts from either Clay's Find People or Proxycurls Find People) to a new table
Mathew I.
·
·
I got it working, but feels like there's a less duplicative way to do this
Bo (.
·
·
So just to confirm, why do you want to use the list value? So only unique are being sent right? In that case, why not only activating auto-dedupe in that Contact page? https://downloads.intercomcdn.com/i/o/w28k1kwz/1261258768/3393f5ae7ebd3a9a2dd5d167a458/CleanShot+2024-11-21+at+_445i9nenkE%402x.png?expires=1732221900&signature=f1d7162b48f3adb20dc866b7996b1e80179d4fd2ab836bff6338e1d82552ff83&req=dSIhF8t7lYZZUfMW1HO4zZDGAT1t0D3%2FK%2F1hSLSA2shOl0W9RDmMfoDrFRCI%0A3t4F%0A
Mathew I.
·
·
The auto-dedup is helpful -- thank you. The original question was focused on the "Filter Clay's People for target titles" step Let's say I have 10 contacts, with all different titles, and I only want execs. I want to filter that list of objects, for only the objects where title = "my regex" and end with a filtered list of objects
Mathew I.
·
·
You'll see I tried to accomplish that in the "Filter Clay's Find People" column, but got a runtime error
Loading attachments
Bo (.
·
·
I get what you're trying to do with the exec title filtering! Right now, the best workarounds are either: 1. Use our current filter options 2. Send to a new table and filter/score the values there to remove non-matches Not ideal, I know - but I'll definitely pass this feedback to our team about making the "Filter List of Objects" step more flexible with Regex! Thanks for bringing this up 😊 Let me know if you need help setting up either of those workarounds!
Mathew I.
·
·
Thanks Bo -- I'm good for now! one more (non-related) question: is there a way to interact with Clay externally via API? Or only via webhooks?
Bo (.
·
·
Only via webhooks for now. We're currently working on being able to interact externally via APIs with our enterprise clients, but it's not available for others yet since it's too early! Webhooks works great tho. Send to webhooks -> Enrich -> Send back with the HTTP API ! :)