JS Calculated fields not saving in DB

Question

Hi there,I hope someone can help me solve this problem. I have a form with 3 different fields being calculated by a custom javascript. The javascript is working as it should displaying the sum of the fields. The problem is that when the form is saved to the database the sum that is calculated is saved in the database as a 0. I need it to save the numbers that it is displaying to the users. I have tried many things trying to resolve this but I am afraid it is above my coding skillset and need any help I can get. I have included the JS and Form code below and attached screenshots of the database schema and the results that are saved:window.addEvent('domready', function () {       $('pinicial').addEvent('change', rekenen1);     $('pfinal').addEvent('change', rekenen1); });  function rekenen1() {     $('tprinted').value = parseInt($('pfinal').value) - parseInt($('pinicial').value); } window.addEvent('domready', function () {     $('timpresas').readOnly = true;     $('rinicial').addEvent('change', rekenen2);     $('rfinal').addEvent('change', rekenen2); });  function rekenen2() {     $('timpresas').value = parseInt($('rinicial').value) - parseInt($('rfinal').value); } window.addEvent('domready', function () {     $('subtotal').readOnly = true;     $('timpresas').addEvent('change', rekenen3);     $('vendidas').addEvent('change', rekenen3);     $('mermas').addEvent('change', rekenen3);     $('cortesias').addEvent('change', rekenen3);  });  function rekenen3() {     $('subtotal').value = parseInt($('vendidas').value) + parseInt($('mermas').value) + parseInt($('cortesias').value); }                                                   Printed Incial                                                             Printed Final                                                             Total Printed                                                             Remain Inicial                                                             Remain Final                                                             Total Impresas                                                             Vendidas                                                             Mermas                                                             Cortesias                                                             Subtotal                                                             Responsable

GreyHead · Accepted Answer

Hi JMac201,

In the HTML you posted earlier there is a Custom validation on the input validate['custom:rekenen3'] it could be that this is returning the error. I guess the function needs to return a 'true' if the validation is passed?

Bob

PS If you are using that custom validation to trigger the validation it might be better to use a standard event instead.

Forums

JS Calculated fields not saving in DB