Jump to content


  • Posts

  • Joined

  • Last visited

jimher's Achievements


Newbie (1/14)



  1. Hi there, I tried doing this but it doesn't seem to be working. The login page ends up just being blank. Can you confirm that all the code be you laid out is correct? Any suggestions on what I may have done wrong? Thanks.
  2. Hi KenDJPA, I have the same issue with you except I've set my other criterias with an AND operator and want the two fields set to OR. I was trying to follow your solution but don't understand how concatenating the two fields into a new field solves the problem. Can you help me with your code above? As I understand it, you've set up two virtual fields. The user inputs into those two fields and the values get's placed into USER1FIELD and USER2FIELD which are then concatenated into COMBINEDFIELDNAME. At this point I'm lost and not sure how you were able to search by COMBINEDFIELDNAME. Thanks for your help. If others can chime in also, I'd appreciate it. Jim
  3. Hong, Thanks for the reply but don't think this will work since I have a large number of values and it won't look attractive on the search form. I've given up and will go to using the search/result on the same datapage. Not ideal but don't want to spend more money on coding services for this. It would be nice if Caspio just provided a solution for this since it appears others are having similar issues.
  4. Amen Skyforum. It is frustrating. I've posted a question about multi-select listboxes and I haven't gotten a workable answer. I suspect the code fix is pretty easy since all the components are there (code how to multi-select is on the forum and datapages have capability to use OR operator vs AND operator). However as a non-programmer I can't figure it out. I inquired with my Caspio poc and it costs $600 to make this minor change. What's real obnoxious is that when he thought I wanted Caspio to build the entire search and result forms it was going to be $900. So basically its only $300 less even though I built everything else. I'm already thousands of dollars into this project with Caspio so its not like I'm going to switch solutions now. I guess I shouldn't have been surprised since this was one of the issues with Caspio I read about before I went with them. Perhaps one solution is to use 3rd party help (ie Odesk, elance, etc.). Good luck with your project. I agree though...it's probably like pissing in the wind.
  5. Thanks for the reply but this only works if the search and result forms are all on the same application. If they're two separate datapages, for some reason Caspio made it such that you can't select between AND and OR. It's actually kind of frustrating. I would imagine that a lot of users would appreciate being able to select between the two operators. Just reached out to Caspio and they're going to charge $600 to add some Javascript to make it work. I guess that's why they made it this way, to get you on these fees. If any one has a work-around, it would be much appreciated.
  6. Hong thanks for your response. Do you have any idea how to switch the operator from AND to OR?
  7. I have a search form that passes parameters to a results datapage. The search form has a listbox with virtual fields. I want to enable multiple selections for the listbox so that when the user selects multiple items such as School A, School B, School D, the results page will show all results containing School A, School B, or School D. I found the code to enable multiple selections here: http://forums.caspio.com/viewtopic.php?f=14&t=12154. Here is the code: <SCRIPT LANGUAGE="JavaScript"> /* "fieldName" is the variable name for the listbox type form element field. */ var fieldName = "InsertRecordStates"; var x=document.getElementsByName(fieldName); x[0].multiple=true; </SCRIPT> I also found out here: http://forums.caspio.com/viewtopic.php?f=3&t=12794&p=15793&hilit=listbox+virtual+field#p15793 that if you're using virtual fields, you have to replace "InsertRecordStates" with "cbParamVirtualXX". Finally the field in the results datapage that is receiving the parameters is set to "Contain". After doing all this, the problem I'm having is that the results page only shows results that contain all three (School A, School B, and School D) instead instead of showing results that contain any of the Schools A, B or D. Any help would be appreciated.
  • Create New...