How can I search fields within a table from the table home page?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a table for "Companies" and within each entry are separate fields to list subsidiaries (for example: "Subsidiary 1", "Subsidiary 2", etc.).

The point of having these subsidiary fields is so that we can search for a subsidiary name in the Company Table Homepage and the associated company will filter.

I used to have no problem searching for the Subsidiary field within the Company table, however now it doesn't seem to recognize my search.

Has Quickbase made a change to search capabilities?

I could add the Subsidiary fields to the Default columns in the homepage, but there are 40 separate fields and it would make my report far too long.

Photo of Brittany


  • 210 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Yes, QuickBase did make a change maybe 2 or 3 months ago.

The current behaviour is that the filter box at the top of a report will only search fields which are columns visible on the report and which are marked as being searchable.  I presume they did this for performance reasons, and most users never made any fields non searchable, and as a result in general, filtering was getting to be too slow, especially on larger databases as every field on every record on the report was being searched.

Here are some ideas.  

1. Add a single formula field which is a List (  ) function of all 40 fields and include it on the report. Upside is stupid simple. downside is clutter on the report.

2. Put in a Search element on your Application Dashboard home page. 

3. This is one I just thought of which is a pretty neat work around

Make a new formula text field with html enabled field called Search Subs

var text URL = List(" ", [sub 1], [sub 2], [sub 3]);

var text Words = "";

"<a href=" & $URL & ">" & $Words & "</a>"

so... cool, the field is really skinny, but in fact does contain the concatenated list of all 40 Subs :)  Of course the URL target is bogus, but who cares,  There is nothing to click though so no user will be able to try to navigate to the bogus URL.
Note tested but there is also an HTML element which is also invisible to us humans called an anchor tag.  It is used on web pages as a jump target to link to a spot on the page.  So this would be a bit less code.

var text Subs = List(" ", [sub 1], [sub 2], [sub 3]);

"<a name=" &  $Subs & "></a>"