Search the Community

Hi there, I've got an application that allows for a company to self-register to a service. All company-relevant information goes into the Companies table and they can edit this as needed. This functionality is pretty straightforward in Caspio, but now I want to extend it. I'd like to capture details on the company directors during the registration process. The intent would be to have a dropdown asking for the number of company directors, and then provide a form (or forms) to gather the name, email, contact details etc of each one (either all together or consecutively). These details will go into a table cleverly called Directors, and these new records will include a foreign key for the company record. I've searched the help topics and forum pages with no joy on this. I did have the idea of using javascript to pick up a "num_directors" parameter passed into a data page, then build N sets of submission forms that would be needed, then use javascript again to submit each form consecutively ... maybe even using multiple published iframes on the data page ... but haven't tested any of these Does anyone have any suggestions on how this could be accomplished? I've got a second application that needs the same style of approach too Thanks Mark

I have a form that has two embedded forms (iframe datapage deployment) First subform is a submission form and the second a single record update form. I have a javascript function that is run by clicking on a button in the parent form that randomly selects a record whose parameters are then passed to both of the embedded forms. After the action is completed, I want to submit both of the embedded forms, without submitting or reloading the parent form, because the action can potentially be repeated. I have tried several options, but can't get the submit to work. Below is my javascript funtion as I have it now. The names of my iframe forms are Form a - embeddedsubmitform Form b - embeddedupdateform Any help would be greatly appreciated. Thank you <script> function getemprec() { var radget = document.forms[0].elements["cbParamVirtual5"]; //this is radio button that will determine the number of times the function will be run for (var i=0; i<radget.length;i++) { if(radget.checked) { var S1 = radget.value; } } var S2 = Number(S1); var E1 = document.getElementsByName("cbParamVirtual4")[0].length; //this returns a list of total records in the system var E2 = Number(E1); var E3 = E2/S2; var S3 = Number(E3); document.getElementById("InsertRecordNumber_of_Screens").value = S3; var scrtyp = document.getElementById("InsertRecordScreening_type").value; var scrdate = document.getElementById("InsertRecordDate_of_Screens").value; var T1 = document.getElementsByName("InsertRecordEmployees")[0].length; var n1 = Number(T1); var n2 = n1 - 1; var numb = Math.floor(Math.random()*n2); var numb2 = Number(numb); document.getElementsByName("InsertRecordEmployees")[0].selectedIndex = numb2; var reclist = document.getElementsByName("InsertRecordEmployees")[0]; var recvalue = reclist.options[reclist.selectedIndex].value; document.getElementById("cbParamVirtual2").value = recvalue; document.getElementById("embeddedsubmitform").src ='../pages/submit.html?SelEmp_Rec_ID='+recvalue+"&Screen_Type="+scrtyp; document.getElementById("embeddedupdateform").src ='../pages/update.html?DS_Emp_Rec_ID='+ recvalue+"&DS_date="+scrdate; document.getElementsByName("embeddedsubmitform").submit(); document.getElementsByName("embeddedupdateform").update(); } </script>