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??
I'm a little shocked that I just read through 4 pages of comments over a 2 year period, and the last solution offered was... best to avoid using Rich Text Fields in databases... We need the rich text fields. And most importantly, even if we do everything perfectly to set it up, we need it to be easy for clients to update. Otherwise, game over.
The Proxima Nova reign continues. Right now, I have to individually change each cell in a column from Proxima Nova to my desired font and also, select from the drop down a Header/Paragraph style.
The Header/Paragraph styles in the RTF editor's top left dropdown menu should either a). MATCH the formatting in the regular Wix Editor OR if that isn't possible... then b) We should have the ability to customize those header/paragraph themes to any style we wish AND that formatting holds across all cells in that database's RTF column.
OR another if we could format the RTF Column's theme once, so that each new row's cell has the same formatting.
eg. Changing the font from Proxima Nova to say, Helvetica Light for each cell in a column one a time is the definition of insanity... Some databases have thousands of rows!
I would prefer to use a regular text field... but I need paragraph breaks. Hoping this is still on Wix Corvid's radar!
I think my editor is bugged. I've been having so many problems with my editor for quite some time (2 years now). Nothing ever goes right. I have to go back and fix things that were out of place after all have been perfected. My database isn't working out well. I tried to several ways and still not getting the rich text formatted properly. I've been at this for days.
Do not forget to sync. Without sync it may looks like a bug.
In the database, create a new rich text column / field (just for test) and check out if in that new column the problem persists
Okay, will try dumping cache, incognito, and different browser just to be sure...
Hi all, I just did some checking of rich text fields and I don't see a regression to the former behavior. Everything seems to be working as expected. If anyone is still seeing buggy behavior around rich text fields, can you please post more details of how to reproduce the problem? Thanks.
Hi - the text format bug is back! It is now affecting my dynamic pages! www.maidstonelabour.com
Please can someone squash this bug for good?
Thanks for all you guys do, much appreciated.
Jessica
I am having the same issue using the Rich Text Box. I am stuck with the Nova font and default size.
My clients are still having issues.
I'm also still having the same issue.
Following as we have the same issue.
I'm still having an issue.. when I save from my form to a connected dataset, the rich text defaults to the Proxima Nova 15 when I view it on the page as text, even though my rich text is set as Helvetica 16. Also, when I look at it in the database it seems to be reset to Times.
Also, the Themes in the database don't match the Themes I have set on my site.
Hi all, I have an update: Our developers were able to isolate the problem and issued fixes, and it seems to have done the trick! I just re-tested to make sure the fixes were available to the general public.
So, to clarify what the bug was and what the fix encompasses: If you entered formatted text into a rich text field in a database collection, and that text included paragraphs with multiple carriage returns between the paragraphs, much of the formatting of the text would be lost or corrupted after leaving and re-entering the field. The fix deals specifically with this situation: If you're editing a rich text field directly in a collection, the formatting will now be stable!
Note that Wix recently released a new Editor element called a "Rich Text Box", and the fix does not apply to that element. The functionality of Rich Text Boxes is limited at this time and we recommend only using them for inputting new data into a collection via databinding.
Please post here if you are still encountering trouble. Good luck!
I have a solution to this annoying problem, which seems reliable, and will work for you if you can change your rich text formatted text fields to HTML (with tags for p1, p2, h2 etc... and obviously <br> for return carriages).
So rather than using Rich Text, you can instead store this formatted HTML inside a text field in your collection (the field type for this MUST be text not rich text).
Then, in order to get this displayed on the dynamic page, you simply insert this HTML into the relevant element on the page (which doesn't even need to be connected to any data), using wix code and the following method. You will have to adapt to your field names and dataset obviously.
Here is my code (NB: jobSummary, companyDescription, reviews, personSpecification are the field keys where the HTML is stored.
$w("#dynamicDataset").onReady( () => {
let jshtml= $w("#dynamicDataset").getCurrentItem().jobSummary;
let cdhtml= $w("#dynamicDataset").getCurrentItem().companyDescription;
let rvhtml= $w("#dynamicDataset").getCurrentItem().reviews;
let pshtml= $w("#dynamicDataset").getCurrentItem().personSpecification;
$w('#text10').html = jshtml;
$w('#text18').html = cdhtml;
$w('#text31').html = rvhtml;
$w('#text19').html = pshtml;
} );
});
The .html reference is here:- https://www.wix.com/code/reference/$w.Text.html#html
Providing you have all the p1, p2 etc tags in place then your text will appear exactly as the default p1, p2 etc styles which are set up in your wix site.
Hi all, I met with a couple of people yesterday to impress upon them the importance of this issue. One of our engineers saw the bug in action and is ready to investigate, but this may take a bit more time. I will keep the pressure on and hopefully (hopefully!) we'll move forward on this shortly...
Same issue! Frustrating...
I'm also having the same issue. This is a terrible technical issue to have. I can't tell which takes preceden over which, the sandbox or live data. Synching doesnt help...
Is it something affecting sites from previous versions of wix?
My understanding is that with code, classes take priority over stylesheets,anda when I download the data from my collections, there is all sorts of weird tagging and styles going on that just shouldnt be there, esp when I have set up a theme (class).
To me, it looks like a load of separate style declarations are being added to each paragraph as classes. This should override any stylesheets on the page, but then a bug is messing with that too!
Still same problem..... :-(
Having the same problem - rich text in the database loses its formatting. I copied the text from Word documents. I'll follow the advice above and hope it helps but it's going to be a problem with my clients updating their site and hope this is fixed very soon. The default styles should match those that I've set up in the rest of the site, not Proxima Nova (what's the point of different defaults in the database?).
Any news about that issue?
(I'm having the same problem with one of my clients)