rmcginnis Posted July 12, 2010 Report Share Posted July 12, 2010 Hi I am trying to create an advanced search, but have not yet made any JS for searches. Here is an example of what I am wanting: Return results where: field7 Is Blank AND field8 Is Blank AND ( If (field1 Is Not Blank) Then (Field2 Is Blank) OR If (field3 Is Not Blank) Then (Field4 Is Blank) OR If (field5 Is Not Blank), Then (Field6 Is Blank) ) Has anyone had any experience coding such a search? If so, I would really appreciate your help. Quote Link to comment Share on other sites More sharing options...
bahar_vm Posted July 12, 2010 Report Share Posted July 12, 2010 Hi, Unfortunately Caspio does not have a combination of AND/OR queries capability yet. This is feature request in the list though and is scheduled for the second upcoming release by the end of this year. Thanks, Bahar M. Quote Link to comment Share on other sites More sharing options...
rmcginnis Posted July 26, 2010 Author Report Share Posted July 26, 2010 Thank you. I have managed to work it out with some JS coding and a few extra hidden fields. Where there is a will, there is a way!!!! I still look forward to the release... Quote Link to comment Share on other sites More sharing options...
JolliBeng Posted October 3, 2018 Report Share Posted October 3, 2018 Hello rmcginnis, You can now set Rules rules consisting of criteria and conditional actions on your forms. You may also refer to this link for the discussion of Conditional Forms. Hope this helps. -JolliBeng Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.