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++ ) {

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"; seco

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 'Cert

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.

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