Search function

[DirtyDamsel]

In my excel document I have different properties for an item listed out in each column and when I try to make a searchable database it will only search for that property if I search for it under that columns name.  Is there a way to search for one tag but have it search the entire excel sheet no mater where it's listed?  I have attached an example of my excel sheet as a reference.

Essential oil table.xlsx

[MayMusic]

You need to separate your search and report page into two pages. Here if the article: https://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/

[NailDyanC]

Hi, just to add to the previous comment above, I have also another workaround for this, it is for searching records across multiple fields in your table. What you need to do is add another field in your table and set it to Formula. Then, concatenate the fields you want to use. If all your field are in Text datatype , you can use [@field:FieldName1] + ' ' + [@field:FieldName2] + ' ' + [@field:FieldName3]........ on your Formula Field. Then, use this formula field as your search criteria. 

For more details, you may check this forum post: