Intro and Issue

[Gregorio_Martinez]

Hi there Glide Community.

I’ve made two apps so far, a local food favorites app for friends and family and an anti-racist guide resource app. I love the ease and functionality of this format as well as the kind and brilliant people who are doing great things with Glide.

I am creating a psych assessment app using the Meal Plan template as a base and came across some issues. I contacted the owner but maybe I should’ve posted this first. I hope my etiquette is thoughtful.

I read this conversation:
Paragraph spaces within a cell
but to no avail. I tried everything suggested and also downloaded an iOS markdown app which came up with the same results. I’m using an iPad Pro without a physical keyboard.

I want to make my text appear as in the Meal Plan as in the screenie down below - bulleted vertically and spaces for paragraphs, but when I change the text on my sheet, it is crammed together and show the * that are supposed to be bullets.

I didn’t know how to search so any help would be appreciated.

Thanks and be well!
Gregorio

[Mauricio_Paz]

Hi Gregorio, you can do it using rich text, for example:

<ul>
<li>Item A</li>
<li>Item B</li>
<li>Item C</li>
<li>Item D</li>
</ul>

Result is:

• Item A
• Item B
• Item C
• Item D

[Gregorio_Martinez]

Thanks, Mauricio!
It works well.

Why is it not written this way on the sheet in the template I copied?

[eltintero]

Because HTML is not formally supported and it might end up not working with Glide eventually.

[Gregorio_Martinez]

Thanks for the info, Jesus.
Good to know.

[Jeff_Hager]

Here’s some resources:

Rich text not displaying correctly

I have a form with a notes entry component. Having trouble getting the text to be formatted with line breaks when output as rich text. As you can see below, there are no line breaks. If formatted as entered it should appear as Monday - school Tuesday - family Thursday - school Friday - family Any thoughts on why this is happening? I’m probably missing something really simple. [Screen Shot 2020-02-23 at 5.13.21 pm]

Choice of Font

The problem with BOTH markdown and using title field is that carriage returns don’t work. At least not for me. So this text… I want to do these 3 things: lose wight gain weight grow taller Will look like this… I want to do these 3 things: 1. lose wight 2. gain weight 3. grow taller

Inline text field

The ability to display “Basic Text” inline would be great. This wouldn’t apply for all cases, but for one app I’m working on now, the value of the field is just a number, so displaying it inline would take up less real estate and look a lot better in the app. Example: Label: value Instead of Label: value

Carriage-return not being displayed in text field

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] ![Screenshot%20(2)|606x499](

[Gregorio_Martinez]

Thank you, Jeff for those helpful workarounds.

I also found a video that explains two methods for iOS.

Stay well!

Edit: I think that video is for lines to show up in Sheets. And now I’m finding that HTML is the only thing that’s working for me in iOS (iPad). Sigh.

[Jeff_Hager]

I’ve alway found that when typing a list in google sheets, two spaces and a carriage return (CTRL+Enter) on a windows machine, will give you a line break. ‘*’ with a space afterwards will give you a bullet. This all works in a rich text box without the need for html.