# Split text for which row?

**URL:** https://community.glideapps.com/t/split-text-for-which-row/64409
**Category:** Ask for Help
**Created:** [July 27, 2023, 1:52am UTC](https://community.glideapps.com/t/split-text-for-which-row/64409 "2023-07-27T01:52:10Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)
#### Post date: [July 27, 2023, 1:52am UTC](https://community.glideapps.com/t/split-text-for-which-row/64409/1 "2023-07-27T01:52:10Z")

</div>

This table is a question list. It will transfer to another table after they submit.  
and for each question not necessary to answer. it will able for the user to come back and edit. maybe using split text. My question is how to make sure the answer is for specific row after we joined list?  
.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4d6797b918cb25f2fd95f4bd553c8406b16954dc.png)

---

<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: [July 27, 2023, 2:26am UTC](https://community.glideapps.com/t/split-text-for-which-row/64409/2 "2023-07-27T02:26:11Z")

</div>

You probably need to stick a default value in there before you create the Joined List.  
So you could have an if-then-else column with something like:

- If Answer is empty, then “-”
- Else Answer

And then use the if-then-else column in the joined list instead of the Answer column.

---

<div class="post-metadata">

### Author: ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)
#### Post date: [July 27, 2023, 3:06am UTC](https://community.glideapps.com/t/split-text-for-which-row/64409/3 "2023-07-27T03:06:37Z")

</div>

How the Split text to turn up as a table or inline text? I tried to use relation but failed

---

<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: [July 27, 2023, 3:19am UTC](https://community.glideapps.com/t/split-text-for-which-row/64409/4 "2023-07-27T03:19:26Z")

</div>

Split text creates an array.  
If you want to display that on the screen, you can either use a joined list column, or transpose it to a list using the “miracle method” and then show it in a collection.

---

<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 12, 2024, 5:31am UTC](https://community.glideapps.com/t/split-text-for-which-row/64409/5 "2024-01-12T05:31:53Z")

</div>

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