All Activity

This stream auto-updates   

  1. Today
  2. I ended up removing the new authentication table and going back to my main authentication. Then I added a field that holds all user ids in my project table (I added JavaScript in my datapage to combine all userids already added with any new users to the project). Then I added a search of that field with a Contains (userid) search to ensure the members userid is present in the project. The brackets around userid are in the table and search function so a userid that is short won't find part of itself in the table, such as a userid of 1 would be found if someone's user is was 100. So it searches for (1) so it will only find (1) if it's present, if that makes sense. Thanks Mark
  3. Yesterday
  4. In calculated field
  5. Last week
  6. I've gotten to this but I still can't get it to work. If someone can take a look that'd be great. <div style="text-align: center;"> <input class= "cb_custom_btn" type="submit" onclick="myFunction()" value="Activate Product" /> <script> function myFunction(){ var v_virt = "[@cbParamVirtual5]"; if(v_virt=="Annual"){ window.location.href='../page1?mstrID=[@authfield:mstID]'; } if(v_virt=="Monthly"){ window.location.href = '../page2?mstrID=[@authfield:mstrID]'; } } </script> </div>
  7. On a Details form I need to use a custom button to do the Update/Submit- that's not a problem. The issue is that I also need to run some script for that specific button to go to a url after submission, depending on the value of a virtual field. The reason I can't put the script for the url destination in the 'Destination and Emails' section is that I have 4 of these buttons, each of which needs to go to a different url if/when clicked. Here's sort of the code I need to use- does anyone know how to incorporate the redirect script into the button so it goes to that destination after the form submits? Many thanks- <div style="text-align: center;"> <input class= "cb_custom_btn" type="submit" value="Activate Product" /> <script> var v_virt = "[@cbParamVirtual5]"; if(v_virt=="Annual"){ window.location.href='../page1?mstrID=[@authfield:mstrID]'; } if(v_virt=="Monthly"){ window.location.href = '../page2?mstrID=[@authfield:mstrID]'; } </script> </div>
  8. Thank you. I'll have to put my thinking cap on some more. I tried record level, but it was limiting the user to seeing one record, their own, and I need them to see everyone else's data (project Forum, users list, file upload, Ect). But maybe you are right and I need to play more with my tables and views.
  9. I ended up using the above and some other code for if/then to get it to work. Here's the solution in case anyone else needs it: <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var productid = document.getElementById("cbParamVirtual1").value; if (productid == 3){ var x = document.getElementById("cbParamVirtual2").value; document.getElementById("EditRecordmyTextfield1").value = x; } else if (productid == 1){ var x = document.getElementById("cbParamVirtual2").value; document.getElementById("EditRecordmyTextfield2").value = x; } else if (productid == 2){ var x = document.getElementById("cbParamVirtual2").value; document.getElementById("EditRecordmyTextfield3").value = x; } else if (productid == 4){ var x = document.getElementById("cbParamVirtual2").value; document.getElementById("EditRecordmyTextfield4").value = x; } else if (productid == 5){ var x = document.getElementById("cbParamVirtual2").value; document.getElementById("EditRecordmyTextfield5").value = x; } else if (productid == 6){ var x = document.getElementById("cbParamVirtual2").value; document.getElementById("EditRecordmyTextfield6").value = x; } } document.getElementById("caspioform").onsubmit=concatenate; </SCRIPT>
  10. Im not exactly sure , what the setup is but If the "projects" is stored as data in a table and the users are in a separate table, The access to specific projects should be solved by record level access ( data pages /reports ) - only certain users can see their own data. which means only authorized users can see certain projects. The authentication should not be the criteria - for viewing specific data for specific users The authentication only - restricts access to pages & reports. Record level access restricts a logged in specific user to specific data. This requires planning , designing and setting up the tables correctly . It seems like the solution lies in creatively re-arranging your entities (users and projects) in planned tables. My 2 cents. Hope this helps. Best ~
  11. Curious, can anyone thinking of a way to accomplish this task? My app has team projects and I only want the people that are members of each specific project to see the data table contents. I have gotten it to work by creating a new authenticity login, that contains a code that is specific to each project. The only problem is the user has to re-login to each project because the code is different. I cant really narrow by having a criteria in a view, at least I don't think, because new projects will be created daily, each containing a variety of members. I am trying to do this and make it more fluid. Thanks, Mark
  12. Thanks- I'd found that post but I need the 'if/then' part of the issue working first.
  13. Heres a great post on passing fields from virtual fields to regular fields. Hope this helps. <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var x = document.getElementById("cbParamVirtual5").value; document.getElementById("InsertRecordSchoolName").value = x; } document.getElementById("caspioform").onsubmit=concatenate; </SCRIPT>
  14. In a Single Record Update form I'm trying to update different fields based on the value of a Virtual field. The Virtual field is loading with and External Parameter (number value). Depending on what value that Parameter is I need a specific field to update/change on when the 'Update' button is clicked. I don't want all fields to update, just a single specific field based on the value of the Virtual field. For example: If Virtual1= 3 then update myField1="mytext" If Virtual1=4 then update myField2="mytext" If Virtual1=5 then update myField3="mytext" Here's some code I'm working with but can't seem to get it right. It's in the footer of the Single Record Update form. <script> function changeVal() { var v_product = document.getElementByID("EditRecordcbParamVirtual1").value; if(v_product=="3") { document.getElementById('EditRecordmyField1').value = "Not Activated" } else if (v_product=="4"){ document.getElementById('EditRecordmyField2').value = "Not Activated" } else if (v_product=="5"){ document.getElementById('EditRecordmyField3').value = "Not Activated" } document.getElementById('caspioform').onsubmit = changeVal; </script> I tried this without the 'else if' part (for just the first If=3) but still couldn't get it to work. It's probably just some syntax- any help would be greatly appreciated.
  15. Does anyone know any code for collapsing or expanding sections in a Pivot Table and a Tabular table? For example lets say that column 1 is 'Regions' and Column 2 is 'Countries'. The pivot table table is set up to show all regions and all countries expanded. I'd like to set up a button outside the results table to be able to collapse all countries, all in one go, to just show region totals, without having to go through each region individually. Many thanks in advance.
  16. sorry re-read your post, this might be the answer. http://stackoverflow.com/questions/11806253/onsubmit-multiple-javascript-functions http://stackoverflow.com/questions/16250915/how-to-call-two-functions-on-a-form-submit
  17. Hi! I have multiple scripts for a submission page. When I execute the page I am only able to get one to work at a time. Not all three. I am not sure what I am doing wrong. Any help or advice would be appreciated. I have pasted the scripts below. I have all the scripts in the footer of the page. The first simply checks that the MOQ field is greater than the Inner Pack field. The second checks that cost is less than retail. They third, if the virtual check box is checked, it will copy the data from the Vendor VPN field to the Vendor Style field. <SCRIPT LANGUAGE="JavaScript"> function check() { var v_moq = parseFloat(document.getElementById("InsertRecordMOQ").value); var v_innerpack = parseFloat(document.getElementById("InsertRecordINNERPACK").value); if(v_moq<v_innerpack) { window.alert("MOQ Must Be Less Than The Inner Pack"); return false; } } document.getElementById("caspioform").onsubmit=check; </SCRIPT> <SCRIPT LANGUAGE="JavaScript"> function check() { var v_cost = parseFloat(document.getElementById("InsertRecordCOST").value); var v_retail = parseFloat(document.getElementById("InsertRecordRETAIL").value); if(v_cost>v_retail) { window.alert("Vendor Cost must be less than Retail"); return false; } } document.getElementById("caspioform").onsubmit=check; </SCRIPT> <script> function f_vendorstyle() { if(document.getElementById('cbParamVirtual1').checked) { document.getElementById('InsertRecordVENDORSTYLE').value=document.getElementById('InsertRecordVENDORVPN').value; } else { document.getElementById('InsertRecordVENDORSTYLE').value=""; } } document.getElementById('cbParamVirtual1').onclick= f_vendorstyle; </script>
  18. Got a script to work.,... This a script I found on the forum and tweaked. SUBMISSION FORM- MULTI LISTBOX SCRIPT --------------------------------------------------------------- <script> var fieldName = "InsertRecordMultiListbox"; var x=document.getElementsByName(fieldName); x[0].multiple=true; function select_ (){ // get listbox element var listbox = document.getElementById("InsertRecordMultiListbox"); // get listbox length var len = listbox.options.length; // get selected element var selected = listbox.options[len-1].value; // verify if selected element contains comas, if yes, do the following if (selected.indexOf(",") != -1 ){ // Split selected option into array var m_array = new Array();m_array=selected.split (", "); // Delete last option from the listbox listbox.options.remove(len-1); // Go through listbox and select each option, if it is present in array for( var i=0; i< m_array.length; i++ ){for( var j=0; j< len-1; j++ ){ // Trim spaces while comparing elements from array and listbox if( m_array.replace(/^s+|s+$/g,"") == listbox.options[j].value ){ listbox.options[j].selected = "selected"; }}}}} window.onload = select_; </script>
  19. Hi, My current code is: <SCRIPT LANGUAGE="JavaScript"> function update() { var p2 = document.getElementById("cpParamVirtual10").value; document.getElementByName("cpParamVirtual4")[0].value=p2; } document.getElementByID('caspioform').onload=update; <SCRIPT> and I have it deployed in the footer of a submission form however it is not working. Virtual10 is a hidden field that loads with a passed parameter . Virtual4 is a cascading dropdown ( and on exit passed the parameter that virtual10 loads). I want to set the cascading dropdown to the value it was when the form was submitted the last time instead of resetting itself every time. Thanks for the help.
  20. Download button is downloading whatever user retrieved on report page, there is no point to move it to search. If you have search and report on one page and you want to see download over on search page then "position:absolute" might help.
  21. You can fire the function on a different event like when the second value goalcount is entered and focus goes to another field <script> function onSubmitClick() { var box1 = document.getElementById('InsertRecordsubgoalcount'); var box2 = document.getElementById('InsertRecordgoalcount'); box2.value = box1.value; } document.getElementById('InsertRecordgoalcount').onblur = onSubmitClick; </script>
  22. For the many to many you have to break it down to two one to many relations so you need to have an extra submission page to add to this join table. As for the Grid, if possible give me the URL to take a look. Probably you need to check and see if you have a fixed width for some columns in your report
  23. How do you get these values to the table? what is the table design? Calculation needs to be performed at submission is that correct?
  24. Earlier
  25. Any help would be appreciated ! Thanks~ Pseudo Code for REQUIREMENT FOR Multi-Select Listbox in a Submission Form ON FIRST TIME LOAD - Read the values from the table field into a variable If field is blank - then dont do anything Just populate the listbox from default element custom values ON SUBMIT (SAME PAGE) -MULTIPLE VALUES SELECTED On Submit, Store the “selected value”s from listbox in an array in a hidden element or a temp persistent variable or > maybe a hidden virtual field ON ERROR - REFRESH If theres an error:- Example: Other required fields are not filled in on form (The selected hidden values are not yet committed to the database) Then Load the hidden “selected values” array In the Listbox - Match the hidden “selected values” array <<>> with the drop down list element custom values Finally- Highlight and show the values in the listbox as selected . IF NO ERROR Then submit values in delimited string to table field. Thanks!
  26. Multi Select Listbox (Submission Form) - On Errror Javascript Code Required. Pseudo Code - REQUIREMENT FOR Multi-Select Listbox in a Submission Form ON FIRST TIME LOAD - Read the values from the table field into a variable If field is blank - then dont do anything Just populate the listbox from default element custom values ON SUBMIT (SAME PAGE) -MULTIPLE VALUES SELECTED Store the “selected value”s from listbox in an array in a hidden element or a temp persistent variable or maybe a hidden virtual field ON ERROR - REFRESH If theres an error:- like other required fields are not filled in on form (The values are not yet committed to the database) Then Load the hidden element “selected values” array In the Listbox - Match the variables array values with the drop down list element custom values and Highlight and show them as selected . IF NO ERROR Then submit values in delimited string to table. Thanks!
  27. http://www.tripatwork.com/test-multilistbox-submit.html
  28. Got it to work. There was a small syntax error Double quotes was missing in script if( m_array.replace(/^s+|s+$/g, "") == listbox.options[j].value ){ But, Now it doesnt highlight ALL the choices, Just 1 selection shows up. http://www.tripatwork.com/test-multilistbox-submit.html
  29. Got it to work. Thanks to May for for this script. There was a couple of small syntax error Double quotes was missing in script if( m_array.replace(/^s+|s+$/g, "") == listbox.options[j].value ){ Space after, comma was missing while splitting array. Heres a working copy of the final script. <script> var fieldName = "InsertRecordMultiListbox"; var x=document.getElementsByName(fieldName); x[0].multiple=true; function select_ (){ // get listbox element var listbox = document.getElementById("InsertRecordMultiListbox"); // get listbox length var len = listbox.options.length; // get selected element var selected = listbox.options[len-1].value; // verify if selected element contains comas, if yes, do the following if (selected.indexOf(",") != -1 ){ // Split selected option into array var m_array = new Array();m_array=selected.split (", "); // Delete last option from the listbox listbox.options.remove(len-1); // Go through listbox and select each option, if it is present in array for( var i=0; i< m_array.length; i++ ){for( var j=0; j< len-1; j++ ){ // Trim spaces while comparing elements from array and listbox if( m_array.replace(/^s+|s+$/g,"") == listbox.options[j].value ){ listbox.options[j].selected = "selected"; }}}}} window.onload = select_; </script>
  1. Load more activity