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

Forum|Forum|3 years ago
October 10, 2022
2 replies
1168 views

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

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

KellieGardner

Community Advisor

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

S

Stacey_RobertsonAuthor

Level 5

It is an assignment report

J

jessicac_VG

Level 2

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.

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.

J

JonnyMathias21

New Member

We had a similar scenario (dropdown storing supplier name/ id in the key value pairs). I was able to get the value printed on an expense report using the text mode below.

displayname=Supplier Number
textmode=true
valueexpression={DE:Supplier}
valueformat=HTML

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded