Alex,

Just one thing, when the NZ* Std is filled, it gives an error to fill an integer?

Alex,

I wanted to take it a step further in terms of calculations, Please see the code attached:

$(document).ready(function(){
  $.getScript('http://localhost/Forms/js/moment.js');
  $('.cf-table-block').on('change', function(){
    $('.cf-table-block tbody tr').each(function(){
      var beginn = moment($(this).find('.beginn select').val(), 'HHmm');
      var ende = moment($(this).find('.ende select').val(), 'HHmm');
      var pause = parseNumber($(this).find('.pause select').val());
      var pax = parseNumber($(this).find('.pax select').val());
      var $stunden = $(this).find('.stunden input');
      var $nz = $(this).find('.nz input');
      var $price1 = $(this).find('.price1 input'); //NEW
      var $price = $(this).find('.price input'); //NEW
            
      
      var hours = ende.diff(beginn, 'hours', true) - pause;
      var over = ende.diff(moment('0', 'HHmm'), 'hours', true);
      var nzhours = ende.diff(beginn, 'hours', true);
     
          if(hours < 0){hours += 24; $nz.val((over + 1).toFixed(2));}
      		else{
          		if(over > 23){$nz.val((over - 23).toFixed(2))}
        		else{$nz.val((0).toFixed(2));}
      }
      
      $stunden.val((hours).toFixed(2));
     $price.val((pax *$stunden)*$price1); //NEW
  
    });
  });
  
   
    function parseNumber(n){ 
    var f = parseFloat(n);
    return isNaN(f)?0:f;
  } 
});

I am trying to make the calculation generating result on field price.

it has to be multiple of pax & stunden, the resulting number should be multiplied with price 1, resulting in the value in price.

When I use the code above , I get NaN in price?

I have only modified lines, 11, 12 & 26

Thanks a lot in advance!

Hi Sahil,

Each variable that starts with "$" is just the selector, not the value (they do not have ".val()" in the declaration). Therefore, $price1 (line 11) should be:

var price1 = parseNumber($(this).find('.price1 input').val());

And line 26 should be:

$price.val(((pax*$stunden.val())*price1).toFixed(2));

Alex,

Thanks, what I don't understand is if line 11 is to be the way you mentioned, then why not line 12?

My thinking is in line 11 I gave $ because it's a CSS class, is that correct?

Another thing

• NZ* Std still gives the error , Please enter an integer
• & the calculations do not follow if I add rows in the table.

Thanks a lot in advance!

The "$" before the variable name does not mean anything, it is just a handy way to see which variables are selecting elements and not their values. The ones without "$" all have ".val()" at the end.

The second line I gave you is wrong: $price1.val() should be price1