Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps

Community Guidelines

Powered by Tightknit

Limitations on Lookup Columns in Tables: Troubleshooting Tips

·

·

Hello! Are there any limitations on how many lookup columns can be in one table? For some reason I can't get data from a third lookup column while first two are working just fine

Loading attachments

Limitations on Lookup Columns in Tables: Troubleshooting Tips | Clay

23 comments

· Sorted by Oldest

Loading comments

Bruno R.
·
·
Hi Alex, thanks for reaching out. You should not be running into issues after setting up just three lookup columns. Do you mind sending the link to the table so we can take a look?https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1731596400&signature=69ad4da55b7a29272b55aff9ea0f1de671f9473e062d45705491f9eeb6a3bb0e&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSr5D5ES2BKsam%2FhVPu8pQ%3D%3D%0A
Alex K.
·
·
Also, please help me with (probably) related question. I got stuck with making a lookup column if the previous lookup returned the expected result (in my case it's 'Contact Name') What should be the conditional for the lookup not to run?
Alex K.
·
·
Hi Bruno, here it is: https://app.clay.com/workspaces/369302/workbooks/wb_uU59QBmPmdby/tables/t_2AmAv8TJtVdc/views/gv_6jv2sBQdU5nq
Bruno R.
·
·
If you're still experiencing this issue, can you kindly perform a hard refresh for me? This seems to be a temporary frontend issue, I'm able to link the lookup column in the prompt on my end. Here are some instructions on how to do it: Mac: Chrome and/or Firefox = Press Cmd + Shift + RSafari = Press Cmd + Option + RPC:Chrome, Firefox, Microsoft Edge = Press Ctrl + F5
Let me know if this fixes the issue!
Bruno R.
·
·
As for your second question on running columns conditionally, I recorded this quick video to show you how to set this up: https://www.loom.com/share/c5c18acf57594656a80c6167bf8e7b5a?sid=985e4404-8fc4-41fc-9263-6523efbf2a39
Alex K.
·
·
still same result. Can it be related to the Run conditional? I have run only: !_.some({{PPM Lookup}}?.records, 'Contact name')
Alex K.
·
·
Bruno, in your video the IT lookup column is also empty
Bruno R.
·
·
Just to clarify, the issue is that you're not able to link specific outputs of your lookup columns in the GPT prompt?
Alex K.
·
·
It exists but UI shows that there is no data inside
Alex K.
·
·
Yes, I can't get to the response inside of the lookup. It doesn't show the array inside
Bruno R.
·
·
I see what you mean now thanks for your patience Alex. Will take a closer look.
Alex K.
·
·
I followed the instructions from the video. It works with hthe first column (Change Lookup). But it does not work with the second lookup (IT Lookup) when the Change has a result 'Run condition not met'
Bruno R.
·
·
Could you check if the issue still persists? I believe the lookup reference is now functioning as expected: https://downloads.intercomcdn.com/i/o/w28k1kwz/1251836056/13b78f39c302a5a9bb628b64bf74/CleanShot+2024-11-14+at+09_49_13%402x.png?expires=1731597300&signature=0f97791b7be36a7456063591c7f14312d72ff43e194d5bb445fa413923b10d6a&req=dSIiF8F9m4FaX%2FMW1HO4zWlugJgio5ePomIzD%2BJHakjw9bhOBL2wgrDRwn7Y%0A2g5n%0A
Alex K.
·
·
The third lookup works as expected when Change has a response (even if it's no record found) But it runs when Change has 'Run condition not met' as a response
Alex K.
·
·
And I want it not to run