You are viewing limited content. For full access, please sign in.

Question

Question

Rich Text format in Laserfiche Forms Reports

Forms Version 10 How To
Updated May 14, 2020
asked on May 14, 2020 • Show version history

We are using a form to gather information to dump down in a report that is scheduled to run once a week.  When it came through last night, I noticed when the rich text field comes into Excel, it includes many HTML tags, (<table border="0" width="501"><colgroup><col width="501"></colgroup><tbody><tr>).  Is there an easy way to allow them to use the rich text field, but flatten it for reports so that it's easier to read?  

Any help or guidance would be greatly appreciated.  Thanks!

0 0

Replies

replied on May 14, 2020

It looks like that form was submitted with a table in the RTF field. How would you want that to be converted to flat text? 

When saving metadata fields to the repository and passing fields to WF, we have an option to convert the RTF data to plain text. It might be worth a try to see what that field looks like after that plain text conversion. We don't have this functionality when sending data to a report. 

If you save an RTF field to the repository as plain text and like the way that looks better, one workaround would be to run a WF that grabs the plain text of the RTF variable and stores it back into another single line variable. Then use that single line variable in your reports. 

 

1 0
View 1 previous reply
replied on May 14, 2020

Thanks for your response, Jared.  I wasn't referring to just this one submission.  Something as simple as an indent or bold text still includes the HTML tags in the reports from Forms.  I thought there may be an easier way to make it come down as plain text without having to go through workflow.  I just went in the spreadsheet and performed a find and replace to get rid of the tags.  Much simpler than building out that workflow.  Thanks for the advise.

1 0
replied on May 14, 2020

Also jumping in here @████████ to say we recently came across the same thing. Hadn't noticed this issue before but we also haven't used Rich Text fields a lot. If the content could be stripped of all HTML and tags and into plain text - as an option (similar to "included choices") at the point of export, that would be ideal.

1 0
replied on May 14, 2020

Sure, we can look into extracting plain text from RTF in the data reports. 

1 0
replied on May 14, 2020

Thanks!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...