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?
Solved! Go to Solution.
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).
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?
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).
Worked like a charm, thanks. Where is the best place to find a listing of these functions?
Hi Adam,
You can find the supported expressions in the Survey123 Online Documentation: Print survey results—Survey123 for ArcGIS | ArcGIS
Phil.