Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won

  1. Our submission form is being used to add new records to our database. On the submission form there are several required fields. When previewing the form in Caspio, we receive a 'You did not enter valid information in one or more of the fields.' if we didn't. We have embedded the form in our website, and if we leave any required fields blank, the submission form goes to a homepage rather than alert to missing information. Currently in Caspio Preview - Enter good info on submission form, page accepts (I assume, nothing loads, page just clears out) Enter incomplete info on submission form
  2. We are have created a two web page setup that allows us to do a keyword search across the database. The field in question is 'keywords', and is a virtual field. The challenge is, we would like to capture the search terms being entered in the 'keywords' field and save them to another table. Is this even possible? We are getting stymied by the virtual field aspect - how to maintain it as a virtual field, but also capture the data entered there. Suggestions? Thank you!
  3. It worked great! We had to make one small change, since our first virtual field was designed to search across the database...but your instructions helped a ton. We've been able to get the search page set up the way we want and it seems good to go. Thanks again for your response!
  4. Thanks for responding. Fields are: Search Phrase ___________ Author ___________ Title __________ Our goal is: User enters 'clutter' in Search Phrase and returns 22 records, all of which contain 'clutter' somewhere in the record. User enters 'clutter' in Search Phrase AND 'Franks' in Author and returns 5 records authored by 'Franks' AND containing the phrase 'clutter' Our reality is: Currently when the user enters 'clutter' in Search Phrase AND 'Franks' in Author the database returns 27 records - all records containing 'clutter' and all records authored by 'Franks' I can'
  5. Our database is designed to retrieve journal/magazine/etc. articles related to the user search term. We have used the guides for 'How to do a keyword search across multiple fields' and 'Separate Search Page and Results page' to create our search and results forms. Our search form currently allows users to search across the database using one entry/search field 'Search Phrase'. We want to add additional boxes to our search form to refine the search - search for specific author, title, etc. We can add these additional search fields but when we do, the results page returns ALL database
  • Create New...