Drop down filter vs user input filter
The filter for the District Name column is a drop down that the user can choose a selection from whereas the Division ID column the user types in what they are searching for. How would I go about ...
Forum Discussion
Both fields are text fields with the same settings.
------------------------------
Jennifer Hall
------------------------------
------------------------------
Jennifer Hall
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendHmm, can you tell me how may unique choices there would be for that field? There may be a limit if there are too many choices - not sure what "too many" is. Also is the field properties set to be "searchable"?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- There are over 171,000 records so I am not sure how many possible choices there are for the Division ID and yes the field properties are set to searchable.
------------------------------
Jennifer Hall
------------------------------- MarkShnier__YouYou can find out how many unique choices there are on the table by creating a summary report and grouping by that department ID number field. But my suspicion is that you have too many choices.
One clue that could be when the report loads and you put your cursor into that filter box, if it spins for a while and then stops that meant that it decided that there were too many choices.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- It looks like there are 457 Division IDs.
------------------------------
Jennifer Hall
------------------------------