Expand my Community achievements bar.

Custom Field Showing Value on Report instead of matching Drop Down choice

Avatar

Level 5

I am creating a report that shows a value chosen from a custom field (drop down menu).  That custom form has values showing that don't match the drop down selection (for example - it shows designer name on the drop down and the value is their ID).  The report is defaulting to showing the value, is there a way that I can show the ID?  My text mode is shown below:

displayname=Project Lead
querysort=project:program:DE:Primary Designer
textmode=true
valuefield=project:program:DE:Primary Designer
valueformat=HTML

4 Replies

Avatar

Community Advisor

Hi Stacey what kind of report are you running? Project, task, etc?

Kellie Gardner

Avatar

Community Advisor

To my knowledge it's not possible to do.

 

Since you can't pull in a program value naturally in an assignment report and are using text mode already there isn't a way to get it back to the actual choice vs the value without using a series of IF statements. Hopefully someone else can weigh in to help. 

Kellie Gardner

Avatar

Level 1

I am working on a nested IF statement to solve a similar problem, but would love to here if there is another option. The same issue occurs on a journal entry report when a typeahead field text is changed.