MaryPearl
9 years agoQrew Member
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")

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