Using Open URL to show only certain records in a view
HI -
My overall goal is basically that I want to create a way for someone to be able to search my database dynamically by choosing certain responses that pertain to them from 4 fields... sometimes they may enter info into all 4 fields, sometimes not (for more general results) and one is a text field that they would enter keywords that I want to find in my "tags" field in the database....
To start - I created a stateless form to use as a "searchable" form to open my db view and see only records that pertain to information entered in the stateless form. I am trying the method of using the "open URL" script "On Click" and entering the criteria...However, it doesn't seem to be working. I keep getting the error that the view does not exist (though I've double-checked spelling, caps etc)...
I have a few questions... is this the best method to get this done? I'm just trying to create a search option to access my database....If so, how do I handle issues where the user may leave one of the fields blank? How do I handle writing the script so that it can allow for certain words to be found?
Help? Please? THANKS!!!! I 've really been impressed with what I've been able to do so far with this product...as I"m working my way through...but I"m constantly getting stuck trying to figure out teh best ways to do things...not being a programmer (and I guess, not being very good at logic ;) )