How to Add a Conditional Column Based on No Companies Found Text Display | Clay

How to Add a Conditional Column Based on No Companies Found Text Display

if I want another column to run only when there is text that displays "No Companies Found" in this column, is there a way to do that, without looking for an empty ID value - I don't want the new column to run unless the Lookup Company has run for the row.

✅1

32 comments

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Augustin R.
·
·
Have you tried adding a Conditional Formula in the run settings?
Nick S.
·
·
or if theres a way to exclude running a new column for rows that have "run condition not met" that would be great
Nick S.
·
·
yes I've tried, can't figure out a way to do it
Nick S.
·
·
https://app.clay.com/workspaces/207112/tables/t_8ONS8hJBtbHF/views/gv_v9l4RjsMIPZU It;s the enrich linkedin company column
Nick S.
·
·
I keep getting the "infinite loop" error
Clay Team
APP
·
·
You can do the following as a workaround, filter like this
3d3e6db7-52b1-4afc-bb29-dae43b1e3b1e.png(176 kB)
Clay Team
APP
·
·
download as a csv
Clay Team
APP
·
·
upload again in a new table
Clay Team
APP
·
·
and perform a lookup: The Lookup Record integration can help with that. Here's a video and our docs page for Lookup Record!
Clay Team
APP
·
·
A bit tedious but this will fix the issue
Nick S.
·
·
thanks
Clay Team
APP
·
·
I tried other things like formulas but wasn't detecting the fields
Nick S.
·
·
https://app.clay.com/workspaces/207112/tables/t_FOsoEHuQCF4Q/views/gv_cHw3v66dn7Mo How do I create a lookup based on the apollo ID written from another table and populate all the columns that would have been updated using the "enrich person" column on this table
Nick S.
·
·
or do I have to write over everything that I need, it's just that there might be times when I don't write over something that I later need in my person table, so better if possible to populate the table with a lookup from the apollo id....

Nick S.

Cannot read property 'length' of undefined

Clay Team
APP
·
·
Let me check
:thumbsup_all:1
Clay Team
APP
·
·
Ok I can see that you adeed a row limit of 50, and are pulling data from 4 different tables
Nick S.
·
·
I only wrote over the find apollo contacts to the person table from the Find Tech PPL column for now to test things
Nick S.
·
·
the ID numbers in my people column have been checked against all the 4 columns I have for finding difference personas and I get the error from all of them (incase I mapped incorrectly I checked this)
Clay Team
APP
·
·
still checking this
:thumbsup_all:1
Clay Team
APP
·
·
I have creted this walktrough video with your tables: https://www.loom.com/share/de24534def1f492fa5a55e9b16187ef6
👀1
Clay Team
APP
·
·
1. unlimit you rowas in the table 2. filter the Lookup Company column to show the values you want 3. export as csv 4.import back as new table 5. go to the original table and create the lookup as described in the video
Nick S.
·
·
thank you, you solved the first issue I was having
Nick S.
·
·
But I still need help with this one: https://app.clay.com/workspaces/207112/tables/t_FOsoEHuQCF4Q/views/gv_cHw3v66dn7Mo How do I create a lookup based on the apollo ID written from another table and populate all the columns that would have been updated using the "enrich person" column on this table or do I have to write over everything that I need, it's just that there might be times when I don't write over something that I later need in my person table, so better if possible to populate the table with a lookup from the apollo id....
Nick S.
·
·
Cannot read property 'length' of undefined
this is the error I'm getting
Nick S.
·
·
☝️ and that is what I'm trying to achieve with the lookup, I tried both filters "contains" and "equals"
Clay Team
APP
·
·
let me check
Nick S.
·
·
adding this to the thread: how to lookup apollo enriched records from another table using Apollo's ID? I've tried both the equals and contains filters and they both throw errors. Equals error: Cannot read property 'length' of undefined Contains error: Cannot read property 'filter' of undefined
Clay Team
APP
·
·
can you give me the two tables?
Clay Team
APP
·
·
ill try to replicate it
Nick S.
·
·
I think I've solved it now, you can't use apollo ID to lookup people found with the apollo enrichment column in another table