How can I minimize my search to just specific tables?

  • 0
  • 1
  • Question
  • Updated 1 year ago
We have a ticketing app that is linked to a document  library app. I created a search button which when we select a product on  the ticket it will automatically search the related  document on the documentation library which has many tables.  

Our problem  is that, it will search  on all  the tables under the document library app. What we want is to search only on the Product, TroubleShooting, and Course table on  document library app.  

I attached a screenshot on that is happening when i click the search button.

Below is my  syntax:



var text customer =(If([Product Name]<>""

,URLEncode ("+OR+&")&[Product Name]));





If([Product Name]="E2"

or [Product Name]="E2E"

or [Product Name]="Site Manager"

or [Product Name]="Ultrasite"

,"https://emersonclimate-retailsolutions.quickbase.com/db/bk22afrvs?act=QuickSearch2&srchtxt="&[Concer..."

,"https://emersonclimate-retailsolutions.quickbase.com/db/bk22afrvs?act=QuickSearch2&srchtxt="&[Produc... Name]&"&srchWhich=_all")

Photo of Mary Pearl

Mary Pearl

  • 50 Points

Posted 3 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
Without building a custom 'search' code page to only canvas those three tables, I think the best native option is to add 3 different 'search widgets' to your dashboard.   Then just search those tables individually.

Not ideal, but maybe an easy work around for now.


Matthew Neil - Product Specialist
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
I'm wondering if Mary actually waited 2 years to get that answer.
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
#KnowledgeBase