Forum Discussion
JenniferHall
Qrew Member
Both fields are text fields with the same settings.
------------------------------
Jennifer Hall
------------------------------
------------------------------
Jennifer Hall
------------------------------
MarkShnier__You
3 years agoQrew Legend
Hmm, 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
------------------------------
- JenniferHall3 years agoQrew MemberThere 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__You3 years agoQrew LegendYou 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
------------------------------- JenniferHall3 years agoQrew MemberIt looks like there are 457 Division IDs.
------------------------------
Jennifer Hall
------------------------------