Join the Community

Home
Directory
Events

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps

Community Guidelines

Powered by Tightknit

Struggling with Lookup Record Function in Clay Tables

·

·

Hi Team, I'm trying to use the lookup record function and struggling. The table I'm pulling from is this one: https://app.clay.com/workspaces/346206/tables/t_Hizjx8bwPS3Z/views/gv_RihWVvEgrkCG and it's the last populated column. I'm trying to import that to this table here: https://app.clay.com/workspaces/346206/tables/t_onZyWjJrouep/views/gv_BuRUCpddRec9 . Whatever I put in row value, it's coming up with a blank result.

5 comments

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
LuisArturo
·
·
Hey there Mark thanks for reaching out, this happening because when using the Lookup Row in Table integration, the "Target Column" and Row Value" filter should both have a matching data point in order to make a connection. This integration works by looking for any similar data points with which to make a connection between tables and since the Job Title and Company domain are not similar it is finding any matches. https://downloads.intercomcdn.com/i/o/1171521604/c9b69b8447884a97d4857b47/image.png?expires=1725651900&signature=a4fc863ddf4d6e9c816ed1d71cb9c3bdfed4cf4071ab2f4ced5c417968cf7e5d&req=dSEgF8x8nIdfXfMW1HO4zZBALzmCz%2BN6ZcHn9b837Zmvc%2Bgnk0PA%2BvJ8m2f%2B%0AB5%2B%2B%0A I switched the "Target Column" to look for company domain and ran the integration and it is now finding matches between both tables. https://downloads.intercomcdn.com/i/o/1171524429/aa1c14001afd9d30eea864ae/image.png?expires=1725651900&signature=7fef3122c496abceebd13eed1e44a52109dbef0cb7a043074042c77b48cc235c&req=dSEgF8x8mYVdUPMW1HO4zaiQGNa%2FLSaic3xFo8H%2F8D0X7Ejhp4%2B82Spljdas%0ALV3q%0A
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Mark S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.

Struggling with Lookup Record Function in Clay Tables | Clay