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.
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 [@fi