.png){kind=logo}
Referencing Fields from Another Table in AI Prompts
in an AI prompt on people table i want to / reference a field (normalized company name) in the connected Companies table but / is not showing it. Can i reference fields form another table?
in an AI prompt on people table i want to / reference a field (normalized company name) in the connected Companies table but / is not showing it. Can i reference fields form another table?
Yes, you can reference fields from the connected Companies table in an AI prompt on the People table. Our tables are automatically linked, allowing you to access company data within your People table. To reference a field like the normalized company name: 1. In your People table, find the column linked to the Companies table (it will have a Clay logo). 2. Click on a cell in this column to access company variables. 3. In the Prompt Editor, use the required field toggle to ensure the company data is present before running the prompt. This setup allows you to extract company attributes directly into your People table, making it easy to reference in AI prompts without additional enrichment costs.
2. that company variable didn't show. added that variable recently in company table, so how do I update the connected for people table?
To update the connected Companies table in the People table with a recently added variable, you need to rerun the lookup in your People table. Here's how: 1. Go to your People table. 2. Find the column that's linked to the Companies table (it will have a Clay logo). 3. Click on the header of this column. 4. Select "Rerun column" from the dropdown menu. This process will refresh the data and pull in the newly added variable from the Companies table. If you don't see the new values immediately, try force running through the whole column. Remember, this method ensures you're not using additional data credits while creating a more integrated dataset.
the variable itself in the companies table has a clay logo (its the Normalize Company Name enrichment). are variables with the clay logo support to be available via / in my people table AI prompt?
supposed*
Yes, variables with the Clay logo from the Companies table, including the Normalize Company Name enrichment, should be available in your People table AI prompt. Our tables are automatically linked, allowing you to access company data within your People table. To use these variables: 1. Find the column in your People table linked to the Companies table (it will have a Clay logo). 2. Click on a cell in this column to access company variables. 3. Use the required field toggle in the Prompt Editor to ensure the company data is present. If you've recently added new variables to the Companies table, remember to rerun the lookup column in your People table to sync the updated information.
Yes, variables with the Clay logo, including the Normalize Company Name enrichment, should be available in your People table AI prompt. Our tables are automatically linked, allowing you to access company data within your People table. To use these variables: 1. Find the column in your People table linked to the Companies table (it will have a Clay logo). 2. Click on a cell in this column to access company variables. 3. Use these variables in your AI prompt. This setup allows you to extract company attributes directly into your People table without additional enrichment costs. If you've recently added new variables to the Companies table, remember to rerun the lookup column in your People table to sync the updated information.
then its not working. step 2 doesnt show it in the variables. get me human support
under what plan is it possible to get live screenshare support from Clay? too many things are complex or dont work after watching your university courses and asking AI support. its impossible to learn and setup everything I need this way. what should take days will a take month at this pace if im lucky
your AI support is incorrect. only when i enriched Normalize Company Name in the same People table where im running the AI prompt did / finally see the column. your support is so poor and slow (human) and bad
Hey there Eugene thanks for reaching out, to clarify here the only way to reference a column inside of another table would be to use the Lookup Row in other table integration to connect the both tables together which would allow you to pull values from one table into the one the Lookup was ran from.
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.