I have a Files object with 12,000 records and 300 File Types. “File Type” is a multiple choice multi-select field in the Files object with 300 options.
Out of the 300 File Types, 15 are “Key File Types.” I want to create a search engine so users can search for records that are “Key Files.”
Is there a way to do this without creating an additional field and simply by limiting the options users can search for in the 200 File Types down to 15?
I originally tried to do this by setting up a separate field called “Key Files” and using conditional rules to “add” specific “Key File Types” when the File Type field was populated with any of those 15 options, but I run into problems when some files contain multiple key file types and Knack will sometimes add some Key File Type options but not others. I have double-checked and the conditional field logic is correct.
