cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Calculated Value Displaying html tags

Jump to solution

I have a bilingual form. Instead of regular labels, I used calculated value control to display the appropriate language. All works fine. However, when I select the item to view it, it also shows the html tags (see image).

Can someone please advise how to prevent the html tags to display in view item?

Thank you.

Labels: (1)
Reply
12 Replies
Workflow Hero

Re: Calculated Value Displaying html tags

Jump to solution

could you post a formula how do you "calculate" translation?

have you enabled to recalculate in VIEW mode for the control?

0 Kudos
Reply
Workflow Hero

Re: Calculated Value Displaying html tags

Jump to solution

Hi Emha,

I have a separate list containing the text in each language. So, in the form I use the following formula to call the appropriate text:

lookup("FormLabels","FieldKey","Name",calcFormLanguage<javascript:void(0);>)

Thanks for your help.

Glenda

0 Kudos
Reply
Workflow Hero

Re: Calculated Value Displaying html tags

Jump to solution

Hi ‌, do you think you can share how do you get the output column? or how calcFormLanguage looks like? is this a JavaScript function?

0 Kudos
Reply
Workflow Hero

Re: Calculated Value Displaying html tags

Jump to solution

this syntax seems to me suspicious. is it really the way how you use it.

if I try construct like this it just generates error.

can you post screenshot of your configuration?

as well clarify what "calcFormLanguage" and how does it exactly look like.

Reply
Workflow Hero

Re: Calculated Value Displaying html tags

Jump to solution

I have a calculated value control to save the value that the user selected. It is not a JavaScript function.

0 Kudos
Reply
Workflow Hero

Re: Calculated Value Displaying html tags

Jump to solution

Marian,

See below the configuration I used.

0 Kudos
Reply
Workflow Hero

Re: Calculated Value Displaying html tags

Jump to solution

ok, these configurations seems to be correct.

how do texts look like in list view? I assume you do not store there HTML markups by purpose...

what's datatype of field you read texts from? isn't it by any chance multiline text with reach text enabled?

can you try following formula to determine whether markups are return from lookup function or added in form

"x" + lookup("FormLabels","FieldKey","Name",calcFormLanguage) + "x"

0 Kudos
Reply
Workflow Hero

Re: Calculated Value Displaying html tags

Jump to solution

Hi Glenda Lopez‌, can you refer to the item inside list FormLabels with FieldKey column equals Name?
What is the value inside English column for that item?

0 Kudos
Reply
Workflow Hero

Re: Calculated Value Displaying html tags

Jump to solution

I was able to resolve the mystery. I am using multiline text fields "Rich Text". Once, I changed to "plain text" the display was clean without HTML codes. 

The only down side is that I will not able to show a nice format in the form.

Anyways this will work for now, but if any of you find a way of using multiline text "Rich Text" on bilingual forms please let me know.

Thanks.

0 Kudos
Reply