Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by nuimage

  1. Is there a way to dynamically hide/unhide an HTML Block on a results page? For example, I have a search form, If a user selects "Car" from the dropdown list, and then enters the color "Red" in a text box as a description, the results list should return a list of cars that are red, and the HTML Block should display a hyperlink to the car. However, if there is not a match I would like to hide the HTML Block. Is this possible? Many thanks in advance!
  2. Hello , In form edit mode, I'm unable to insert line break into a Text Area (64000) field. Whenever i do, i'm immediately escaped out of edit mode. This was brought to my attention by a user of the form, prior to a month ago, entering multi-line Text was permissible. Is anyone else experiencing this problem?
  3. Hello MayMusic, I implemented this code to validate a single phone field and it works perfectly! Is there a way to modify this code to validate multiple phone fields? thanks in advance!
  4. Hi MayMusic, thanks for checking. My internal user opted to remove the check boxes so i wasn't able to complete testing. However, i have another application that would benefit from multi-select checkboxes so i will need to push forward in getting this to work as soon as i can get to it. Thanks!
  5. Thank you BaySunshine for such a prompt response! I will give your javascript suggestion a try.
  6. Hello All, I'm having trouble getting the conditional logic to work with a multi-select listbox. I've used conditional logic before without complication but this is my first time using it with multi-select listbox. In the submission form, I have a multi-select listbox "currentAssign" with the value to be stored in field "currentAssign". The datatype of the field is "List-String" and it has the following values Campus College Advisor Area of Study when a user selects a value of Campus, College, Advisor, or Area of Study, I would like the conditional rules to display or hide additional fields on the form. For example, when "Campus" is selected, the conditional rule will display a drop-down field containing local campuses, and will also make the displayed field a required field. In this example i'm using the Parameter "[@currentAssign]" to set the criteria because i don't have an option to set the criteria by field name "currentAssign". Rule 1 Criteria: [@currentAssign] is not 'College' Action: Make Section 3 hidden Rule2 Criteria: [@currentAssign] is 'College' Action: Make currentAssign College required I've tested the conditional logic on drop-down form elements that has a data type of "Text". And it works as expected, however, I can't get it to work with multi-select listbox form elements with a data type of "List-String". I've gone as far as i'm able to, can anyone please provide some help. Thanks in advance
  7. Thank you Franchiser for your quick response. Sorry for a long delay with this response but i was away on holiday. I will follow up with the HTML Block. Thanks again!
  8. Hi all, I'm a newbie and would like to know if it is possible to create a hyperlink within a calculated field? Any help is greatly appreciated. Thank you
  9. Hello there, i had the same question. i'm sure by now you've found the solution but i will answer the post in hopes that it may help other newbies. From Datasheet view select the replace tab in the "find what" field leave blank. in the "replace with" field enter "some text" in the "search range" field enter "current column, row or all" in the "direction" field enter "all" select both "match case" and "match entire field" the find should find all blank entries. once those entries are found, you can then select "replace" or "replace all". be careful with the replace all, i would suggest testing a single row before updating all. I hope this helps someone else.... Regards
  10. Hello David, did you receive a response to your question? if not you may want to create a new thread. regards
  11. Franchiser, Thank you! Thank you! for such a quick response. Initially, i tried a select statement but instead of a value of "1", i indicated a value of "yes". I completely forgot that Yes/No fields have numerical values of "1" or "2". Your solution worked like a charm. Thanks again, you are a life saver. nuimage
  12. Hello All, I have a simple form asking users to check the "Yes" checkbox if they prefer a vegetarian meal option. The field datatype is "Yes/No". I have a report that i would like to count only those who checked "Yes". I've created an aggregate field in the report called "Veg Count" and I have selected the field "veg" to do a count function on. However, i'm unable to count only those who have checked the checkbox. It gives me a tally of all entries "yes" and "no". How can i count only those boxes that have been checked and has a value of "Yes". I cannot figure out how to create such a report. Any help would be greatly appreciated!
  13. Hello Vitalikssssss, I've reviewed the article countless times on "how to limit the number of submissions" but still cannot get the form to update the courses table. I did correct a small typographical error in the javascript (semicolon missing from first edit record statement) that updates the page but still without success. What am i missing? Below is the the javascript from my single record update page. Unique ID field - Course_ID Parameter name - [@cid] Attendees - field to update Header code - <div style="display:none"> Footer code - </div> <script> document.getElementById('EditRecordAttendees').value; parseInt(document.getElementById('EditRecordAttendees').value) + 1; document.getElementById('caspioform').submit(); </script> Destination after record update goes to a new data page. I'm forwarded to the new page as expected and do receive the confirmation message that i crafted, but the Attendees field in the Courses table is never updated. Thanks for your input!
  14. Hello Vitalikssssss, Is there a way to update the record dynamically without creating a Single record update form? I have a registration page that list all "Published" courses. This status is set when the course is created. However, when the criteria is met (student count >= MaxParticipants allowed for course) I would like to update the the field "CourseStatus" with the value "Not Active". Essentially, the updated status would remove the course from the Published list of courses. Thanks again for your help!
  15. Thank you for such a quick response. I will give it a try and let you know the outcome. Thanks again!
  16. Hello, Please help! i'm a newbie to Caspio. I want to update a Table value but can't figure out how to do this. I have created a Reports Datapage and would like to UPDATE CourseStatus to 'Not Active' when @calcfield1 >= MaxParticipants. MaxParticipants (fieldname) CourseStatus (fieldname) @calcfield1= count of participants SELECT COUNT(*) FROM iied_tlpreg_Participants WHERE iied_tlpreg_Participants.Course_RECID = [target].[@field:Course_RECID] @calcfield2 = CASE WHEN[@calcfield:1] >= [@field:MaxParticipants] THEN 'Not Active' ELSE 'Published' END CourseStatus is a hidden field in the data page and on load, receives the datasource field @calcfield2. I can see the correct value from the data page but the Table doesn't get updated. Any help on how to update the field is appreciated!
  • Create New...