EmmePGN

Hi SinJunYoung, Thank you so much for helping me. I have played with Caspio's resident functionality of "rules" many times over. The added issue is that I need the fields "FrequencyA", and "FrequencyB" hidden by default. Either one of them would show only when the user chooses either one. With your recommendation it would mean that FrequencyA and FrequencyB would be visible by default, which runs contrary from what I need. Thank you so much for helping.

Hello Vitalikssssss Thank you so very much for the code. It is working. Thank you. There is a new issue though. The value results of the selection are now bunching together at the bottom of the list box. The results somehow begin to occupy the extra space that is generated by the multi-list box. I attached an image here to show what I'm saying. Any recommendation for this issue? I will appreciate your further help.

Hello, Can anyone please help me on imposing a limit to the number of selections users can have from the multi-select listbox. The form is an Update Form. Below is my script, and it is not working. It is still allowing users to press on. Thank you so much in advance. <script type="text/javascript"> var v_state = "[@field:TypesWrittenComm]" ; var o_state = document.getElementById("EditRecordTypesWrittenComm") ; o_state.multiple = true ; function f_listbox() { if ( v_state.indexOf(",") > 0 ) { for (var i=0 ; i < o_state.options.length; i++ ) { if(o_state[i].value == v_state) { o_state.remove(i); break ; } } var o_st = v_state.split(", ") ; for (var j=0 ; j < o_st.length; j++) { for (var i=0 ; i < o_state.options.length; i++ ) { if(o_st[j]== o_state.options[i].value){ o_state.options[i].selected = true ; break ; } } } } } function check_listbox() { var maximum_selections = 3; var MyListbox = document.getElementsByName("EditRecordTypesWrittenComm")[0]; var number_selections = 0; for (var i=0; i<MyListbox.length; i++) { if (MyListbox.options[i].selected) number_selections++; } if (number_selections>maximum_selections) { alert("You can select only " + maximum_selections + " items"); return false } } document.addEventListener('DataPageReady', f_listbox); //You can also use the line below instead of the eventlistener // setTimeout(f_listbox, 20); </script>

Hello @Hastur Thank you so much for the help. I am going to try to get the Element of the target input by Name instead of by ID. Because it's still not working for me. I'll try a different approach, if the getElementbyName('Certification')[0]; doesn't work. Many thanks. I'll keep you posted.

I need to add that that the event.target.value is numeric, not text.

Hi Andrew, Thank you so much for helping me. The code didn't work for my page. I am showing below what I have (including the parts that I changed). Can you please check where I'm going wrong? <script> function hideFieldsHandler(event) { let targetInput = document.getElementById("EditRecordCertification"); let firstField = document.getElementById("EditRecordFrequencyA").parentNode.parentNode; let secondField = document.getElementById("EditRecordFrequencyB").parentNode.parentNode; if (event.target.value = 300) { firstField.style.display = "none"; secondField.style.display = ""; } else if (event.target.value = 500) { secondField.style.display = "none"; firstField.style.display = ""; } } function changeHandler() { document.getElementById('EditRecordCertification').addEventListener('change', hideFieldsHandler); let firstField = document.getElementById("EditRecordFrequencyA").parentNode.parentNode; let secondField = document.getElementById("EditRecordFrequencyB").parentNode.parentNode; firstField.style.display = "none"; secondField.style.display = "none"; document.removeEventListener('DataPageReady', changeHandler); } document.addEventListener('DataPageReady', changeHandler); </script>

Hello all, I am hoping someone can help me with a javascript and figure out how to hide/show fields based on user selection from a drop down field. I tried the rules section for this and it is not serving what I need. I also searched the forum to see if there is something I could use. But can't find any that I could understand. I have an UpdateForm. My field name for the drop down is 'Credentials' My other two fields are 'Frequency 1' and 'Frequency2' There are 2 choices in the drop down field: Certificate and Licensure If the user chooses 'Certificate' I would like the 'Frequency 2' to be hidden and 'Frequency 1' to be a required field. If the user chooses 'Licensure' the 'Frequency 1' should be hidden and 'Frequency 2' should be a required field. Please help. Thank you so much in advance.

Hi vitalikssssss, thank you for this. I opted to use the SQL syntax that creates a deliberate error message, I think it's more attention-grabber than the disappearing button (so it's more like "the flogging will not stop until everyone gets it" kind of stuff). Incidentally, I edited the character and integer combination like so, which works for me and my Update Datapage. I know this is elementary, but still....Yeayyy me! The number of numeric variables after the character variable 'a' (to be cast) corresponds to the number of fields that I wanted to sum up. Which is 5. CASE WHEN (( (Isnull([@field:PointFactor_Duties_PercentDuty1],0)+Isnull([@field:PointFactor_Duties_PercentDuty2],0)+Isnull([@field:PointFactor_Duties_PercentDuty3],0)+Isnull([@field:PointFactor_Duties_PercentDuty4],0)+Isnull([@field:PointFactor_Duties_PercentDuty5],0) ) ) >100) THEN CAST( 'a' + 1 + 1 + 1 + 1 + 1 as INT) ELSE (Isnull([@field:PointFactor_Duties_PercentDuty1],0)+Isnull([@field:PointFactor_Duties_PercentDuty2],0)+Isnull([@field:PointFactor_Duties_PercentDuty3],0)+Isnull([@field:PointFactor_Duties_PercentDuty4],0)+Isnull([@field:PointFactor_Duties_PercentDuty5],0) ) END Ciao!

Hello, I'm new to Caspio. I have an Update Form with a calculated field called "Total_Percentage", that takes the values from other fields. Code below: Isnull([@field:PointFactor_Duties_PercentDuty1],0)+Isnull([@field:PointFactor_Duties_PercentDuty2],0)+Isnull([@field:PointFactor_Duties_PercentDuty3],0)+Isnull([@field:PointFactor_Duties_PercentDuty4],0)+Isnull([@field:PointFactor_Duties_PercentDuty5],0)+Isnull([@field:PointFactor_Duties_PercentDuty6],0) What I would like to do is to prevent users from going forward when their total exceeds 100%. I also, would like to show them, which field(s) is/are causing this field to go over the threshold of 100%. The rules section is not conducive to this goal, as rules section is limited. Triggered action section forces me to either email or text the users if their total exceeds 100%. I don't want to do this, since the whole point is for users to correct errors immediately. Is there anyone out there who can impart me a script or two to help me? SQL or javascript that would work with Caspio. Thank you so much. Emme