Use Java to Show Display Value

[braxwell]

Hello Caspio Friends,

Im wondering if this is possible.  I have a submission page that uses a dropdown.  The dropdown is set to have a value for Display, and and Actual Value.  I now would like on a reports page to place code inside an html block to display the value in that field.  The rub is I want to to show the Display Value, not the Actual Value.   Is there a way I can do this?

Thanks in advance.

 

[Aether]

Hello @braxwell, what I suggest is to use a "Calculated Field" instead and add a condition for the result.

For example:
 

CASE

WHEN ( [@field:Fieldname] = "one")
THEN 1
WHEN ( [@field:Fieldname] = "two")
THEN 2
WHEN ( [@field:Fieldname] = "three")
THEN 3

END

For more information, check this documentation: 
https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

I hope this helps

~WatashiwaJin~