# Split Text column

**URL:** https://community.glideapps.com/t/split-text-column/15805
**Category:** General
**Created:** [September 15, 2020, 9:36am UTC](https://community.glideapps.com/t/split-text-column/15805 "2020-09-15T09:36:34Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [September 15, 2020, 9:36am UTC](https://community.glideapps.com/t/split-text-column/15805/1 "2020-09-15T09:36:34Z")

</div>

In case you missed it - the new Split Text column splits up text into separate values. This is particularly useful for Relations.

[Read more in our docs.](https://docs.glideapps.com/all/reference/data-editor/computed-columns/split-text-column)

 ![go.glideapps.com_app_6L1m67xelmQ0opYkjebs_data](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a243d6159dfdd88fbc7d3c98b3b1db0f9c0ccf60.png)

---

<div class="post-metadata">

### Author: ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)
#### Post date: [September 15, 2020, 2:40pm UTC](https://community.glideapps.com/t/split-text-column/15805/2 "2020-09-15T14:40:34Z")

</div>

Thanks @JackVaughan. It’s very helpful just like your videos.

Suggestion for Glide Team - Is it possible to pin official announcements for 1-2 days? It helps us prioritize reading posts in the community (feature request 1)

Problem - Old Announcement threads become active with “NEW’ emoji in subject causing confusion. It’s painful to have to track real Glide updates on community and Twitter. Ideally, paying users should get a weekly email digest (feature request 2 😀).

If I am unaware of the best way to track only new updates, please share.

---

<div class="post-metadata">

### Author: ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [September 15, 2020, 7:27pm UTC](https://community.glideapps.com/t/split-text-column/15805/3 "2020-09-15T19:27:03Z")

</div>

Sure, I appreciate that. For a clearer list, I’d recommend using: [https://www.glideapps.com/product/updates](https://www.glideapps.com/product/updates).

We’ll have a think about the pinning. I think we want to use that sparingly - rather than all the time.

I might drop the New emoji - that’s a good point.

---

<div class="post-metadata">

### Author: ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)
#### Post date: [September 15, 2020, 8:13pm UTC](https://community.glideapps.com/t/split-text-column/15805/4 "2020-09-15T20:13:58Z")

</div>

Thanks😀

---

<div class="post-metadata">

### Author: ![Naos\_Wilbrink](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/naos_wilbrink/32/769_2.png) [@Naos\_Wilbrink](https://community.glideapps.com/u/Naos_Wilbrink)
#### Post date: [September 16, 2020, 10:38am UTC](https://community.glideapps.com/t/split-text-column/15805/5 "2020-09-16T10:38:20Z")

</div>

Great page! Didn’t know it existed 🙂

One note: [https://www.glideapps.com/product/updates/glide-tables](https://www.glideapps.com/product/updates/glide-tables) check the 2 buttons below. They both go to a URL “[https://www.glideapps.com/product/updates/Not%20supported](https://www.glideapps.com/product/updates/Not%20supported)”

---

<div class="post-metadata">

### Author: ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [September 16, 2020, 10:54am UTC](https://community.glideapps.com/t/split-text-column/15805/6 "2020-09-16T10:54:03Z")

</div>

Yes - i noticed this yesterday right after I posted this. Thanks - we’re on it.

---

<div class="post-metadata">

### Author: ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)
#### Post date: [September 16, 2020, 11:47am UTC](https://community.glideapps.com/t/split-text-column/15805/7 "2020-09-16T11:47:43Z")

</div>

@Naos_Wilbrink Very nice page. You @JackVaughan should market that a lot 👍

---

<div class="post-metadata">

### Author: ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [September 16, 2020, 11:54am UTC](https://community.glideapps.com/t/split-text-column/15805/8 "2020-09-16T11:54:31Z")

</div>

Yes, only started recently. We will make it more prominent at some point soon.

---

<div class="post-metadata">

### Author: ![Makis\_Theonas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/makis_theonas/32/713_2.png) [@Makis\_Theonas](https://community.glideapps.com/u/Makis_Theonas)
#### Post date: [September 21, 2020, 7:47am UTC](https://community.glideapps.com/t/split-text-column/15805/9 "2020-09-21T07:47:03Z")

</div>

Is there a way to use the Split Text Column as values for Choice component?

---

<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: [September 21, 2020, 9:35am UTC](https://community.glideapps.com/t/split-text-column/15805/10 "2020-09-21T09:35:06Z")

</div>

Seems like a no for now, it has always been that way for array values.

---

<div class="post-metadata">

### Author: ![Makis\_Theonas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/makis_theonas/32/713_2.png) [@Makis\_Theonas](https://community.glideapps.com/u/Makis_Theonas)
#### Post date: [September 21, 2020, 11:23am UTC](https://community.glideapps.com/t/split-text-column/15805/11 "2020-09-21T11:23:07Z")

</div>

I think it would be very handy - maybe those in charge evaluate this.

---

<div class="post-metadata">

### Author: ![Thibault\_Milan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibault_milan/32/4970_2.png) [@Thibault\_Milan](https://community.glideapps.com/u/Thibault_Milan)
#### Post date: [October 16, 2020, 8:40am UTC](https://community.glideapps.com/t/split-text-column/15805/12 "2020-10-16T08:40:16Z")

</div>

Oddly, when I try to make a relation from a split column, even when I checked “multiple” I only have one item returned then a lot of “-” items which … I don’t know where they came from ☹

Another cool feature for the split column would be able to use them to have a list in a view without having to create a relation necessarily. Just display beautifully a list of elements, one by one.

---

<div class="post-metadata">

### Author: ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)
#### Post date: [October 16, 2020, 8:55am UTC](https://community.glideapps.com/t/split-text-column/15805/13 "2020-10-16T08:55:23Z")

</div>

Hello,  
The display of relationship columns changed this week.  
I recommend that you test your relationship in the app or with other Lookup columns.

---

<div class="post-metadata">

### Author: ![Thibault\_Milan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibault_milan/32/4970_2.png) [@Thibault\_Milan](https://community.glideapps.com/u/Thibault_Milan)
#### Post date: [October 16, 2020, 9:55am UTC](https://community.glideapps.com/t/split-text-column/15805/14 "2020-10-16T09:55:16Z")

</div>

Need a relation to try a lookup, and I can’t create a proposer relation based on the split text column so ☹

---

<div class="post-metadata">

### Author: ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)
#### Post date: [October 16, 2020, 11:18am UTC](https://community.glideapps.com/t/split-text-column/15805/15 "2020-10-16T11:18:43Z")

</div>

I knew I had already made the solution.  
The trick is to split your Joint column and then make a relation with the Split column.  
It works, I did a test on one of my applications.

---

<div class="post-metadata">

### Author: ![Thibault\_Milan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibault_milan/32/4970_2.png) [@Thibault\_Milan](https://community.glideapps.com/u/Thibault_Milan)
#### Post date: [October 16, 2020, 11:25am UTC](https://community.glideapps.com/t/split-text-column/15805/16 "2020-10-16T11:25:59Z")

</div>

Well, he doesn’t right now, that’s my point:

Split column:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/869aacc6da682b43ecb0530055ca54ea5d28aa69.png)  
The relation that doesn’t work properly (notice the `-` everywhere):  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3c7b9428f27f173026b5b80fcd9e4c9876c3cb8e.png)  
The `Avail_Days` column:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/00cdc815f27e5c3017d5e1a1af65fe360d6acd72.png)

---

<div class="post-metadata">

### Author: ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)
#### Post date: [October 16, 2020, 11:29am UTC](https://community.glideapps.com/t/split-text-column/15805/17 "2020-10-16T11:29:47Z")

</div>

It’s curious, I did the test with email

and i also did a test with dates and it works too.

 ![split](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/50e42a4116c82d4528efeb36464f7d0259f5738d.png)

 ![relation](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c03f85634e9ad7d370f1662d0d4c9bb0ceaf1c39.png)

---

<div class="post-metadata">

### Author: ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)
#### Post date: [October 16, 2020, 11:43am UTC](https://community.glideapps.com/t/split-text-column/15805/18 "2020-10-16T11:43:55Z")

</div>

This is probably linked to the date format. or there is the time which does not correspond.

---

<div class="post-metadata">

### Author: ![Thibault\_Milan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibault_milan/32/4970_2.png) [@Thibault\_Milan](https://community.glideapps.com/u/Thibault_Milan)
#### Post date: [October 16, 2020, 11:46am UTC](https://community.glideapps.com/t/split-text-column/15805/19 "2020-10-16T11:46:57Z")

</div>

ok but see, you have a lot of `-` too …

---

<div class="post-metadata">

### Author: ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)
#### Post date: [October 16, 2020, 11:47am UTC](https://community.glideapps.com/t/split-text-column/15805/20 "2020-10-16T11:47:25Z")

</div>

when working with related dates, glide uses the full date & time format.  
well that’s my observation.  
As in my example, in the date column the format is dd / mm / yyyy and therefore relation is the full format.

[Next page](https://community.glideapps.com/t/split-text-column/15805.md?page=2)
