Skip to main content

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.

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)


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


Reply