Increment value in one field based on status in another field

[Mylene 0]

Hi everyone,

I need to increment value in one field only if Status is "Approved". Type of the datapage is a submission form.

Thanks!

[Mathilda 64]

Hi, you may use the following script in the footer of the datapage:

<SCRIPT LANGUAGE="JavaScript">
 
function calculate()

{
var check = document.getElementById("InsertRecordField_name").value;

if(check =="Approved"){

var v_increment = parseFloat(document.getElementsByName("cbParamVirtual1")[0].value);


   document.getElementById("InsertRecordField2").value = v_increment+1;
 }
}

 document.getElementById("caspioform").onsubmit=calculate;

</SCRIPT>

You need to use a virtual field to sort values in descending order and get the last submitted value, then increment value and write in a field

[Mylene 0]

It works! Thank you very much!