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

asked on July 11

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

What version of Workflow are you using?

1 0
replied on July 12

10.4

0 0
replied on October 25

Any updates on this?

0 0
replied on October 25

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 Show version history

Thank you, Miruna! 

 

For future me and others...

Use PLAINTEXT in the apply formatting section.

%(RetrieveBusinessProcessVariables_Rich_Text#"PLAINTEXT"#)

Documentation here.

1 0
replied on October 25 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
You are not allowed to follow up in this post.

Sign in to reply to this post.