How do I add a formula field to a dynamic filter

  • 1
  • 2
  • Question
  • Updated 4 months ago
  • Answered
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 1
  • 2
Photo of Brendan

Brendan

  • 40 Points
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
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
Thanks
Photo of Veronica Caban

Veronica Caban

  • 60 Points

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

Veronica

You can filer the report and then go into Grid Edit mode,  but you cannot filter while in Grid Edit mode.
Photo of Kevin Strong-Holte

Kevin Strong-Holte

  • 60 Points
Is this feature coming any time soon?
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.
Photo of Ryan Stanford

Ryan Stanford

  • 1,662 Points 1k badge 2x thumb
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?
np, just edit the field properties and make it "Searchable"

"Include this field when searching/filtering this table"