# Create a "partial match" relation

**URL:** <https://community.glideapps.com/t/create-a-partial-match-relation/56807>\
**Category:** Ask for Help\
**Created:** [January 17, 2023, 6:25pm UTC](https://community.glideapps.com/t/create-a-partial-match-relation/56807 "2023-01-17T18:25:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [January 17, 2023, 6:25pm UTC](https://community.glideapps.com/t/create-a-partial-match-relation/56807/1 "2023-01-17T18:25:36Z")

</div>

Has anyone figured out a technique for multiple matching when a partial match occurs in a relation.

For example I want to match all records where Name contains “Disney” versus accounts that are exactly “Disney”

Is this something that AirTable or another DB/tool would be better at?

TIA

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 17, 2023, 6:50pm UTC](https://community.glideapps.com/t/create-a-partial-match-relation/56807/2 "2023-01-17T18:50:53Z")

</div>

Relations need exact matches, but you can trick them 🙂

For your use case you could add an if-then-else column:

- if name includes Disney, then true

Then add a template column that contains the word true, and build your relation between those two columns.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [January 18, 2023, 6:51pm UTC](https://community.glideapps.com/t/create-a-partial-match-relation/56807/3 "2023-01-18T18:51:21Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
