Skip to main content
Nintex Community Menu Bar

How to change the List view body column values dynamically

  • September 11, 2018
  • 2 replies
  • 13 views

I had a scenario that smart object will pull only 1 & 2  & 3 values in a column. But I need to show them as 1 as Male and 2 as Female and 3 as Transgender.

 

Please guide.

2 replies

Forum|alt.badge.img+15
  • Scholar
  • September 11, 2018

You have a couple of options here... what is this SmartObject hooked into that provides this data? If it is  SQL database, I'd recommend creating a Stored Procedure to generate the data how you want it so no extra logic is needed on the SmartForm (hook the SmartObject into this Stored Procedure and consume it directly on your list view)


Forum|alt.badge.img+9
  • September 12, 2018

Hi gelli2016,


 


This should be possible with an expression, but you wont be able to create a expression on the existing column, so create a new column.


On the column, select the body tab and click on Expression:



 


The expression should look something like this:


-Jean