Does the function "Lookup Multiple Rows in Other Table" have a limit of 100 rows?
The "Lookup Multiple Rows in Other Table" function in Clay doesn't have a specific 100-row limit. It has an optional "Limit" input that allows you to set the maximum number of rows to return. This is useful for managing response size, especially with tables containing many columns. However, Clay tables themselves have a limit of up to 50,000 rows per table. If you need more information or assistance, feel free to ask for clarification.
But my table has 250 rows, but the lookup function only picks up 100...
The "Lookup Multiple Rows in Other Table" function has an optional "Limit" input that allows you to set the maximum number of rows to return. It's possible that this limit is currently set to 100 rows in your case. This feature is useful for managing response size, especially when dealing with tables that have many columns. To retrieve all 250 rows from your table, you'll need to adjust the "Limit" setting. If you need help with this or have further questions, please ask for human assistance by clicking on "Talk to a person" in this chat.
No, the limit box is empty at the moment.
Hey there Dante thanks for reaching out, sorry for the long delay here, to confirm here the Lookup does have a limit of 100 rows for the results. This is something that the team is currently looking into increasing though, however there is not ETA at the moment.
Thanks LuisArturo! Alright, I found a workaround temporarily but it would be great if it would be supported in the future. While you're at it, please leave feedback to the product team that the max cell size of 8kb also should be increased if possible. I have a lot of issues with this in my tables. Thank you very much!
Hey there Dante no worries will pass this along as well.