Skip to main content
Question

Create a Dropdown from a Formula Field

  • September 18, 2020
  • 0 replies
  • 56 views
Hi,

I have created a formula field Year on the basis of Date Field and stores the year as 2019-2020 or 2020-2021 depending on the date entered which is working fine, however if i create a report and set this field to Ask the user then it does not show as a drop down, it just shows as plain text box to type the same which is not what i want.

I want it to show it as a drop down so that i can either select any one of them or can do multi selection. Is there a way as to how this can be done.?


Regards
Gunsham

------------------------------
Gunsham Lakhiani
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • September 18, 2020
One solution is just to make the hyphenated year field be a Dynamic Filter and have the user run the whole report and then use the DF to get their Year filter.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
  • GunshamLakhiani
  • Author
  • Quickbase Alumni
  • September 18, 2020
Hi Mark,

Thanx. I have already done what you are suggesting but would like to have it as a selection. Is there no way to do this?

Regards
Gunsham

------------------------------
Gunsham Lakhiani
------------------------------
Terms & ConditionsAccessibility statement