How to define fields in a formview so that linebreaks are displayed

[cptutrecht]

My last question for today :-)


I have a field defined as mediumtext in a Mysql Database. It does contain linebreaks, but is not html.
In a formview (see attached image) the linebreaks don't show.

The text-area editor for that field however displays the linebreaks correctly.

How can I define the field in the formview so that there also the linebreaks are respected?

Thanks in advance

fornview.PNG

[cptutrecht]

I see a lot of views, but no reactions. Maybe because i didn't provide enough information.
Didn't find a solution, so I hope the screenshots below make the problem and question clearer. It's a breaking problem for me, for using formviews and editors...

Editor screenshot: the note field displays linebreaks correct
Formview screenshot: the note field displays without linebreakes
Formview definition screenshot: the highlighted placeholder represents the note field: how should i change that to show the linebreaks in the formview?


Thanks in advance
Editor.PNGFormview.PNGFormviewDefinition.PNG

[Davidk]

Part of the problem is that it takes time to try and duplicate what you have. Providing a simple sample with a simple table (or even static data in this case) goes a long way for these types of posts. More so, there are so many options to mix and match that my sample will undoubtedly be different than yours.

That being said, I've built an example and changed the FormView layout just a bit.

Instead of using a <span> tag... which doesn't understand formatting... change it to a <textarea> tag... and then style it so that it doesn't have a border, ext.

[cptutrecht]

Thanks David for looking in to it.

I replaced the span tag with:

<textarea style="padding:1%;margin:5px 0;width:90%;border-color: Transparent;">{Relaties_opmerkingen}</textarea>

But the result is worse (see screenshot below):
1. linebreaks are preservered but in the textarea also all html generated by Alpha is shown
2. the textarea editor doesn't popup any more.

It's almost tomorrow here, will try to make tomorrow a simple test component, perhaps based on northwind.

FormviewWithTextareaTag.PNG

[Davidk]

Then a sample is warranted... my FormView, TextArea Editor, all based on a SQL List, looks, and behaves, well... so it's down to settings.
I added a bit of Javascript to the List "onSelect" to ensure the FormView Field is properly sized for "rows"... but stuff like this usually needs few tweaks.
FormView_TextArea.PNG

[cptutrecht]

Thanks David, your remarks about textarea tag and settings lead me to the solution.

One should not place them in the freeform layout of the layoutcontainer, but adjust the template for the field that is injected into that container.
As always, AA requires only 5 minutes to tweaks but it can take hours to find the correct spot where to tweak.

In the screenshot the result and the adjustments I made, just for future reference

FormviewOk.PNGFieldTemplateSolution.PNG

[Davidk]

Glad it worked out for you. My test has the <textarea> tag in the Layout without issue, but it follows the rules of the Layout Template. Your original attempt didn't.

By using the default sample Field Template, you're now following the template rules. So... utilizing either the Field or Layout template works... as long as the syntax is correct.

Inspect the rendered page and you'll see it.