Forum Discussion

MaryPearl's avatar
MaryPearl
Qrew Member
9 years ago

How can I minimize my search to just specific tables?

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

  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    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