nuimage

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!

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?

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!

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!

Thank you BaySunshine for such a prompt response! I will give your javascript suggestion a try.

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

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!

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

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

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

Thank you MayMusic for responding!

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

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!

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!

thanks, i will.