Skip to content
Loading...

Calculated field for Choice field

Title

Calculated field for Choice field

Description

Calculated field for Choice field

Please wait...

I have a list with two Choice fields – Modula and Section (checkboxes)

I’ve created Calculated filed in qListForm web part that has the following formula: <%Section%><%Module%>

As a result I see the following in the calculated field ;#Section 1;#;#Module 1;#

Is there

Cause

<p><span style="text-align: left; widows: 2; text-transform: none; background-color: rgb(255,255,255); text-indent: 0px; display: inline !important; font: 12px Arial, Helvetica, Verdana, sans-serif; white-space: normal; orphans: 2; float: none; letter-spacing: normal; color: rgb(51,51,51); word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px">The expression <%FieldName%> returns the raw value of the field as it's stored in SQL database</span></p>

Resolution

<p><span style="text-align: left; widows: 2; text-transform: none; background-color: rgb(255,255,255); text-indent: 0px; display: inline !important; font: 12px Arial, Helvetica, Verdana, sans-serif; white-space: normal; orphans: 2; float: none; letter-spacing: normal; color: rgb(51,51,51); word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px">You can put JavaScript function that would extract the value out of these fields and then apply the calculation formula.</span></p>

Defect ID

<p><span style="text-align: left; widows: 2; text-transform: none; background-color: rgb(255,255,255); text-indent: 0px; display: inline !important; font: 12px Arial, Helvetica, Verdana, sans-serif; white-space: normal; orphans: 2; float: none; letter-spacing: normal; color: rgb(51,51,51); word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px">The expression <%FieldName%> returns the raw value of the field as it's stored in SQL database</span></p>

Leave a Reply