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!
Could you post a screenshot and/or share your app?
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
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
@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
1 Like
I tend to to have the best luck using 2 spaces and a carriage return (CTRL+ENTER) when typing into the sheet.
Thanks, George! I’m glad this forum is here to help. I appreciate you all!
This is really helpful for the app I’m working on! Can you please tell me how you managed to get the lyrics left justified?
Thanks,
Also, all my lyrics - near 200 songs - have been formatted in google sheets, but google sheets will not connect to glide. I’ve exported the file as a csv. Is there some type of formatting I should do in google sheets first? Adding two spaces after each line for 200 songs will be, well, quite time consuming. Thanks so much for your help.
Nancy
Like I said in the other thread, you need to change the component that’s used to display the text. Have you tried that?
1 Like
Disregard
Chatgpt gave me a step by step! All set.
Thanks, Jeff. I’m new to the platform, so appreciate your patience. Would you please explain how to change the component that is used to display text?
Note: while in edit mode, the lyrics are left justified and show up as intended.
Nancy
1 Like
In the components panel on the left hand side of the builder, right click and delete the Fields component. Then click the plus button to add a new component. Choose the Text component, Rich Text component, or whatever component you feel is appropriate. Just don’t choose the Fields component. Then configure that new component on the right hand side to point to the appropriate column.
2 Likes
Thank you so much!!
1 Like