Method Community

 

Subtotal field

Last post 03-08-2011 7:29 AM by Matt. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-07-2011 9:07 PM

    Subtotal field

    Hello, I've added a column in InvoiceLine details for "weight". In the invoice screen I've also added a field for "Weight Subtotal". I'd like this "Weight Subtotal" field to function similarly to the way "Subtotal" works for the column "Amount" (automatically adding up my newly created column for "weight"). Please advise on how to edit this field.

    Thanks,

    Andy

  • 03-08-2011 7:29 AM In reply to

    • Matt
    • Top 10 Contributor
    • Joined on 11-03-2008
    • Posts 877

    Re: Subtotal field

    Hi Andy,

    You'll want to add a couple of actions to the the 'Actions after add' and 'Actions after edit' (Steps 6 & 7 of the grid wizard). The actions you will want to use are:

    Get sum (from the Weight column of the InvoiceLine grid)

    Enter value into field on screen (to enter the sum into the weight subtotal field you added).

    Hope that helps!


    Matt Raiser

    Founder,



    www.techinthefield.com

    matt@techinthefield.com

    219-221-9500



    ~ Method user / partner since 2008

    ~ Over 15 years field service experience

    ~ 2013 Method Partner of the Year

    ~ Degree in Computer Science





    Creator of:


        


Page 1 of 1 (2 items)