Discussions

 View Only
  • 1.  Dynamic Filter - Field Not Available

    Posted 05-25-2023 13:56

    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
    ------------------------------


  • 2.  RE: Dynamic Filter - Field Not Available

    Posted 06-02-2023 14:02

    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
    ------------------------------



  • 3.  RE: Dynamic Filter - Field Not Available

    Posted 06-05-2023 07:20

    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
    ------------------------------



  • 4.  RE: Dynamic Filter - Field Not Available

    Posted 06-07-2023 14:46

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



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