Help Needed: Referencing Columns from Different Tables in Formulas

Afsha H.

Facing an issue referencing a column from an a different table in my formula. Any suggestions ?

36 comments

Channeled
APP
·
·
To reference columns from a different table in your formula, you can use one of these methods: 1. Lookup Actions: • Use Lookup Multiple Rows in Other Table • Use Lookup Single Row in Other Table These lookup actions allow you to reference data from any table in your formulas. Important note: After creating new columns in the source table, you'll need to re-run the company row in the people table to see the new values in your formula. You may need to force run through the whole column to see the updated values.
Source: Write to Other Table | Documentation | Clay University
Afsha H.
·
·
finally worked
Channeled
APP
·
·
Thank you so much for sharing your feedback Afsha H.!
Afsha H.
·
·
i have another question for you. I have a column check_domain in a table and everytime a domain is present i want to add 5 points. eg if a domain is present 1 time it will return 5 if 2 times it should return 10 points. My formula is returning only 5 points even if domain is present 5 times
Channeled
APP
·
·
To create a scoring formula that adds 5 points for each domain occurrence, you can follow these steps: 1. Add a new Formula column to your table 2. Use the Count Occurrences feature to count the domains, then multiply the result by 5. This will give you: • 5 points for 1 occurrence • 10 points for 2 occurrences • 15 points for 3 occurrences, and so on The formula should count the occurrences in your check_domain column and multiply that count by 5 to calculate the total points.
Sources: Lead scoring overview | Documentation | Clay University Count Occurrences of Items with Clay
Afsha H.
·
·
count occurences is not giving me a total occurence its giving only 1
Channeled
APP
·
·
To properly count all occurrences in your check_domain column, you should use the "Lookup Multiple Rows" integration instead of the Count Occurrences feature. The Lookup Multiple Rows allows you to scan a column for matching values and count how many cells exist with that value. For the Count Occurrences feature to work correctly, you need to ensure: 1. Your input is properly formatted (either as text or array) 2. You've specified the correct separator if using text input 3. You've set an appropriate limit (default is 99) If you're still having issues, try refreshing your browser using Cmd/Ctrl + Shift + R to resolve any formula evaluation problems.
Source: Count Occurrences of Items with Clay
Afsha H.
·
·
not able to use the lookup multiple rows in the same table its working only for a different table
Channeled
APP
·
·
You can use the Lookup Multiple Rows feature to count occurrences within the same table. The feature allows you to scan a column for matching values and count how many cells exist with that value, and this works both within the same table or on a separate one. Keep in mind that when using Lookup Multiple Rows, you can only use one column at a time as a filter - you cannot apply multiple columns as filtering criteria. To count occurrences in your check_domain column: 1. Add a Lookup Multiple Rows column 2. Select your current table as the "Table to Search" 3. Choose your check_domain column as the "Target Column" 4. Set your filter operator and row value to match the domain you want to count 5. The result will show all matching rows, which you can then count to get the total occurrences
Afsha H.
·
·
i am writing to another table and entering columns for writing why is it saying enter valid lists
Channeled
APP
·
·
The "enter valid lists" error typically occurs when the values you're trying to write aren't properly formatted as a list. To resolve this issue: 1. Add the list through the "Other data from this table" section When setting up your Write to Other Table: 1. First select your Clay account 2. Choose your destination table 3. For column mapping: • If writing individual values, enter "/" to skip list selection • If writing lists, select the column containing your lists 4. Map your columns correctly from source to destination You can watch a detailed video tutorial on how to properly format and write lists at: https://cln.sh/DpHTlNt0
Source: Write to Other Table | Documentation | Clay University
Afsha H.
·
·
for lookup multiple rows it is not giving my current table in the dropdown to select from
Channeled
APP
·
·
The Lookup Multiple Rows feature can actually be used within the same table - you can scan and count values within your current table. If you're not seeing your current table in the dropdown, try refreshing your browser as this may be a temporary display issue. When using Lookup Multiple Rows, you should be able to: 1. Select your current table as the "Table to Search" 2. Choose your target column 3. Set your filter operator and row value
Source: Lookup Rows | Documentation | Clay University
Afsha H.
·
·
in table to search i am not getting my current table as an option
Channeled
APP
·
·
The Lookup Multiple Rows feature should allow you to scan and count values within your current table. If you're not seeing your current table in the dropdown, this is likely a display issue since the feature is designed to work both within the same table and across different tables. Try these steps to resolve the issue: 1. Refresh your browser 2. Check if you can see other tables in the dropdown 3. If the issue persists, you may want to explicitly request human support in this conversation for further troubleshooting.
Afsha H.
·
·
i have used write to table but it is not writing the data its blank
Afsha H.
·
·
only creating rows
Afsha H.
·
·
need to talk to human
Bo (.
·
·
Hi Afsha
Could you send me the link to your table so I can take a look? When the table is blank but creating rows, it's usually because the data wasn't properly mapped.
I recommend checking these guides for help: https://www.clay.com/university/lesson/write-to-table-clay-101 http://www.clay.com/university/lesson/write-to-table-integration-overview
(52 kB)
Afsha H.
·
·
https://app.clay.com/workspaces/354424/workbooks/wb_DrPn8tdSzkWt/tables/t_6iSzBAuWWdYG/views/gv_N7jZpDA2onoj
Afsha H.
·
·
this is the table
Afsha H.
·
·
i jus want the total times a domain is appearing in check_domain column
Afsha H.
·
·
if domain is present 1 time i want to return 5 if 2 times i want to return 10 thats just a simple thing i want to do
Afsha H.
·
·
😞
Owen C.
·
·
Hey Afsha, thanks for reaching out. Totally hear you, very easy to do and you're already on the right track with the lookup multiple rows column. Mapping out the total number of records found from this column gives us the count of each domain per table, then we can create a formula like what is shown in the second image to have scores based on this count. Check it out in this table and let me know if this is what you're looking for! Table
(446 kB)
(306 kB)
Afsha H.
·
·
The lookup multiple rows column itself is not giving the right result. If you see the table I shared even if domain is present 3 times it’s saying 1
Afsha H.
·
·
That’s the problem
Afsha H.
·
·
The formula for multiplying is fairly simple for me too.
Afsha H.
·
·
But the lookup multiple rows is not returning the right number of times the domain is present in the column
Owen C.
·
·
Got it, which domain specifically are you referring to? Have a feeling if you re-run the lookup multiple rows column it should update and be accurate.
Afsha H.
·
·
Hey Owen it worked thanks
Owen C.
·
·
Of course, feel free to reach out with any other questions or concerns! :)
🙌1
Afsha H.
·
·
my clay credits were 93000 and now i see only 63000 credits i want to know where my credits were used. i hardly used anything
Daniela D.
·
·
Hey Afsha! Thanks for reaching out. Happy to help✨. I generated a quick report showing credit spend in your workspace. Let me know if you have any questions!
Channeled
APP
·
·
Afsha H.
·
·
Thank you 🙏