Discussions

Expand all | Collapse all

How do I add a formula field to a dynamic filter

  • 1.  How do I add a formula field to a dynamic filter

    Posted 04-11-2016 15:10


  • 2.  RE: How do I add a formula field to a dynamic filter

    Top
    Contributor
    Posted 04-11-2016 15:53
    Hi Shontay,

    Unfortunately formula fields cannot be used as dynamic filters currently.  You can read more about this from our Help topic here:

    http://www.quickbase.com/user-assistance/#dynamic_filters.html


    Good news however!  Our Engineers are working on deploying this functionality during one of our upcoming releases. Be sure to keep an eye out for our release notes!

    http://quickbase.intuit.com/quickbase-blog


    Brendan


  • 3.  RE: How do I add a formula field to a dynamic filter

    Posted 04-12-2016 13:32
    Thanks


  • 4.  RE: How do I add a formula field to a dynamic filter

    Posted 06-05-2017 23:51

    Can you filter columns in Grid Edit?  Any assistance would be  appreciated

    Veronica



  • 5.  RE: How do I add a formula field to a dynamic filter

    Posted 06-06-2017 00:01
    You can filer the report and then go into Grid Edit mode,  but you cannot filter while in Grid Edit mode.


  • 6.  RE: How do I add a formula field to a dynamic filter

    Posted 07-23-2018 19:49
    Is this feature coming any time soon?


  • 7.  RE: How do I add a formula field to a dynamic filter

    Posted 07-23-2018 21:51
    That feature came a couple of years ago. But it will not work for numeric fields. 

    But if you know that the different numeric values will be limited, then you can make a formula text field to be the text equivalent of the number and then it will be eligible as a DF.


  • 8.  RE: How do I add a formula field to a dynamic filter

    Bronze
    Contributor
    Posted 03-26-2019 14:33
    I'm having an issue where I'm trying to use a formula text field, which the logic is based on a checkbox being checked or not... and for some reason the formula field isn't able to be added to the dynamic fields.

    Any idea why this would be the case?


  • 9.  RE: How do I add a formula field to a dynamic filter

    Posted 03-26-2019 14:53
    np, just edit the field properties and make it "Searchable"

    "Include this field when searching/filtering this table