Jump to content
  • 0

text search multiple fields




How can I implement ONE input search text field and display results based on multiple fields in my database?

For example, my database includes Restaurant Name, City and Cuisine Type (i.e., Italian, Chinese, etc.).

I would like the user to enter their search into ONE text field (it can be multiple words) and for Caspio to display the results that contains these words based on the 3 fields listed above.


Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

You can do the keywords search by creating two DataPages. It is similar to this tutorial:http://howto.caspio.com/parameters/in-action/in-action-search-page-and-results-page-in-two-different-webpages.html

1. Create a Web Form for searching field.

2. Create a Search and Report Page to display the results. Please note on the Select Filtering Fields screen, push all the searchable fields to the right panel (all the fields you would like to be accessible to your users). Set the Logical Operator in the right bottom into OR.

Link to comment
Share on other sites

  • 0

Hi, just to add to the previous comment above,  As I understand, you want to create a search form which can search to all the fields, right? If that is the case, you may also check this link:  https://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/

I have also another workaround, on your table, add another field and set it to Formula. Then, concatenate the fields you want to use in your report. 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, it should look like the attached screenshot. 

I hope that helps.

Power search.png

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...