Report Temaple experession to return select_one name instead of label?

VirajP

I want to pull the name value from my select_one list into the Report Template instead of the label:

The label looks great in the Survey123 app:

But I need the actual DB value (i.e. '9') in the Report Template instead of the verbose label ('<b>9</b> - Very Good, New Condition')

Alternatively is there an expression that will pull a specific character into the Word Doc report instead of the full label?

ZhifangWang

Hi Adam,

Yes, you can use ${fieldname1 | getValue:""} to get the raw value of an underlying field. For a string field with coded value domain, it will return the code, for a date field, it will return the Unix time.

For example, ${expertise} returns "None. I have never used it." (the name of the coded value domain) while ${expertise | getValue:""} returns "none" (the code of the coded value domain).