Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit is happening now. Discover what's next in customer experience.

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

Level 5

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

Avatar

Level 5

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. 

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.