Search Bars Too Sensitive
I have been getting all kinds of calls from users complaining about how sensitive the searches are when searching for companies, contacts, etc. Is there any way to adjust this in Quick Base or any ot...
Forum Discussion
Brandon
Are you referring to the search filter box on the top of reports? If so, there is a trick I can post back with which will allow you to search fields not on the report and also a way to search against a revised formula field name with the punctuation stripped out.
The other search tip is that you can filer at the top of reports using AND in upper case so you could search like
abs AND monro
to get hits on any company with abc in their name who is also in a city that contains monro, such as Monroeville
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Are you referring to the search filter box on the top of reports? If so, there is a trick I can post back with which will allow you to search fields not on the report and also a way to search against a revised formula field name with the punctuation stripped out.
The other search tip is that you can filer at the top of reports using AND in upper case so you could search like
abs AND monro
to get hits on any company with abc in their name who is also in a city that contains monro, such as Monroeville
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Hello Mark,
Yes, it would be best if I could use this for the filter box and the search boxes that you can place on Dashboards as well. I think that formula field would be useful for sure!!
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
Yes, it would be best if I could use this for the filter box and the search boxes that you can place on Dashboards as well. I think that formula field would be useful for sure!!
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
- Ok, I will post back later today when I get a chance.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- OK so two separate issues. We need a search target field which will strip out punctuation. Then ideally we want the Filter box on top of table reports to be able to search that field even though it is not on the report. For performance reasons, that filter box only filters for fields on the report.
Let make a search target field with punctuation stripped out.
Here is an an example for a field called [Company Name Search Target] you can try. The idea would be to tell your staff to not put in punctuation when searching
var text ReplaceDotsWithNull = SearchAndReplace([Company name],".","");
var text ReplaceCommaWithSpace = SearchAndReplace($ReplaceDotsWithNull,",", " ");
var text ReplaceDashWithSpace = SearchAndReplace($ReplaceCommaWithSpace,"-", " ");
$ReplaceDashWithSpace
...... Then the next step is how to get the report to search on that field.
The trick if to create afield called [.] (just a dot.
The formula for a Rich Text field would be would be
var text URL =[Company Name Search Target];
var text Words = " ";
"<a name=" & URLEncode([Technique]) & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thank you, Mark. That did exactly what I needed it to do.
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
