Jump to content
  • 0

Search function



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

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

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:  


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...