JQgrid total amount row

by

If I understand you correct you want to place in the footer getCol and footerData methods:

var grid = $("#list"),
    sum = grid.jqGrid('getCol', 'amount', false, 'sum');

grid.jqGrid('footerData','set', {ID: 'Total:', amount: sum});

The getCol can be used to calculate the sum of all numbers from the ‘amount’ column and with respect of footerData you can place at the bottom of the 'ID' column the text “Total:” and at the bottom of 'amount' column.

UPDATED: Probably you have problems because you place the code in the wrong place. The most safe place for the code is loadComplete event handler. Look at the demo.

More Related Contents:

  1. JQuery Grid-SubGrid for Parent-Child relation
  2. jqGrid returns blank cells
  3. Mapping JSON data in JQGrid
  4. jqgrid subgrids from a single nested json
  5. Setting Access-Control-Allow-Origin in ASP.Net MVC – simplest possible method
  6. Can JSON start with “[“?
  7. What JSON library to use in Scala? [closed]
  8. Parse JSON with R
  9. How to decode a property with type of JSON dictionary in Swift [45] decodable protocol
  10. Reading in a JSON File Using Swift
  11. How to rename JSON key
  12. How to query a json column for empty objects?
  13. Angular 2: Get Values of Multiple Checked Checkboxes
  14. Return JSON from ASMX web service, without XML wrapper?
  15. JSON or XML? Which is better? [closed]
  16. Best way to save data in Unity game [closed]
  17. What is the JSON format? [closed]
  18. ASP JSON: Object not a collection
  19. What is the difference between resource and resource representation in REST?
  20. jQuery AJAX request failing in IE
  21. Decode base64_encode Image from JSON in Swift
  22. how to convert json string to dataframe on spark
  23. How to decode JSON in Flutter?
  24. Error parsing JSON file with the jsonlite package
  25. Node.js -Firebase Service Account Private Key won’t parse
  26. deserialize a datatable with a missing first column
  27. is it possible to proccess JSON responses with the JDK or HttpComponents only?
  28. Type ‘{}’ is not assignable to type ‘IntrinsicAttributes & IntrinsicClassAttributes
  29. Register/login user with WordPress JSON API
  30. How to dynamically display a multiline text in D3.js?

Leave a Comment