Custom Field Showing Value on Report instead of matching Drop Down choice | Community
Skip to main content
S
Stacey_Robertson
Level 5
October 10, 2022
Question

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

  • 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

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

2 replies

KellieGardner
Community Advisor
KellieGardnerCommunity Advisor
Community Advisor
October 12, 2022

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

S
Stacey_RobertsonAuthor
Level 5
October 12, 2022

It is an assignment report

KellieGardner
Community Advisor
KellieGardnerCommunity Advisor
Community Advisor
October 12, 2022

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. 

J
JonnyMathias21
New Member
January 24, 2024

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

 

Terms & ConditionsAccessibility statement

Loading footer...