Hi - New Caspio user here...I have a database that was created in MS-Excel with records for research citations that I want others to be able to search. The original file has multiple keyword fields so that people could use drop-down boxes to select more than one keyword. In Excel, this was represented as three columns with headers Keyword 1, Keyword 2, and Keyword 3. Now in Caspio I really want just one search term - Keyword - that will look up the same value for any of the three keyword fields in the database. So...the search term for Keyword is "Resiliency" and Caspio searches the three data table fields Keyword 1, Keyword 2, and Keyword 3 and returns any record that has the term "Resliency" in ANY of the three keyword fields. Right now there are three keyword fields, one for each of the three keyword columns in the database.
Thank you for any help you can offer.