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