Total value in a Calculation Field?

[mauro cappello]

I have a series of records with a Number Field. I would need to use their total value in a Calculation Field on the same Form. Is it possible?

[Brendan]

Hi Mauro,

Yes, this is possible.

You’ll need to write a Script field for it using this code:

function getTotal() {
   var number_field_id = 'fld-....';
   var total_number_field = form.getTotalOfField(number_field_id);
   return total_number_field;
}

getTotal();

You have to provide the proper ID value for number_field_id for your form’s Number field of course.

Set the Return Type of the Script to be Number.

[Author]

Posts