topic Re: Report Temaple experession to return select_one name instead of label? in ArcGIS Survey123 Questions

Report Temaple experession to return select_one name instead of label?

VirajP — Thu, 12 Jul 2018 23:15:29 GMT

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?

Re: Report Temaple experession to return select_one name instead of label?

Anonymous User — Wed, 18 Jul 2018 06:19:26 GMT

Zhifang Wang‌ Can you please look into this and update user if it is currently possible? Otherwise can we create as possible enhancement request to use a parameter?

Re: Report Temaple experession to return select_one name instead of label?

ZhifangWang — Thu, 19 Jul 2018 10:31:05 GMT

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).

Re: Report Temaple experession to return select_one name instead of label?

VirajP — Thu, 19 Jul 2018 23:33:46 GMT

Worked like a charm, thanks. Where is the best place to find a listing of these functions?

Re: Report Temaple experession to return select_one name instead of label?

Anonymous User — Thu, 19 Jul 2018 23:56:19 GMT

Hi Adam,

You can find the supported expressions in the Survey123 Online Documentation: Print survey results—Survey123 for ArcGIS | ArcGIS

Phil.