No, I already have the contacts in the table.
I need to lookup records that contain the matching job function -> limit it to 3 per company -> write to a new table
But I need to make sure I write 3 job titles per company, if I use the Job Title as a Filter Operator then it will only write 3 contacts for the entire table
helpful, but I'm confused on the "Lookup Single Row in Other Table"
How are we supposed to limit the contacts to 3 per company and use that as an input for the "write to table" column?
Thought it was "Lookup multiple Row in Other Table"
Hey Guys,
Is it possible to lookup records based on a column input?
I want to lookup multiple rows within a company but only lookup specific job titles.
My workflow looks like this:
#1 Identify the job function of a contact
#2 Identify the job function they're hiring for on LinkedIn
#3 Check a box if the function of the contact + the function they're hiring for matches
#4 Write 3 contacts with the matched function (from the company) to another table
Problem: Don't know how to lookup or write only 3 contacts to another table with the specific function (since the lookup multiple records) column searches for records randomly throughout the company
Any solutions?
Here's a video for context: https://www.loom.com/share/024adb3877234b09a274a0ba646ea6dd?sid=57bce2c7-b09f-4443-8eeb-b2b3157750ff
Hey Team,
Is it possible to lookup records based on a column input?
I want to lookup multiple rows within a company but only lookup specific job titles.
My workflow looks like this:
#1 Identify the job function of a contact
#2 Identify the job function they're hiring for on LinkedIn
#3 Check a box if the function of the contact + the function they're hiring for matches
#4 Write 3 contacts with the matched function (from the company) to another table
Problem: Don't know how to lookup or write only 3 contacts to another table with the specific function (since the lookup multiple records) column searches for records randomly throughout the company
Any solutions?
Here's a video for context: https://www.loom.com/share/024adb3877234b09a274a0ba646ea6dd?sid=57bce2c7-b09f-4443-8eeb-b2b3157750ff