Clumped/Jumbled Text

#1

Hello, all! I am trying to format lyrics underneath the songs in my app, but it is coming out a jumbled mess in the app and not looking the way that it has been formatted in the spreadsheet. I tried text entry, which seemed to work, but I soon realized that others could edit the text and I really don’t want that. I’m just running a test on the mini version of an app I intend to launch next year and would like to know how to fix this problem. Thanks!

#2

Could you post a screenshot and/or share your app?

#3

image
image439×930 67.7 KB

#4

I would like it to look like this:

image
image307×613 11.9 KB

#5

You can put two spaces at the end of a line to force a line break there: https://gist.github.com/shaunlebron/746476e6e7a4d698b373

1 Like
#7

Hi, Mark!

I tried the double-spacing at the end of each line, initially, and it seemed to work. I left off for a few hours because of rehearsal, and when I resumed it didn’t seem to do the trick anymore. I tried the backslash, but it showed up in the app. Eventually, I tried the
and this seem to work the best. Perhaps the first two methods might work for someone else, but the last one will obviously be my go-to. Thank you so much for your help with this!

Rosinda

#8

@Rosinda_Anthony Yeah I always used: < b r / > (with no spaces between the characters) and it worked for me. However there is a caution about using html code in the Rich Text component saying it could not work in the future.
I did try the double space which worked for me. Also the single backslash. I kind of like that the best as its visible. There was that caution about not all markdown parsers supporting it so there is that risk. It seems however that it is supported by Glide at this time.
Below is a bunch of text I used for testing. Try to copy and paste it into a cell and see what the output is.

Christmas Song	"Christmas Song

We wish you joy this Christmas<br/>
And a happy new year<br/>
Line 3<br/>
Line 4<br/>
<br/>
Next verse<br/>
Not the same as the first<br/>
  
Whatever  
Another Line  
Last one  
  
line  1  
line  2
line  3
  
Line 1 again

Christmas Song

We wish you joy this Christmas\
And a happy new year\
Line 3\
Line 4\
\
Next verse\
Not the same as the first\
\
Whatever  
Another Line  
Last one  
  
line  1  
line  2
line  3
  
Line 1 again
#9

I tend to to have the best luck using 2 spaces and a carriage return (CTRL+ENTER) when typing into the sheet.

#10

Thanks, George! I’m glad this forum is here to help. I appreciate you all!