Total value in a Calculation Field?

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Total value in a Calculation Field?

Viewing 1 reply thread
  • Author
    Posts
  • October 25, 2020 at 1:44 AM #42393

    mauro cappello
    Participant

    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?

    October 26, 2020 at 12:23 AM #42412

    Brendan
    Keymaster

    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
Viewing 1 reply thread

You must be logged in to reply to this topic.