# Template column including spilt text column

**URL:** <https://community.glideapps.com/t/template-column-including-spilt-text-column/74105>\
**Category:** Ask for Help\
**Created:** [June 13, 2024, 12:25pm UTC](https://community.glideapps.com/t/template-column-including-spilt-text-column/74105 "2024-06-13T12:25:53Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\
**Post date:** [June 13, 2024, 12:25pm UTC](https://community.glideapps.com/t/template-column-including-spilt-text-column/74105/1 "2024-06-13T12:25:53Z")

</div>

Hello fellow gliders

I’d like to make relations between different tables but one of the columns has to contain values constructed via a template column, here is where Im finding it difficult - In the table in which I submit values via a choice column that alllows multiple selection. The values are then separated using the comma and a spit text value. Now each of these values must be joined to another choice using a template column so as to perfom relavant calculation that wouls follow.

for example

Split column text contains:

- Biology
- Geography
- English
- Music

all separated by columns. then second column choice is simply a period:

- 1st Term

So I hope to have the following result in the template column

- 1st Term - Biology
- 1st Term - Geography
- 1st Term - English
- 1st Term - Music

If not a template column, perhaps another method that acheives the same goal.

Thanks in advance

---

<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:** [June 13, 2024, 1:42pm UTC](https://community.glideapps.com/t/template-column-including-spilt-text-column/74105/2 "2024-06-13T13:42:25Z")

</div>

Have you tried using a Query column instead of a Relation? Then there shouldn’t be a need to create a template column because a Query can look at multiple criteria.

---

<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:** [June 13, 2024, 11:16pm UTC](https://community.glideapps.com/t/template-column-including-spilt-text-column/74105/3 "2024-06-13T23:16:26Z")

</div>

Can you try Jeff’s suggestion with something like: Term is this row \> Term and Subject is included in this row \> Comma-delimited list of subjects?

---

<div class="post-metadata">

**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\
**Post date:** [June 14, 2024, 12:33pm UTC](https://community.glideapps.com/t/template-column-including-spilt-text-column/74105/4 "2024-06-14T12:33:43Z")

</div>

Thank you

---

<div class="post-metadata">

**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\
**Post date:** [June 14, 2024, 12:34pm UTC](https://community.glideapps.com/t/template-column-including-spilt-text-column/74105/5 "2024-06-14T12:34:08Z")

</div>

Ok, thank you, trying to figure it out

---

<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:** [July 4, 2024, 6:42pm UTC](https://community.glideapps.com/t/template-column-including-spilt-text-column/74105/6 "2024-07-04T18:42:09Z")

</div>

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