Fixing Company Size Data Pull in Find People Table

Jonathan M. · 2025-06-12T10:42:57.098Z

How do I pull company size through to the Find People table from the Find Company table - it pulls through in this format: df4ca4d2-7a26-4e89-a187-fbe333928255 rather than 11-50 employees

Fixing Company Size Data Pull in Find People Table | Clay

8 comments

· Sorted by Oldest

Channeled
APP
·
·
When you see an ID code instead of the company size, you need to add the actual company size as a column. Click on a cell in the company table reference column, hover over "Company Size, " and select "Add as column." This will pull the readable format (like "11-50 employees") into your Find People table. Clay automatically links your Find Companies table to your Find People table through a lookup column that refreshes when changes are made to the company data.
Sources: Find People [Clay 101] - Clay University Find People [Clay 101] - Clay University Write to Table [Clay 101] - Clay University Write to Table [Clay 101] - Clay University
Jonathan M.
·
·
What format should it be? Text ?
Channeled
APP
·
·
The company size should be in Text format. To properly pull the company size from your Find Companies table to your Find People table, click on a cell in the "Company" column, hover over "Company Size, " and select "Add as column." This will add the readable format (like "11-50 employees") as a text column in your Find People table.
Source: Table columns | Documentation | Clay University
Jonathan M.
·
·
It doesn't seem to be pulling through to the Find People
Jonathan M.
·
·
https://app.clay.com/workspaces/573790/workbooks/wb_0swalpbG8oV9kHsD6Kj/tables/t_0swb12c9QH4MtUtrofQ/views/gv_0swb12dBENDnQkUg6UH
Channeled
APP
·
·
Jonathan - Sorry for this, it looks like we've got a bug on our hands. I've escalated this to our engineering team to help look into it. We'll follow up here as soon as we know more!
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 Clay Support.
Jonathan M.
·
·
ANy update on when this will be sorted?

Channeled
APP
·
·
When you see an ID code instead of the company size, you need to add the actual company size as a column. Click on a cell in the company table reference column, hover over "Company Size, " and select "Add as column." This will pull the readable format (like "11-50 employees") into your Find People table. Clay automatically links your Find Companies table to your Find People table through a lookup column that refreshes when changes are made to the company data.
Sources: Find People [Clay 101] - Clay University Find People [Clay 101] - Clay University Write to Table [Clay 101] - Clay University Write to Table [Clay 101] - Clay University
Jonathan M.
·
·
What format should it be? Text ?
Channeled
APP
·
·
The company size should be in Text format. To properly pull the company size from your Find Companies table to your Find People table, click on a cell in the "Company" column, hover over "Company Size, " and select "Add as column." This will add the readable format (like "11-50 employees") as a text column in your Find People table.
Source: Table columns | Documentation | Clay University
Jonathan M.
·
·
It doesn't seem to be pulling through to the Find People
Jonathan M.
·
·
https://app.clay.com/workspaces/573790/workbooks/wb_0swalpbG8oV9kHsD6Kj/tables/t_0swb12c9QH4MtUtrofQ/views/gv_0swb12dBENDnQkUg6UH
Channeled
APP
·
·
Jonathan - Sorry for this, it looks like we've got a bug on our hands. I've escalated this to our engineering team to help look into it. We'll follow up here as soon as we know more!
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 Clay Support.
Jonathan M.
·
·
ANy update on when this will be sorted?