jQuery Grid Plugin - jqGridForum

Topic RSS

Related Topics sp_TopicIcon

Column sums/totals automatically updating - how to?

Tags: data manipulation summation

04/01/2012
23:58

bcates

New Member

Members

Forum Posts: 1

Member Since:
05/01/2012

Offline

Excellent product, and excellent accompanying tutorial. Thank you very much.

My specific question with a specific reference:

Referring to the tutorial for a basic example, you have a :

Date,Client,Amount,Tax,Total that correspond to an invoice number.

The dollar amounts for amount is $1000, tax is 0; so total is $1000.

I would like if I enter 500 into tax, that it calculates the total and displays it as 1500. I know that in this basic page total is not part of a calculation, but I'd like to learn how to incorporate that into my project.

Please advise if this is possible and point me in the right direction.

Thanks a lot,

Ben

05/01/2012
02:23

nelsonm

Michigan, USA

Member

Members

Forum Posts: 106

Member Since:
20/08/2011

Offline

jqGrid does not do calculations on data, it just creates tables and forms. Calculations on data generally happens on the:

server side in the sql query statement when you query for data or in the php code after the query.
and/or on the client side in javascript after user input.

jqGrid, however, does allow you to define events that trigger functions to allow you to do calculations at various points and fields. Either way, you will have to do the coding to calculate subtotals, taxes, surcharges, totals and so on…

good luck.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
32 Guest(s)

Currently Browsing this Page:
1 Guest(s)