Database - Why doesn't the rich text formatting hold?

I’ve created a database that has several columns of plain text and one with rich text that contains instruction sets that I need to be formatted.

Every other time I access or edit one of the rich text cells, it will clear most of the formatting and its incredibly frustrating.

From the live database, I select a rich text cell, use formatting options such as font, font size, color, and alignment. Then I select outside of the cell to accept the changes. I can then open the same cell up just a few moments later and there’s about a 50/50 chance the font has defaulted back to Proxima with a size 15 font, the title’s center alignment is cleared, bullets and indented lines back all the way to the left, all black text, etc…

What is going on??

6 Likes

Anyone have any suggestions?

“What is going on?” Indeed…

I tried this myself and everything works great. Not sure what your scenario is. Please post your URL so I can dig deeper.

I’m trying to create a Rich Text in the database, I can select a field with Richtext. but in the form, I can’t select any form that allow me to use the rich text file. May I know how I can do this? I been searching for a while and I was really expected that WIX is a very simple to use site. but for some reason, I just can’t figure it out. please assist

Hi Raymond,

I would recommend reading the article Formatting Text Elements with Wix Code .

Here’s an example of how to display a Rich Text field from the database:

Add a dataset and connect it to the collection that has the Rich Text field you want to display:

Add a text field (doesn’t really matter which one) and connect it to the Rich Text field in the collection:


That’s all you need. Run Preview:


As you can see, I was able to display rich text with just 3 simple steps.

For a more complex example, see the article H ow to Create a Rich Text Editor Using the HTML Component in Wix Code .

Have fun,

Yisrael

Thanks Yisrael. How I can do input?

Display now I know, but I can’t do input. Appreciate your help

The article H ow to Create a Rich Text Editor Using the HTML Component in Wix Code .

I have exactly the same problem. The rich text formatting only holds like 20% of the time. I’m trying some shaman techniques to make it work.
What I’ve seen is that apparently there is an automatic function that changes the style attribute to fallback on default values (serif, 13px).
In practice, I would format my text, check the HTML, and when I go back to the rich text tab all the formatting would set itself back to these default values.
If I set a font, and then click outside the window to get out (and in theory save the changes) then preview my page, changes are not saved.
If I do the same procedure, but click the HTML tab after editing, and then go back to the rich text tab, I can see the formatting being reset to the “default” values. Previewing shows me that changes are still not saved.
If I copy my text in the clipboard before going to the HTML tab, the custom font gets inserted in the HTML style attributes. But it still doesn’t saves the changes. If I go back to the rich text tab, and then HTML tab again, all the style disappear. BUT if I reselect all of my custom formatted text BEFORE closing the window, my format actually gets saved :open_mouth:

Hope that makes sense, and could help targeting the problem.

Edit : I am guessing that pasting HTML text directly in the rich text tab from another source might have something to do with that problem?

same, every time I open the pop up box to see or edit the text, it goes back to Proxima and erases any style that was applied before.

I have the same problem. The rich text field doesn’t keep the format I wanted.

Same issue as the others with rich text formatting reverting to Proxima and all formatting reverts to that default of 15px Proxima. Very frustrating!

Got it working by reapplying the formatting directly into the html span style. Each rich text field has an additional tab that allows one to do that.

Yisrael, would greatly appreciate wix could fix this problem asap. It is hugely frustating and costing me a lot of hours going back in and making changes opnly to have them disappear some time layter. I have tried updating within the database itself and then following it up with a universal save and then (just to be sure) even publishing the changes only to find the fields have reverted back to the text I had before the fields were edited. Thanks.

I have seen this issue as well. it is independent of clicking outside of cell, saving publishing, syncing etc … . Very frustrating. I see these issue within the editor only.

I’ve reported this issue to QA for further investigation.

I think the Sandbox and Live databases’ differences cause the confusion sometimes.
You should sync them to see the changes.

I’m having the same problem… very frustrating!

I also have this problem. Whether I format with visual or html editor, many of my rich text entries default to proxima 17. Is there a place to set the paragraph 1-3 and header 1-6 styles for the databases?
Stephanie

I’m stuck with the same problem… but only in some of the fields with rich text.
It would also be nice if we could expand the rich text editor!

Same problem here - really frustrating, and costing me a lot of time. Hope to see a fix soon!

Plus - would be nice if the pop-out window could be resized. I have a lot of text sometimes and the tiny window makes it hard to edit.