Join the Community

Home
Directory
Events

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

How to Lookup Single Row on a Filtered List Without Errors

·

·

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?

1 comment

Channeled
APP
·
·
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.
Sources: Lookup Rows | Documentation | Clay University Filter List of Objects with Clay Customize your table view | Documentation | Clay University Lookup Multiple Rows in Other Table with Clay