theconav

Look for the below in your css: width: 1200px; margin: 0 auto; margin-left: 400px; margin-top: 150px; height: 1290px; Remove the margin-left:400px line and it will be ok

Hi Jan and thank you very much for your reply. I tried it but unfortunately it does not work. Well, I assume that the first line can be replaced by document.getElementsByName('cbParamVirtual7')[0].value = 'XXX'; I tried it with both options (both by selecting the index of the item as you stated as well as by entering the value as above). This works and the value changes, however "click" does not seem to work. Any other suggestions? Again, thanks for your time

Hi MayMusic Thank you very much for your prompt reply. I actually do not want to call any function. Sorry if my previous description was misleading. All I need is the cascading to work (!!) Taking the State and City example you mention, my problem is that if i manually change the value of the State (by clicking the dropdown list and selecting a different state from the the available entries) then the cascading city works perfectly. The problem arrises when, through the javascript code, I force a specific state as the value of the state dropdown i.e. getElementsByName(InsertRecordState')[0]=vSomeState rather than manually opening the dropdown list and selecting some state from there. In that case the cascading city does not work (i.e the value of the cascading city does not change). Would appreciate your help in this Many thanks !

Hello dear Caspio community. I m facing the following problem and would appreciate any help. I have a Virtual Field set as a dropdown list and another virtual field referencing the first one as a cascading dropdown list. When manually changing the value of the first dropdown list, the cascading dropdown list on the other virtual field works perfectly. However, when changing the value of the dropdown list dynamically (through some javascript code), the cascading dropdown does not change at all. Any ideas ? The javascript code i m using is the following : ... var vRegistryCode = vGSPCode + '-' + vLocation ; document.getElementsByName('cbParamVirtual7')[0].value = vRegistryCode; document.getElementsByName('cbParamVirtual7')[0].onchange(); ... P.S. cbParamVirtual7 is my first Dropdown list. Thank you very much !

Hi GaryRam, The lookup table, field for display, field for value, etc of a dropdown field are usually set during design mode. I want to be able to change these dynamically, base3d on the value of some other fields. Thank you

Is there any way of dynamically change (through Javascript) the associated parameters (table,, filter, field for display etc) of a dropdown / cascading dropdown field ? Thank you

Hello all, I ve been trying to solve this issue for quite so e time now: Field : FieldOne --> Text Fied : FieldTwo --> Number Field : Ttl --> Calculated I have the following SQL in the calculated field: SELECT Sum(FieldTwo) From tTable_Name WHERE tTable_Name_Field = '[@field:FieldOne]' However I do not get nay results. I have tried also the following alternative SELECT Sum(FieldTwo) From tTable_Name WHERE tTable_Name_Field = [@field:FieldOne] This gives me the sum of FieldTwo, however ignoring the criteria set by the WHERE. If I try SELECT Sum(FieldTwo) From tTable_Name WHERE tTable_Name_Field = 'XXX' (i.e. passing a specific value instead of whatever value [@field:FieldOne] carries), then it works fine. Could someone help please ? Thank you

Thanks ShWolf, I will do that

Hi ShWolf, Thanks for your reply. It works perfectly when using a static value, I had tried that from the beginning. The point is that I I need to be able to get the result for each record of the table and since the Audit_Entity field has a different value in every record, a static value as the value cannot be used.

Thanks Emma, Audit_Entity is text (value is available in a dropbox) and Points is number Thank you

Thanks a lot Emma for your prompt reply. Well, when trying to use double quotes (e.g. SELECT SUM(Points) FROM Points_Table WHERE Audit_Entity="XX") you cannot even exit the calculated field (in design mode) as there is an "Invalid formula" error with the description "Invalid column name RO". Using single quotes (SELECT SUM(Points) FROM Points_Table WHERE Audit_Entity='[@field:Audit_Entity]', literally takes the "[@field:Audit_Entity]" string as a value rather than the value of the Audit_Entity field and produces no results. Using it without quotes ( SELECT SUM(Points) FROM Points_Table WHERE Audit_Entity=[@field:Audit_Entity]) produces wrong results by totally ignoring the criteria set in WHERE and this sounds logical as this would have made sense if the Audit_Entity field was numeric. However, this is a string field. At some point i suspected the error was resulting from the fact that the Audit_Entity takes its value from a dropbox, so I changed the dropbox to text and tried again SELECT SUM(Points) FROM Points_Table WHERE Audit_Entity=[@field:Audit_Entity]). The results were wrong, as it seems that it ignored the SUM and only displayed the value of the related record (only one record) of the Points_table. I really cannot thing of any other approach, so any sort of feedback will be highly appreciated ! many thanks again !

Sorry, I think i found a workaround so, no reply is needed. I have encountered though a different problem: I have the following expression in a calculated field : SELECT SUM(Points) FROM Points_Table WHERE Audit_Entity=[@field:Audit_Entity] The Audit_Entity field is of type string and should therefore be entered using single quotes e.g. SELECT SUM(Points) FROM Points_Table WHERE Audit_Entity='XX' However, the problem is that you cannot include a single quote as part of the calculated field. Can someone suggest a solution please ? Many many thanks

Hello everyone, I have a chart and I want to update a table (in a different datapage) with the values of each of the chart's category items. The chart is the one in the attached file : I need to be able to get the value of "Points" of each of the Category's items (ET, FB, G3, GA etc) and update a different data page. How could this be done ? Many thanks !

Any help on this please ?

Hello everyone. I have the following scripts in a details page footer : function Displayer(n) { var check=document.getElementById('Section'+n); if(check.style.display=='none') { check.style.display='inline'; } else { check.style.display='none'; } } function assignauditcodes() { var position1 = document.getElementsByName("EditRecordGSP_Code")[0].value; var position2 = document.getElementsByName("EditRecordAuditing_Location")[0].value; var allpositions = position1+"-"+position2; var position3 = document.getElementsByName("EditRecordGSP_Code")[0].value; var position4 = document.getElementsByName("EditRecordAppointed_AE_Code3")[0].value; var position5 = document.getElementsByName("EditRecordAuditing_Location")[0].value; var position6 = document.getElementById("EditRecordAudit_Category").value; var position7 = document.getElementsByName("EditRecordAudit_Schedule")[0].value; var position8 = position7.substr(6,4) ; var allpositions2 = "ISAGO"+"-"+position3+"-"+position4+"-"+position5+"-"+position6+"-"+position8; document.getElementById("EditRecordAudit_Code").value = allpositions; document.getElementById("EditRecordAudit_Allocation_Code").value = allpositions2; } document.getElementById("caspioform").onsubmit=assignauditcodes; var setCurrentStatus = function(status) { document.getElementsByName('EditRecordAudit_Current_Status')[0].value = status; } document.getElementById('caspioform').onsubmit = function() { var appointedAE = document.getElementsByName('EditRecordAppointed_AE_Code')[0].value; var closeDate = document.getElementById('EditRecordAudit_Closing_Date').value; var today = new Date(); today.setHours(0,0,0,0); if(appointedAE == '-None-') { setCurrentStatus('1-New'); } else if(closeDate == '') { setCurrentStatus('2-Assigned'); } else { closeDate = new Date(closeDate); closeDate.setHours(0,0,0,0); if(closeDate > today) { setCurrentStatus('3-Scheduled'); } else { setCurrentStatus('4-Performed'); } } } When updating the record the assignauditcodes() function doesn't seem to work. However, if i remove completely the last script (var current status ….) it works perfectly. I assume that there is something wrong, when both these scripts appear together. Could anyone advise what might be wrong ? Thank you very much