Clean up Searchable fields - best practices
Hello, I would like to clean up my searchable fields, assuming this will improve QBASE performance. Any suggestions on what field types definitely don't need to be searchable? thx -------------...
Forum Discussion
Is there a way to "uncheck all"? I have 2500+ fields in my Jobs Table. Very tedious to uncheck one-by-one.
Thank you
------------------------------
BuildPro
------------------------------
Thank you
------------------------------
BuildPro
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendI do not think there is a way to uncheck all. What I would do is go through each of those tables with very high field counts and set up the default report meaning the columns that are most useful most of the time. And then I would one by one go through just each of those fields to decide which ones are searchable.
When you are searching on a table report which is the most common kind of report QuickBase will only search the fields that are on the report so arguably for performance it's not super necessary to uncheck searchable on every single field but rather unchecked searchable on fields which are commonly used on table reports.
Of course if you have set up search icons on the dashboard then you might be searching against all the fields unless you limit the search icon to only search on a particular report.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
When you are searching on a table report which is the most common kind of report QuickBase will only search the fields that are on the report so arguably for performance it's not super necessary to uncheck searchable on every single field but rather unchecked searchable on fields which are commonly used on table reports.
Of course if you have set up search icons on the dashboard then you might be searching against all the fields unless you limit the search icon to only search on a particular report.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------