# Carriage-return not being displayed in text field

**URL:** <https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111>\
**Category:** Ask for Help\
**Created:** [October 12, 2019, 5:03am UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111 "2019-10-12T05:03:20Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![mptA1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mpta1/32/895_2.png) [@mptA1](https://community.glideapps.com/u/mptA1)\
**Post date:** [October 12, 2019, 5:03am UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/1 "2019-10-12T05:03:20Z")

</div>

I have a cell that has a formula that uses the Char(10) to create a carriage return. It displays correctly in Google Sheets but not in Glide (See screenshots). I’ve tried both “Text” and “Rich Text” fields.

This is the formula in Sheets:  
=iferror(textjoin( CHAR(10) ,true , query(‘AFSSC done’!$A$2:$B,“select B where A='”&$A10&"’ order by B asc ") ))

![31](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/1bd7a126ab82bc6b5a637cc69b6203ddab11b847.png) ![Screenshot%20(2)|606x499](

---

<div class="post-metadata">

**Author:** ![mptA1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mpta1/32/895_2.png) [@mptA1](https://community.glideapps.com/u/mptA1)\
**Post date:** [October 12, 2019, 5:04am UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/2 "2019-10-12T05:04:46Z")

</div>

here it is in GLide…

 ![Screenshot%20(2)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/8fe3953003b1516002fce3b226c6c6ba2913602b.jpeg)

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 12, 2019, 12:41pm UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/3 "2019-10-12T12:41:20Z")

</div>

@mptA1 Try using “/n” instead of char(10).

---

<div class="post-metadata">

**Author:** ![mptA1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mpta1/32/895_2.png) [@mptA1](https://community.glideapps.com/u/mptA1)\
**Post date:** [October 12, 2019, 10:24pm UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/4 "2019-10-12T22:24:41Z")

</div>

> [@George\_B](#):
>
> “/n

How do you mean? With or without quotes? i tried both in the formula… with quotes it just displays the chracters, without the quotes the formua give an error.

thanks

---

<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:** [October 12, 2019, 10:35pm UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/5 "2019-10-12T22:35:24Z")

</div>

CTRL+ENTER might work also. I use that for carriage returns when typing into the formula bar in google sheets. You don’t see a character, but it’s always worked for me to break to a new line.

Also change to a Rich Text Component. I don’t think Basic Text will show line breaks.

---

<div class="post-metadata">

**Author:** ![mptA1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mpta1/32/895_2.png) [@mptA1](https://community.glideapps.com/u/mptA1)\
**Post date:** [October 12, 2019, 10:52pm UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/6 "2019-10-12T22:52:16Z")

</div>

ctrl+enter is what I did originally and it didn’t work in text or rich text. That’s when I tried char(10), which doesn’t work either.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 12, 2019, 11:57pm UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/7 "2019-10-12T23:57:34Z")

</div>

My mistake, I had Google Script (javascript) on the brain, and even then I should have used \n (backslash n). Totally mislead you, sorry.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 13, 2019, 1:01am UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/8 "2019-10-13T01:01:14Z")

</div>

I know that Glide advises us not to use HTML but   
 is how I do the line breaks:  
=“Line number 1.  
” &  
“Line number 2.  
” &  
“whatever.”

---

<div class="post-metadata">

**Author:** ![mptA1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mpta1/32/895_2.png) [@mptA1](https://community.glideapps.com/u/mptA1)\
**Post date:** [October 13, 2019, 1:13am UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/9 "2019-10-13T01:13:35Z")

</div>

those are ctrl+enter within the cell? If so, that doesn’t work. It doesn’t show up in text or rich text field.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 13, 2019, 1:21am UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/10 "2019-10-13T01:21:53Z")

</div>

It’s not the ctrl+enter’s that is doing it. It’s the \< b r / \> 's

 ![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/10c43d8c066ce9a131d345d6f3cb3d444f9ee59c.jpeg)

---

<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:** [October 13, 2019, 1:40am UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/11 "2019-10-13T01:40:34Z")

</div>

OK, I swear this worked for me before using a single line break, but maybe I was doing something different. I recall now that markdown requires 2 carriage returns for a line break. Try that and use the Rich Text component

---

<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:** [October 13, 2019, 1:44am UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/12 "2019-10-13T01:44:36Z")

</div>

Actually 2 spaces and 1 carriage return. 2 carriage returns is a paragraph break.

---

<div class="post-metadata">

**Author:** ![mptA1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mpta1/32/895_2.png) [@mptA1](https://community.glideapps.com/u/mptA1)\
**Post date:** [October 13, 2019, 1:55am UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/13 "2019-10-13T01:55:39Z")

</div>

Thanks @Jeff_Hager that was it! Use 2 carriage returns did the trick!

---

<div class="post-metadata">

**Author:** ![Gregorio\_Martinez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregorio_martinez/32/7299_2.png) [@Gregorio\_Martinez](https://community.glideapps.com/u/Gregorio_Martinez)\
**Post date:** [January 12, 2022, 7:25pm UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/14 "2022-01-12T19:25:07Z")

</div>

This should be in the documentation or something. I really needed this trick! Thanks!

---

<div class="post-metadata">

**Author:** ![mbnownet](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbnownet/32/37355_2.png) [@mbnownet](https://community.glideapps.com/u/mbnownet)\
**Post date:** [July 20, 2022, 1:44pm UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/15 "2022-07-20T13:44:52Z")

</div>

I attempted this in a Glide Table template that outputs to a Checklist Title field, & it didn’t work ☹

---

<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 20, 2022, 1:49pm UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/16 "2022-07-20T13:49:15Z")

</div>

Can you show how you configured the template column, and describe what your expected output should be?

---

<div class="post-metadata">

**Author:** ![mbnownet](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbnownet/32/37355_2.png) [@mbnownet](https://community.glideapps.com/u/mbnownet)\
**Post date:** [July 20, 2022, 1:53pm UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/17 "2022-07-20T13:53:59Z")

</div>

To put it simply, in the template field I entered  
"week,

start-end"

This is going into a Checklist Title field, & I have “Allow text wrapping” checked. I was hoping to achieve:  
“ **Mon,Tue,Wed,Thu,Fri**  
**6pm-10pm** ”

In stead, it looks like:  
"**Mon,Tue,Wed,Thu,Fri 6pm-  
10pm**

---

<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 20, 2022, 2:16pm UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/18 "2022-07-20T14:16:09Z")

</div>

What you see is expected. To get the effect that you want you would need to over ride the default styling with some Custom CSS. This will only be possible if your checklist is used on a Details Layout.

You could try the following in a rich text component on the same screen:

```auto
<pre><span><style>
[data-test="list-item-title"] {
  white-space: break-spaces!important;
}

```

Note that this is not officially supported, and not guaranteed to work.

---

<div class="post-metadata">

**Author:** ![mbnownet](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbnownet/32/37355_2.png) [@mbnownet](https://community.glideapps.com/u/mbnownet)\
**Post date:** [July 20, 2022, 2:25pm UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/19 "2022-07-20T14:25:44Z")

</div>

In this case, my workaround for now is to simply add a line of [nbspace]s (" " - As you probably know they look like spaces, but they aren’t ignored & output as a single space) between the text I want on my 1st line & the text I want on my second line. This of course has the side effect of giving an uneven position for the second line.

Edit:  
“`...so I might try to include tab characters as well.`”  
(Doesn’t work. Too bad there doesn’t seem to be an nbtab.)

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/carriage-return-not-being-displayed-in-text-field/1111/20 "2024-01-17T16:49:25Z")

</div>