Jump to content

nuimage

Members
  • Content count

    16
  • Joined

  • Last visited

About nuimage

  • Rank
    Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. 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!
  2. nuimage

    Multi-Select Listbox and Conditional Logic

    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!
  3. nuimage

    Multi-Select Listbox and Conditional Logic

    Thank you BaySunshine for such a prompt response! I will give your javascript suggestion a try.
  4. 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
  5. 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!
  6. 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
  7. nuimage

    Replacing blanks in a field

    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
  8. nuimage

    How to tally ye/no responses.

    Hello David, did you receive a response to your question? if not you may want to create a new thread. regards
  9. nuimage

    How to tally ye/no responses.

    Thank you MayMusic for responding!
  10. nuimage

    How to tally ye/no responses.

    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
  11. 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!
  12. nuimage

    CASE in calculated field

    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!
  13. nuimage

    CASE in calculated field

    thanks, i will.
  14. nuimage

    CASE in calculated field

    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. nuimage

    CASE in calculated field

    Thank you for such a quick response. I will give it a try and let you know the outcome. Thanks again!
×