Search Bars Too Sensitive

Question

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 other kind of solution? For example, we work with a company called Hill's Interiors, if you just search for Hills, this company does not show up in the results. I have informed users not to be extremely specific when searching, like adding the punctuation to Inc. or searching by typing "ABC, Co. Ltd." and so forth, but it still seems that there should be some leniency in the searches from the Dashboards, or the Filter bars at the top of reports for examples like that above, or if you have AB Company that may be input as A.B. Company.

------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------

markshnier__you · Answer

BrandonAre you referring to the search filter box on the top of reports?&nbsp; 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 likeabs AND monroto get hits on any company with abc in their name who is also in a city that contains monro, such as&nbsp;Monroeville------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

brandondrake · Answer

Hello Mark,&nbsp;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 GroupMonroeville OH------------------------------

markshnier__you · Answer

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
------------------------------

markshnier__you · Answer

OK so two separate issues.&nbsp; We need a search target field which will strip out punctuation.&nbsp; 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.&nbsp; The idea would be to tell your staff to not put in punctuation when searchingvar text ReplaceDotsWithNull = SearchAndReplace([Company name],".","");var text ReplaceCommaWithSpace = SearchAndReplace($ReplaceDotsWithNull,",", " ");var text ReplaceDashWithSpace = SearchAndReplace($ReplaceCommaWithSpace,"-", " ");$ReplaceDashWithSpace......&nbsp; Then the next step is how to get the report to search on that field.The trick if to create afield called [.]&nbsp; (just a dot.The formula for a Rich Text field would be would be&nbsp;var text URL =[Company Name Search Target];var text Words = " ";"&lt;a name=" &amp; URLEncode([Technique]) &amp; "&lt;/a&gt;"------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

brandondrake · Answer

Thank you, Mark.&nbsp; That did exactly what I needed it to do.------------------------------Brandon Drake JHI GroupMonroeville OH------------------------------

Forum Discussion

Search Bars Too Sensitive

6 Replies

Related Content

Home Page Search Bug

Stacked Bar Chart

Google Search is back

Search Bar help

Search Options

Recent Discussions

Question about relationships

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?

Looking for Consultant: Add time tracking to existing task management app.