Need Help with Cross-Table Lookups in Clay's Formula Generator
Hi Clay S. I’m trying to match data from Find Jobs Table to my Find People table to my using Clay’s formula generator, but:
The slash-menu won’t let me insert columns from another table
My manual lookup("Find Jobs Table", "Company Domain", thisRow["Company Domain"], "Job LinkedIn URL") formulas return blank
I need to pull both the Job URL and Job Description into my people rows by matching on Company Domain respectively (theres 5 people per company)
Can you help me write the correct formula (or point out what I’m missing) so these cross‐table lookups work?
Loading attachments
