Update Field table

[NeoInJS]

I have a single update form that receives a parameter in a Virtual field. I need to update an existing field (FulfilledQtyDiaper) by adding its current value and the value of the virtual field. I have this script in my Footer but it is not working.

 

<br />
<SCRIPT LANGUAGE="JavaScript">

 

function UpdateQty()
{
       var d = parseInt(document.getElementById("cbParamVirtual1").value);
 

        var newd = d + parseInt(document.getElementById("EditRecordFulfilledQtyDiaper").value);
   

        document.getElementById("EditRecordFulfilledQtyDiaper").value  = newd;
       

}
 document.getElementById("caspioform").onsubmit= UpdateQty;

 

</SCRIPT>

[nightowl]

Hi NeoInJS,

I tried the script on my end and it works out-of-the-box. Please check the following to ensure that the script works on your end:

1. The FulfilledQtyDiaper table field must be a Number.
2. On the Single Record Update DataPage, the FulfilledQtyDiaper must be displayed as a Text Field. You can check this setting in the Standard tab of the Configure Fields screen, under General Options  > Form Elements.

Hope this helps.