Aggregate Amount Field

Viewing 2 reply threads
  • Author
    Posts
  • November 14, 2021 at 6:33 PM #45703

    Tim Flick
    Participant

    Is there anyway aggregate an amount field in ios and have it show on the form itself

    thanks tim

    November 15, 2021 at 2:49 AM #45707

    Brendan
    Keymaster

    Hi Tim,

    Yes you can do this with a Field Script.

    Use this code in a field to display the aggregate total of all the records in the form for the specified field:

    function getFieldTotal() {
       var field_id = 'fld.....'; // whatever the field ID is for the field you want the total of.
       var total = form.getTotalOfField(field_id);
    
       return total;
    }
    
    getFieldTotal();
    November 15, 2021 at 7:14 AM #45711

    Tim Flick
    Participant

    Works GREAT THANKS MUCH

    Tim

Viewing 2 reply threads

You must be logged in to reply to this topic.