So sometime may be five or 10 years ago the brain trust that QuickBase decided that when searching a table report they were only going to search fields that were both flagged as searchable and also were listed on the report. Prior to that if you had 1,000 fields in your table QuickBase would search on 1,000 fields and that was causing performance pain.
So how do we add extra fields into the search which are obscure like maybe a phone number or a postal code that you don't want to list on the report as it would cause too much clutter.
"no problem".
Make a formula rich text field which includes a string of all of the extra fields that you want searched. This this field will appear blank to the naked eye but in fact includes that hidden text and will be searchable. If you name the field either natively or rename it on the report with say a space or a dot and locate it at the far right side of the report, I guarantee you nobody will ever ask what that funny skinny blank column is at the end of the report.
var text URL = list(" ", [Extra Field to be search #1], [Extra Field to be search #2], [Extra Field to be search #3]; // build a string off all the extra fields to search.
var text Words = " ";
"<a name=" & URLEncode([Technique]) & "</a>"
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
