Jump to content

Toby

Members
  • Content Count

    1
  • Joined

  • Last visited

  • Days Won

    1
  1. Hi I am new to using Caspio and would appreciate some help building a form and report which searches across 4 language database entries (L1-L4). I need 9 language search boxes in 3 columns (this will be expanded later to allow more parameters). The logical connection between each of the four boxes in each column vertically is AND and the relation between the 3 columns horizontally is OR. For example, to find people in the database who speak English and German and/or Spanish (and any combination of these), would look like on the search form: English English English AND AND AND Spanish OR Spanish OR German AND AND AND German [no selection] [no selection] I have built the form datapage using virtual fields to try to pass on to the report but I am struggling at this point. I can see that it is easy to have one search box searching records in L1-L4 using virtual fields, but not multiple search boxes searching multiple records in L1-L4. I have already looked at the various tutorials and guides on the caspio site but I cannot work this out. My general query is: is this possible? My more specific question is: is it possible to pass parameters from more than one virtual field to the report? More particularly, if, as in the case above, I have made no selection, can Caspio be told to ignore those fields for the purposes of the search? Many thanks for your help Toby
×
×
  • Create New...