Forum Discussion

TaraStroup's avatar
TaraStroup
Qrew Member
4 years ago

Dropdown choice different than report response

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
------------------------------
Formulas and functions
Tables and fields

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 years ago
    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
    ------------------------------
    • TaraStroup's avatar
      TaraStroup
      Qrew Member
      4 years ago
      Simple multi choice field.

      ------------------------------
      Tara Stroup
      ------------------------------
  • AustinK's avatar
    AustinK
    Qrew Commander
    4 years ago
    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",
    ""
    )