Skip to main content
Nintex Community Menu Bar

Show sharepoint list Calculated Column on Nintex View form

  • August 16, 2019
  • 1 reply
  • 60 views

Forum|alt.badge.img+1

Hi... I am new on nintex form i want to show sharepoint list calculated column on nintex display form .

when i am serch some post regarding that i recognised there is action of "CalculatedValue" But i am not sure how to use my rule in calculatedValue.

below my calculted column formula-

=IF([Strategic Client]="Strong","5",IF([Strategic Client]="Medium","2",IF([Strategic Client]="Low","1")))

 

how to use that in calculatedvalue. thanks in advanced

 

 

1 reply

Forum|alt.badge.img+9
  • August 20, 2019

I suggest in the form properties for the field the following:

  • set the column as Read-only
  • in the Default value field insert the following in the Formula popup window:

ifElse(contains([Form].[Strategic Client],"Strong"),"5"
    ,ifElse(contains(Form.[Strategic Client],"Medium"),"2"
        ,ifElse(contains([Form].[Strategic Client],"Low"),"1"
            ,"")))