Forum Discussion

EmberKrumwied1's avatar
EmberKrumwied1
Qrew Trainee
4 years ago

Report filter not showing as a pulldown list

New to Quickbase...I am trying to create a simple report that prompts the user for a entry name.  I have set that field to be the filter and set it to <ask the user>.  When I run the report all I get ...
Relationships
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
Is the Company field just a Text field or is it from another Table?

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
EmberKrumwied1's avatar
EmberKrumwied1
Qrew Trainee
4 years ago
It is just a text field.  I have since learned, from a different source, that what I am hoping to accomplish can not be done.  This is a text field and even though it is set to be unique, the table holds over 300 entries.  Pull down lists are limited to 100 entries, and that's even if the field could be converted to a pull down option.  Seeking other solutions to achieve similar result.

------------------------------
Ember Krumwied
------------------------------
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    4 years ago
    I would encourage you to start by making the Company data a separate table.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • EmberKrumwied1's avatar
      EmberKrumwied1
      Qrew Trainee
      4 years ago
      Thank you Blake, the Company is a separate table, its just that the table holds over 300 companies.

      ------------------------------
      Ember Krumwied
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        4 years ago
        What Blake means is that you should be setting up a relationship where One Company has many  "records" ie whatever your detail records are now.

        Is you company field on the details record a multiple choice field with he choices pulled from the Companies table?  ie how does it work in data entry on a record now.  Where does the company choice come from there?

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