is there a good way to in a existing workbook (with lets say job postings), find people at those companies with different locations since each ob may be in a different place? for example not every job posting at a list of target accounts may be in the same geography (city, state, country, etc.) im using the find people at company enrichment but it isnt working well 😞 and im not sure how to use it best
Yeah, ai. add a new column, give it all parameters and tell it to return you the desired outcomes. I.e. if you find a location "Chicago" return the name of the person in the location.
ugh i dont want to use ai for this tho lol, this should be like product funcionality lol
fair though
totally fair shout
({{Lookup Multiple Rows in Other Table}}?.records?.[0]?.Title) ({{Lookup Multiple Rows in Other Table}}?.records?.[1]?.Title) etc Since i pull these from the lookup multiple rows, this is how each of those fields look
what's your end goal btw? i might be able to write the prompt for you and you can just plug it in, if i understand your goal and output you expect
read the bottom part of this thread if you dont mind - im trying to get a find people specific to location and title for each row https://clayrunhq.slack.com/archives/C025KSBLPGX/p1760558888644499
{{Find people at company}}?.records?.[0]?.Title) {{Find people at company}}?.records?.[1]?.Title) up to [10] then also give {{Find people at company}}?.records?.[0]?.Location) (make sure the location field is called Location) up to [10] and then just prompt the AI to search for Barcelona and Software engineer, and if it finds them somewhere in the fields to return the title and the name of the person and their location.
I can jump on a 10 min call with you if you want to help you too
