TexterVaid

Caspio Ninja
  • Content count

    56
  • Joined

  • Last visited

  • Days Won

    1

TexterVaid last won the day on December 28 2016

TexterVaid had the most liked content!

About TexterVaid

  • Rank
    Advanced Member
  • Birthday May 7

Contact Methods

  • Website URL
    playmusician.com

Profile Information

  • Gender
    Male
  • Location
    New York
  • Interests
    Arts , Travel Technology , IT Development

Recent Profile Visitors

335 profile views
  1. 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 ~
  2. 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>
  3. 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
  4. 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>
  5. 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!
  6. 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!
  7. http://www.tripatwork.com/test-multilistbox-submit.html
  8. 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
  9. 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>
  10. Also.. The code worked for the grid edit tool, Thanks But the columns are unevenly spaced and some of the columns cant be read properly. Is it possible to spread it out evenly. Attached Pic Thanks~
  11. I need to Insert a Received Parameter (Password) in a form and Insert the value into an Encrypted Password Field in a Table. I dont see the Receive parameter for the Encrypted Password Field / Element How do I Do this ? I need to do this Form 1 - gathers company info > gathers employee login info ( Virtual Fields) >> and submits parameters to Form 2 Form 2 - Receives parameters from Form 1 , applies the received password to an encrypted password field in the Source Table , Thanks !
  12. Hi ATTMEX, First Form If first table has a primary unique key (like an email address) and if in the form you set that element/field to "Required" The First Form should give the user an error message by default "Value already exists", If the user tries to submit the form with the same value. Second Hidden Form (to prevent constant submission loop) Maybe Modify your javascript with - if else if - conditions (Only if criteria is met - submit ) example in Hidden Form2 --------------------------------------------- idvalue is the passed parameter from Form1 (autonumber /unique key) -------------------------------------------------------------------------------------------------- if (idvalue =='') { alert("No ID Found !") } else if (idvalue !=='') { document.getElementById("caspioform").style.display = 'none'; setTimeout('document.forms["caspioform"].submit()',1000); }
  13. Arts. Community. Events

    p  l  a  y  m  u  s  i  c  i  a  n

  14. Thanks May for your help. The Relationship we've chosen (not by choice ) is 1 Company >> Many Employees - Weve chosen this model, Due to the limitation of : updating just 1 table at a time and no sql/stored procedures permitted which would generate many many data pages and would be undesirable . Our new application is a full tiered app that would include Web & Legacy Customers, Companies, Employees . If theres something Im missing on how to achieve many to many table relationships without creating multiple hidden javascript pages which would create a page sprawl, please do educate and enlighten me. It would help a lot. Thanks !!
  15. 1) How Can I Change the Default "View Details" link to just "Details"? 2) Grid Edit - How Can I Make the tables NOT shrink and get squishy when I Click "Grid Edit" Attached Images Below 3) How Can I do the following WITHOUT Creating 3 DataPages Tbl_CompanyInfo Table 1 - Autonumber/Unique - CompanyInfoID Tbl_EmployeeInfo Table 2 - Autonumber/Unique - EmployeeInfoID Relationship of Tables : 1 Company >> Many Employees Step 1 Single Form - Company Info & EmployeeInfo (Virtual Fields) is filled in (generates CompanyInfoID in Tbl_CompanyInfo) pass hidden EmployeeInfo parameters to Hidden Form 2 Step 2 (Hidden/Autosubmit/ Javascript Data Page) Form 2 - Employee Info - Is Filled In with passed parameters & auto JS submitted (generates EmployeeID in Tbl_EmployeeInfo) Completed Forms Step 3 Need to place : Newly minted EmployeeID into Tbl_CompanyInfo Table *Without a hidden/autosubmit/javascript Data Page !