I have a problem with a lot of columns not running, see this loom please: https://www.loom.com/share/680742d796e248cf8eb18bc75574f852 clay table: https://app.clay.com/workspaces/267014/tables/t_DnePMyVCKaXT/views/gv_z8i42iWqiXR6
Here's how to resolve columns not running in your Clay table: 1. First, try performing a hard refresh: • Windows: Press Ctrl + Shift + R • Mac: Press Cmd + Shift + R 2. If columns are still not running, check for these potential issues: • Ensure you haven't exceeded the column limits: tables can have up to 70 columns total, with up to 30 being action or integration columns (40 if using a waterfall) • Review any dependencies between columns and remove run conditions that might be causing conflicts 3. You can try different run options to restart the columns: • Right-click the column and select "Play" > "Run All Rows that haven't run or have errors" • Or use "Force Run All Rows" if needed Sources: Run Options Table columns overview | Documentation | Clay University
Is that what you were looking for?
Didn't work for me
Sorry it didn't work. You can rephrase your question or talk to our team.
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!
already dropped in the initial message :))
Hi Amir, thanks for reaching out! Do you mind sending the link (url) to the table so we can take a look? https://downloads.intercomcdn.com/i/o/w28k1kwz/1347419411/65baf32e1d2a789ffba395c6d35c/CleanShot+2025-01-22+at+_42I1FzxXHf%402x.png?expires=1738957500&signature=da12da1ccfa9996ba5a549a385f1c8b18fc4918c7a241eaeafd501735d77f004&req=dSMjEc1%2FlIVeWPMW1HO4zVws4pk%2BCFOtgvYjA82bedDjfQ%3D%3D%0A
Just saw your loom, I'm curious if one of the input columns for your formula has stale data which is why your formula column is not loading correctly
happens in this table: https://app.clay.com/workspaces/267014/tables/t_6HkPxdAmFpmD/views/gv_rZhQ7Wb6eJTT
are you here? 🙂
Hey Amir, it looks like the formula columns for master column first name, master column last name, and so forth are not loading because there is an error with your HTTP API column so the API Status Validation checkbox column is not true
It looks like there is an error in the HTTP API (2) column when the email 2 formula is empty. https://downloads.intercomcdn.com/i/o/w28k1kwz/1370555058/0fd6768ebce9d787ea7a47173f13/CleanShot+2025-02-07+at+16_13_22%402x.png?expires=1738964700&signature=4e81256f5b7892bd36ed4cc5fa71c2a194a25a3860b282ec84b916c2ee9ef444&req=dSMgFsx7mIFaUfMW1HO4za%2F3q1jXP8QN2Vr5TcgvM8tvFNooTqTj0QNlJ%2BVy%0AE9uE%0A
It's still not working
would it be possible hopping on a call or similar?
Hey, thanks for reaching out Amir - Can you clarify which row you see it's not working?
yes
will film you a quick loom
pls help here
i still really need help with this as clients are waiting
what should i do?
Hi Amir, thank you for reaching out. The reason you might be facing this issue is because formulas are not as effective as "merge columns". For this case, we should use a merge function. Say I want to merge two columns, Column 1 and Column 2. To do so, go to "Add Column">"Merge Columns", as shown below: https://downloads.intercomcdn.com/i/o/w28k1kwz/1274858099/70b3fc9f180ad709e7b906e47f6f/CleanShot%2B2024-12-03%2Bat%2B09_05_28-402x.png?expires=1739204100&signature=a0f5e6dd9c171979255afcd09788f74f1b44fcb8279cbda02da7e37cfbeeaaf0&req=dSIgEsF7lYFWUPMW1HO4zYn1Xx5%2BEybhEc1XL1bgYv0%2Fxw%3D%3D%0A Then, in the menu that appears, press on the blue "Use AI" button in the "First Try" prompt box. https://downloads.intercomcdn.com/i/o/w28k1kwz/1274858098/8f41dba83904bcdc99363c2eb28f/CleanShot%2B2024-12-03%2Bat%2B09_06_53-402x.png?expires=1739204100&signature=266c65488a8624605b61b4fdc655032110a51ceb0eca916a85187ea8a84e8403&req=dSIgEsF7lYFWUfMW1HO4zZ6wwU8oiL3CRFlRf%2FQ55AEO1A%3D%3D%0A In the new menu, under "Describe the formula you want", hit "/" and select the column you want to input. In this case, my column is called "Column 1". In your case, treat this as a formula and say "return /email_1 if status=valid". Then, press on "Generate Formula". If what you see matches the content of your first column, then press on "output it correct. Save formula". https://downloads.intercomcdn.com/i/o/w28k1kwz/1274858101/99951f8aa226f96eb6a5e21bc429/CleanShot%2B2024-12-03%2Bat%2B09_07_10-402x.png?expires=1739204100&signature=cb290e79d7f84bde2a1d624c1f56d1aff46e7146955d32db3e25cdfc45f32380&req=dSIgEsF7lYBfWPMW1HO4zWr2VG7605S%2FaqXkMy%2FkC%2FMbiQ%3D%3D%0A Repeat the same process for the other columns, but now under the "Then try" box . In your case, treat this as a formula and say "return /email_2 if status=valid". If you have more than 2 columns you want to merge, press on "Add Input". The menu should then look as follows once you are done. https://downloads.intercomcdn.com/i/o/w28k1kwz/1274858096/460414aa1d46bce2c81bf0778687/CleanShot%2B2024-12-03%2Bat%2B09_07_27-402x.png?expires=1739204100&signature=f236d3347f3333d3ddb72524ec66f90d357966f882fe06a48af42e7b82b3aa4d&req=dSIgEsF7lYFWX%2FMW1HO4zXu0u7ylJG%2Fo0RA79%2BQ%2F5wHeXw%3D%3D%0A Then, press on "Save settings" to merge the columns. Let me know if this helps.
i tried, but still not seems to be working for me
filmed you this loom over my frustrations
what should i do from here / can you tell me what i am doing wrong?
Heyy? sorry for spamming but really need this to get fixed
Hey sorry, I am back. Is the issue only related to the second part of the merge column? The one checking true and false?
yea the first part (the upper one) is working
like the "first try" here
but the second part does not?
Could you try using "is" nstead of "equal" in the command, just to see if that is throwing it off?
okay
not working
Amir - Do you mind sending the link (url) to the table so we can take a look? I am unsure which of the tables contains this function https://downloads.intercomcdn.com/i/o/w28k1kwz/1347419411/65baf32e1d2a789ffba395c6d35c/CleanShot+2025-01-22+at+_42I1FzxXHf%402x.png?expires=1739216700&signature=2cb0bab0f7503afa60b553cb354773ac14a4887f6e3095eef138e9c838ac8f02&req=dSMjEc1%2FlIVeWPMW1HO4zVws4pg1DFKvgvYjA82bedARCg%3D%3D%0A
Hi Amir, the reason for this is that every time API status check is "True" first name 2 is blank, if you look at the rows closely and in the screenshot below, you should be able to see this. https://downloads.intercomcdn.com/i/o/w28k1kwz/1374170366/3e4f6eb926480bd3a05d62a6d5a1/CleanShot+2025-02-10+at+14_15_20%402x.png?expires=1739216700&signature=1bfec6dc41fad6b306c5cf4c4b4ac64a45d35ae0bd030ab6a9b5f838d69b506a&req=dSMgEsh5nYJZX%2FMW1HO4zUsWaZlvkNN6fsR3hUQuPtKF6sGi%2BvCKEljoaToW%0AggAr%0A
Perhaps you are trying to add a different name column?
wait sry
it's the number 2 that's working
the "then try"
first name 2 is getting added all the time
but not first name 1
example here with lead 9
heyy?
hey, sorry I am having a look at this as we speak and think we might be encountering a bug, but running tests to ensure it is one before I send it to the engineering team
Okay! Thank you
Hi Amir, in "merged column Final" you should see I was able to fix the issue. Let me know if that is what you are looking for!
what do you mean?
it still doesn't output in row 9
(Ignore the lighter tone, it seems to be a UI issue on my end)
weird. that's not how it looks on my end
Hi Amir, check "merged column Final"
oh yeah
i see it now
can you take me through how you did it?
i need to be able to do it for firstname lastname linkedin AND email
I recorded this walkthrough video showing exactly how to set this up: https://cln.sh/4ppJ7gwW Let me know if you have any follow-up questions!
.png){kind=logo}
