# Conditional logic for Look Up

**URL:** <https://community.fibery.io/t/conditional-logic-for-look-up/3443>\
**Category:** Ideas & Features\
**Created:** [October 25, 2022, 4:18pm UTC](https://community.fibery.io/t/conditional-logic-for-look-up/3443 "2022-10-25T16:18:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [October 25, 2022, 4:18pm UTC](https://community.fibery.io/t/conditional-logic-for-look-up/3443/1 "2022-10-25T16:18:33Z")

</div>

I often want to lookup related entities based upon search criteria. Currently, I want to lookup the Event records associated with a contact only if they attended the event (as opposed to just registering).

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [October 25, 2022, 4:52pm UTC](https://community.fibery.io/t/conditional-logic-for-look-up/3443/2 "2022-10-25T16:52:06Z")

</div>

One way to do that would be to have two Event collections in Contact - one for “registered events” and a separate one for “attended events”.

You could also create a Formula field with `filter()` to make such a Lookup, as long as all of the required filter criteria are members of the Contact and Event DBs.  
E.g.

```auto
Attendances.Filter([Attended]=true)
```

---

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [November 10, 2022, 5:41pm UTC](https://community.fibery.io/t/conditional-logic-for-look-up/3443/3 "2022-11-10T17:41:08Z")

</div>

This is my current solution!  
However, now that I’m looking into smart folders for report creation, I find myself looking to eliminate these in-between fields to simplify entity relationships.

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [November 10, 2022, 6:33pm UTC](https://community.fibery.io/t/conditional-logic-for-look-up/3443/4 "2022-11-10T18:33:04Z")

</div>

I wouldn’t hold your breath for native support of auto-linked relationships that can have a more-complex definition than simple field equality.

Will the Formula approach not work? That gives you a filtered version of the existing “complete” collection. But I don’t know what you’re trying to do in this report…