How can I insert a line break in a LongText field in AppSheet?

AppSheet AppSheet Q&A
1

Hi, How can I insert a line break in a LongText field in AppSheet?

CONCATENATE(
MID([Virtual INCO], 1, 70),
“”,
MID([Virtual INCO], 71, 70),
“”,
MID([Virtual INCO], 141, 70),
“”,
MID([Virtual INCO], 211, 70),
“”
)

this formula dont work
thanks

2

Physically enter a line break/return INSIDE of each double quotes. It will look like this:

CONCATENATE(
MID([Virtual INCO], 1, 70),
“

”,
MID([Virtual INCO], 71, 70),
“

”,
MID([Virtual INCO], 141, 70),
“

”,
MID([Virtual INCO], 211, 70),
“

”
)

I hope this helps!

7 Likes
3

Hello, Thank you, it’s good

1 Like
4

Hey,

Hope you’re keeping well.

In AppSheet, you can insert a line break in a LongText field by using the "\n” newline character within your expression. In your CONCATENATE formula, replace the empty string "” with "\n” so each segment is separated by a line break. For example:


CONCATENATE(
  MID([Virtual INCO], 1, 70), "\n",
  MID([Virtual INCO], 71, 70), "\n",
  MID([Virtual INCO], 141, 70), "\n",
  MID([Virtual INCO], 211, 70)
)
```  

Make sure the column type is **LongText** and the display view supports multiline text, otherwise the line breaks may not render visibly.

Thanks and regards,  
Taz
5

"\n" is not a thing in AppSheet.

Your response is incorrectly formatted.

Otherwise OK.

1 Like