Issues with Lookup Single Row Function Causing Endless Loop Error

·

struggling to use the “lookup single row in other table” function as it keeps citing an error due to endless loop but table A and Table B aren’t connected to eachother via formula aside from sharing some data parameters

1 comment

Channeled
APP
·
·
The "endless loop" error occurs because Clay doesn't allow circular data flows between tables. Even though you're using lookup functions rather than formulas, Clay still detects a loop in your data flow. Data in Clay can only flow linearly (A → B → C), not in loops (A → B → A). If you need to reference data bidirectionally, you should: 1. Maintain a one-way "write to other table" connection in one direction 2. Use lookup functions in the opposite direction This prevents the circular dependency that's causing your error.
Sources: Send table data | Documentation | Clay University Send table data | Documentation | Clay University Write to Other Table | Documentation | Clay University