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

Question

Question

We are trying to save the contents of a Rich Text field into SQL

Workflow Forms
Updated December 15, 2023
asked on July 11, 2019

Normally we would use WorkFlow to save the form content to SQL.  However, Workflow skips over the Rich Text fields I have and does not write any data.  There are no errors though.

In addition, when I view the fields from within WorkFlow, they type for all my Rich Text is simply '??'

I am guessing the issue is Workflow does not support pulling Rich Field data.  Is there a way to accomplish saving Rich Text field data into SQL?

Thanks

0 0

Replies

replied on July 11, 2019

What version of Workflow are you using?

1 0
replied on July 12, 2019

10.4

0 0
replied on October 25, 2019

Any updates on this?

0 0
View 3 previous replies
replied on October 25, 2019

This is working as expected in Workflow 10.4. Data in rich text fields needs to be formatted to plain text when passed into anything that does not support rich text. If not formatted, then the data will include the HTML code.

The Tokens tab in the instance details will show the HTML code version. I'm not seeing "??" anywhere.

Please open a support case if the behavior you're seeing is different.

1 0
replied on October 25, 2019 • Show version history

Thank you, Miruna! 

 

For future me and others...

Use PLAINTEXT in the apply formatting section.

%(RetrieveBusinessProcessVariables_Rich_Text#"PLAINTEXT"#)

Documentation here.

4 0
replied on October 25, 2019 • Show version history

I corrected your syntax in the post above because the article was wrong (a case of Word smart quotes not being rendered properly as HTML). Sorry about that. The formatting syntax is plain PLAINTEXT, not ?PLAINTEXT?. The article was also fixed.

0 0
replied on December 7, 2023

@████████ is the PLAINTEXT documented in the help files? I wasn't able to find it, only in the List of Changes for Workflow 10.4.

0 0
replied on December 15, 2023

Yes, it is documented here.

0 0
replied on December 15, 2023

Ah, thank you. Could it be added to the Tokens\Token Formatting area of the help documentation as well since that is where all the formatting information is? I never would have thought to check the area of the help that you sent.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...