gelli2016
Novice

How to change the List view body column values dynamically

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.

0 Kudos
Reply
2 Replies
tbyrne777
Contributor

Re: How to change the List view body column values dynamically

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)

0 Kudos
Reply
JeanSmit1
Apprentice

Re: How to change the List view body column values dynamically

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:


6749i7532B99EF43962A0.png


 


The expression should look something like this:


6751i322C17FC62D9B85D.png-Jean

Reply