Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


perland last won the day on August 15 2018

perland had the most liked content!

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

perland's Achievements


Newbie (1/14)



  1. If you just want to print the <form id="caspioform" ... a simple way will be to create a footer in your report form and copy the code below. <input type="button" onclick="printDiv('caspioform')" value="Print caspioform" /> <script> function printDiv(divName) { var printContents = document.getElementById(divName).innerHTML; var originalContents = document.body.innerHTML; document.body.innerHTML = printContents; window.print(); document.body.innerHTML = originalContents; } </script> VK.
  2. Hello, I have a user registration from with an email and email confirmation field tied to Table_2. I would like the email address that is entered to be verified against an email filed in Table_1, and give a “does not exist†prompt if the email address is not in Table_1. Basically a user has to have an email in Table_1 to be able to register for Table_2. Any help or suggestion will be very much appreciated. Thank You, VK
  3. You may also check this post. http://forums.caspio.com/index.php/topic/4224-convert-text-number-to-phone-format/?p=13380
  4. MayMusic, Thank you for your suggestion all worked fine. For a single record update form with a textbox field called Phone_Home, I used the code below placed in the footer: <SCRIPT LANGUAGE="JavaScript"> function tel() { // Read the content of the textbox var message = document.getElementById("EditRecordPhone_Home").value; //Skip function if textbox is empty, else you will see () - if (message != "") { // Strip off all the spaces document.getElementById("EditRecordPhone_Home").value = (message.replace(/[^\d]/g, '')); var message1 = document.getElementById("EditRecordPhone_Home").value; document.getElementById("EditRecordPhone_Home").value = ("(" + message1.substring(0,3) + ") " + message1.substring(3,6) + "-" + message1.substring(6,10)); } } // Call function when value in the textbox changes document.getElementById('EditRecordPhone_Home').onchange=tel; </SCRIPT> I have three other fields called Phone_Work, Phone_Cell and Phone_Fax. Would you happen to know a single code that can be called for all four fileds. The other option will be to copy the above code 4 times. Thank You again.
  5. Hello, How can I make an onchnage event trigger a function that converts a number in 1234567890 to (123) 456-7890 format. The function works fine, but the onchange statement does not trigger the function. This is on a single record update form. Thank You. <SCRIPT LANGUAGE="JavaScript"> function phoneFormat(phone) { phone = phone.replace(/[^0-9]/g, ''); phone = phone.replace(/(\d{3})(\d{3})(\d{4})/, "($1) $2-$3"); return phone; } document.getElementById('EditRecordPhone_Home').onchange=phoneFormat(document.getElementById('EditRecordPhone_Home').value); </SCRIPT>
  6. Hello, Is there a way to add a save button to a long from so that a user can click save at multiple locations before clicking on the submit button at the bottom of the form? Thank You.
  7. Hello, I have a search and report DataPage that I would like to show the difference between two dates in days. The start day will be new Date(), and the end date a time field in a table. Below is an outline of the code. Is there an easy way to do this? Thank You. var StartDate = new Date(); var EndDate = document.getElementById("InsertRecordpatient_status_change_timestamp").value; Var NumberDays = StartDate-EndDate document.write(NumberDays);
  8. Thank you nkamalan. I used the first code and it does exactly what I needed. Thanks again.
  9. Hello, I have a details page with an update button where I would like to be able to update the value of a Text Field with the current date whenever a user changes the value of an option in a Dropdown menu and clicks update. The code below below is not working. Any help will be very much appreciated. Thank You. function getT() { document.getElementById("EditRecordpatient_status").onchange == document.getElementById("EditRecordpatient_status_change_timestamp").value = '[@cb:Timestamp]'; } document.getElementById("Mod0EditRecord").onclick=getT;
  • Create New...