How to Retrieve Company News in People Table Lookup? | Clay

How to Retrieve Company News in People Table Lookup?

This might be a very silly question, but when I do a lookup from a different company table to the people table. I wanted the company news. This data has multiple outputs in the company table. When I create a new column it doesnt show any news. Its not clickable. Would anybody know how to do this? Company table link: https://app.clay.com/workspaces/480573/tables/t_EDCznS4t7UY4/views/gv_5KY47fBTkHiH People Table Link: https://app.clay.com/workspaces/480573/tables/t_FApmmno6RHNy/views/gv_245RkDfRb8Fz

13 comments

Channeled
APP
·
·
To display company news from your company table in the people table: 1. Find the column with the Clay logo in your people table (usually the second column) - this is the "Lookup Single Row in Other Table" column that links to your company table. 2. Click on any cell in this lookup column. This will allow you to extract specific variables (including news) from your companies table into your people table. 3. When you click the cell, select the company news variable you want to display from the available company table fields.If you need to refresh the data later, you can always rerun the lookup column to get updated information from the company table. Sources: Find People [Clay 101] - Clay University Find People [Clay 101] - Clay University
Channeled
APP
·
·
Was that helpful?
Sahil S.
·
·
No
Channeled
APP
·
·
Looks like you're still looking for help. If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Sahil S.
·
·
Company table link: https://app.clay.com/workspaces/480573/tables/t_EDCznS4t7UY4/views/gv_5KY47fBTkHiH People Table Link: https://app.clay.com/workspaces/480573/tables/t_FApmmno6RHNy/views/gv_245RkDfRb8Fz
Bo (.
·
·
Hey Sale, No worries—your question isn’t silly at all, and I’m happy to help! The reason the value isn’t clickable is that a lookup brings in the fixed value you see in the row, not the full object. This means you’re only seeing the displayed value, not the underlying data. I noticed in your table that you’ve set things up to send only the title to the other table, curious what's the goal? Let me know.
🙌1
Sahil S.
·
·
Bo (., thanks for the support. Got it. Would you tell me where you saw that there is title being sent? I might have done it unknowingly.
Sahil S.
·
·
If you mean this column in the people table, then I wanted to push the recent news data to the people table from the company table. It also didnt work. It did not match with the domain as I wanted rather created new rows in the bottom of the list
Bo (.
·
·
I recorded this walkthrough video showing exactly how to set this up: https://cln.sh/9Q4Zx95f Let me know if you have any follow-up questions!
Sahil S.
·
·
Bo (. , That was super helpful. Thanks for the video. It definitely gets me the output I want out of it. Huge thanks for the detailed walkthrough.
Channeled
APP
·
·
Hi Sahil S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Sahil S.!
Channeled
APP
·
·
Thank you so much for sharing your feedback Sahil S.!