# URGENT HELP: Relations That Include Values

**URL:** <https://community.glideapps.com/t/urgent-help-relations-that-include-values/60299>\
**Category:** Ask for Help\
**Created:** [April 8, 2023, 10:25pm UTC](https://community.glideapps.com/t/urgent-help-relations-that-include-values/60299 "2023-04-08T22:25:45Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![benyoung](https://avatars.discourse-cdn.com/v4/letter/b/439d5e/32.png) [@benyoung](https://community.glideapps.com/u/benyoung)\
**Post date:** [April 8, 2023, 10:25pm UTC](https://community.glideapps.com/t/urgent-help-relations-that-include-values/60299/1 "2023-04-08T22:25:45Z")

</div>

Hi…I am wanting to create an app that features a relation column but I want it to find values that include certain values not exactly match them. Thanks.

@ThinhDinh @Robert_Petitto

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 9, 2023, 2:18am UTC](https://community.glideapps.com/t/urgent-help-relations-that-include-values/60299/2 "2023-04-09T02:18:46Z")

</div>

Can you describe more about your use case? If it doesn’t exactly match, then what is the relation between the two?

---

<div class="post-metadata">

**Author:** ![benyoung](https://avatars.discourse-cdn.com/v4/letter/b/439d5e/32.png) [@benyoung](https://community.glideapps.com/u/benyoung)\
**Post date:** [April 9, 2023, 3:37am UTC](https://community.glideapps.com/t/urgent-help-relations-that-include-values/60299/3 "2023-04-09T03:37:35Z")

</div>

It doesn’t match but the value IS INCLUDED IN the other value.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 9, 2023, 3:45am UTC](https://community.glideapps.com/t/urgent-help-relations-that-include-values/60299/4 "2023-04-09T03:45:01Z")

</div>

Does the value you want to match include only one word, or there can be multiple words?

---

<div class="post-metadata">

**Author:** ![benyoung](https://avatars.discourse-cdn.com/v4/letter/b/439d5e/32.png) [@benyoung](https://community.glideapps.com/u/benyoung)\
**Post date:** [April 9, 2023, 3:49am UTC](https://community.glideapps.com/t/urgent-help-relations-that-include-values/60299/5 "2023-04-09T03:49:22Z")

</div>

It will include a specific value which is a ‘template’ column.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 9, 2023, 4:05am UTC](https://community.glideapps.com/t/urgent-help-relations-that-include-values/60299/6 "2023-04-09T04:05:00Z")

</div>

So would that template contain strings that have multiple words?

---

<div class="post-metadata">

**Author:** ![benyoung](https://avatars.discourse-cdn.com/v4/letter/b/439d5e/32.png) [@benyoung](https://community.glideapps.com/u/benyoung)\
**Post date:** [April 9, 2023, 4:11am UTC](https://community.glideapps.com/t/urgent-help-relations-that-include-values/60299/7 "2023-04-09T04:11:37Z")

</div>

Yes. The template has multiple words. An example of one is “(1) Joe” and in the value, I am relating to it is, “(1) Joe,(2) Sally” but the next row might just say “(2) Sally)” so I want to relate to values that have a certain value included in another value. If that makes sense. Thank you so much for your help!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 9, 2023, 5:06am UTC](https://community.glideapps.com/t/urgent-help-relations-that-include-values/60299/8 "2023-04-09T05:06:18Z")

</div>

What you need to do is go to the table that has ‘Joe, Sally’ and add a Split Text column, which will split the names into an array. Then you change your relation to use that Split Text array column instead of the text column. Then it will work for you.

---

<div class="post-metadata">

**Author:** ![benyoung](https://avatars.discourse-cdn.com/v4/letter/b/439d5e/32.png) [@benyoung](https://community.glideapps.com/u/benyoung)\
**Post date:** [April 9, 2023, 5:12am UTC](https://community.glideapps.com/t/urgent-help-relations-that-include-values/60299/9 "2023-04-09T05:12:20Z")

</div>

Legend! Thank you so much @Jeff_Hager!

---

<div class="post-metadata">

**Author:** ![benyoung](https://avatars.discourse-cdn.com/v4/letter/b/439d5e/32.png) [@benyoung](https://community.glideapps.com/u/benyoung)\
**Post date:** [April 9, 2023, 5:24am UTC](https://community.glideapps.com/t/urgent-help-relations-that-include-values/60299/10 "2023-04-09T05:24:44Z")

</div>

Also, thank you to @ThinhDinh for your help.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 9, 2023, 11:54pm UTC](https://community.glideapps.com/t/urgent-help-relations-that-include-values/60299/11 "2023-04-09T23:54:26Z")

</div>

My original thinking when asking you if it would have multiple words is a situation like:

“A, B, C” but you consider “B, C” as a single term to relate. Then that would complicate things a lot. If A, B, C are on their own, then we should be good.

---

<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:** [April 10, 2023, 11:54pm UTC](https://community.glideapps.com/t/urgent-help-relations-that-include-values/60299/12 "2023-04-10T23:54:37Z")

</div>

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