Look up single row on a filtered list. The problem is, the look-up is retrieving rows that are filtered. How to work around this?
To perform a lookup on a filtered list in Clay, you'll need to use a combination of filtering and lookup actions. Here's a step-by-step approach: 1. First, apply the desired filters to your table using the filter menu. 2. Then, use the "Filter List of Objects" action to create a subset of your data based on your applied filters. 3. Finally, use the "Lookup Multiple Rows in Other Table" action on this filtered subset. This approach ensures that only visible (unfiltered) rows are included in your lookup. If you need more detailed guidance, please ask and we'll be happy to help further.