Skip to main content
Question

Dropdown choice different than report response

  • February 10, 2021
  • 0 replies
  • 54 views
Hello,

I would like it if the dropdown on the form was "plain english" and the report showed the short hand for example: 

If the choice was
Earning I need a report to return E
Deduction I need a report to return D

Is there a formula to do this in for a drop down or an automation I am missing? 

Thanks, 
Tara

------------------------------
Tara Stroup
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Is this drop-down from a simple multiple-choice field or is it from a relationship?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
  • AustinK
  • Registered
  • February 10, 2021
You could create a formula field on the table or even a report text formula that takes into account what is shown in your dropdown field. The problem is it is going to be awful to maintain this as it just text matches things. So when a new option is added to the dropdown you will also need to update the formula. Same if you change an option in the dropdown.

If(
[Dropdown] = "Earning", "E",
[Dropdown] = "Deduction", "D",
""
)
Terms & ConditionsAccessibility statement