Discussions

Expand all | Collapse all

Create a Dropdown from a Formula Field

  • 1.  Create a Dropdown from a Formula Field

    Posted 09-18-2020 12:25
    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
    ------------------------------


  • 2.  RE: Create a Dropdown from a Formula Field

    Posted 09-18-2020 12:30
    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
    ------------------------------



  • 3.  RE: Create a Dropdown from a Formula Field

    Posted 09-18-2020 12:40
    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
    ------------------------------



  • 4.  RE: Create a Dropdown from a Formula Field

    Posted 09-18-2020 16:01
    Edited by Mark Shnier (YQC) 09-19-2020 11:27


  • 5.  RE: Create a Dropdown from a Formula Field

    Posted 09-19-2020 11:13
    Hi Mark,

    Sorry but i could not get what you are trying to say.

    The formula field Year is in the same table where the data is created so how does relationship come in the picture.  I just need a list of the years which keep getting generated thru the formula where i should be able to select either one or multi.


    Regards
    Gunsham

    ------------------------------
    Gunsham Lakhiani
    ------------------------------



  • 6.  RE: Create a Dropdown from a Formula Field

    Posted 09-19-2020 11:29
    Edited by Mark Shnier (YQC) 09-19-2020 11:29
    I'm sorry, but I posted the response to the incorrect question.

    I do not know how to make the <ask the user> be a drop down in your use case.

    I am instead suggesting just to have the user run the full report without the <ask the user> and then show the first Dynamic filter to be the Year field

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------