11 Replies Latest reply on Sep 15, 2016 8:43 AM by walt105

    Best way to search multiple fields of one table?

    walt105

      On a layout I have added a custom search field and a button to start the search.

       

      It is easy to create a script to search one particular field in the current table.

       

      I have not found an obvious way to search a number of specific fields (or all the fields) of the current table only, with the term typed in the 'search field'.

       

      If I use a quick search it also looks in the portal that is on the layout, but that is not what I want, because it returns too many records.

       

      Any suggestions?

       

      Many thanks.