Jump to content

Field Validation In Tabular Report Page

Recommended Posts

I need to ensure that values in a column in a tabular report are between 0 and 100 (They are meant to be a percentage impact figure to be entered by the user). I studied the JS example of creating column totals in a tabular report (see http://forums.caspio.com/index.php/topic/3171-js-calculate-column-sum-in-the-result-page/ ) and modified the code as follows, but I cannot get the script to fire at all. I added a number of debugging statements to no avail. I have tried an "onsubmit" type of call as well, apart from the below example. Ideally there should be a way to fire this at the end of adding / editing each row, but I could live with at the end of  the whole page as well. 

At the end of the Header:
<div id="cb_checkImpact">
At the beginning of the Footer:
function f_check() 
  alert('Inside function');
   var v_impact = 0;
   var cas_form = document.getElementById("cb_checkImpact");
   if (cas_form.getElementsByTagName("table").length > 0) 
      alert('Found records');
      var cas_rows = cas_form.getElementsByTagName("table")[1].getElementsByTagName("tr");
      for(var rowIndex=1; rowIndex < cas_rows.length; rowIndex++) 
        alert('Inside row loop');
         var cells = cas_rows[rowIndex].getElementsByTagName("td");
         /* 1 – change value inside brackets to choose column to perform validation */
         v_impact = cells[2].innerHTML;
         alert('Found value:');
         if ( parseFloat(v_impact) < 0 || parseFloat(v_impact) > 100){
            alert('Value in %Impact field must be between 0 and 100');
         alert('No issues found');
alert('About to call function');
alert('Finished function');
Link to comment
Share on other sites

  • 10 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...