Dynamic Filter - Field Not Available

Question

I have a table with a model year field that is a reference field in a relationship. It won't show up as available to use as a dynamic filter on reports. Any idea why not? There are only 21 model years (all unique).

I have tried using a formula field to change the data type of the model year from number to text. No dice.

I added another field that is a duplicate numerical field named model_year that is not a reference field nor is it part of any relationship. It won't show up either? I tried changing this field to a text field and it still didn't show up.

The field is available to select as an x or y axis variable. I don't understand what the issue is.

It doesn't appear to be because of a feature limitation:

------------------------------
Adam Keever
------------------------------

chelseacarpent2 · Answer

Hey Adam,
There is a table in the Help article "Using dynamic filters" called Quickbase field types used for dynamic filters. It includes columns for Reference and Lookup fields. If you see your field type with a Y in the Reference Field column, and it's not working, then please open a support ticket.------------------------------Chelsea Carpenter------------------------------

adamkrzyzanek · Answer

Adam,
Many times I struggled with this when I tried to optimize my app and make fields "not Searchable".
Check field parameters and make sure below options are "checked"------------------------------Adam Krzyzanek------------------------------

adamkeever1 · Answer

Thanks @Chelsea and @Adam. I didn't have the searchable checkbox checked for my text fields. Easy fix!------------------------------Adam Keever------------------------------

Forum Discussion

Dynamic Filter - Field Not Available