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?

Channeled
APP
·
·
To pull Job URL and Job Description from your Find Jobs Table into your Find People table, you can use the LOOKUP function in Clay's formula generator. Here's how: 1. In your Find People table, add a new column and select "Formula". 2. In the AI Formula Generator, type your instruction. For example: "Lookup Job URL from Find Jobs Table where Company Domain matches this row's Company Domain" 3. Click "Generate Formula". 4. Review the generated formula, which should look similar to: LOOKUP("Find Jobs Table", "Company Domain", thisRow["Company Domain"], "Job LinkedIn URL") 5. Click "Save Formula". Repeat these steps for Job Description, changing the last parameter in the LOOKUP function. If you need more help, you can request human assistance by clicking on "Talk to a person".
Sources: Referencing dynamic data from other columns | Documentation | Clay University Formula generator | Documentation | Clay University Formula generator | Documentation | Clay University
Bo (.
·
·
Hey! Thanks for sharing - It's actually not with Formula but a Lookup enrichment. Here’s a video that walks through exactly how to do that step-by-step: https://www.loom.com/share/ad767e3be9914d19a2f6647efe4dfa85?sid=c8b78c32-9bc1-4501-8124-d6c70d2218cf Let me know if you still hit any issues or if something’s unclear.
Channeled
APP
·
·

Need Help with Cross-Table Lookups in Clay's Formula Generator | Clay