Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

How to get a total from certain fields?

Quote Reply
How to get a total from certain fields?
Hello,

I have about 60 fields that either will contain a number 1 through 4, or they won't contain a number at all.

I'd like to be able to add up all of these fields to get a grand total of the numbers in them. Is this possible, I assume it is, could someone help me out on this (unless it's too time consuming, It's not that big of a deal to have, just would be nice if we did).

Data is stored in the main Links database

Columns are in the Links table (I assume, it's the same table where people would normally enter their link information)

Fields are named cardqty1 through cardqty55

Thanks for your time, it is greatly appreciated.
Subject Author Views Date
Thread How to get a total from certain fields? Westin 12792 Apr 29, 2009, 5:29 AM
Thread Re: [Westin] How to get a total from certain fields?
Andy 12573 Apr 29, 2009, 5:38 AM
Thread Re: [Andy] How to get a total from certain fields?
Westin 12553 Apr 29, 2009, 5:46 AM
Thread Re: [Westin] How to get a total from certain fields?
Andy 12587 Apr 29, 2009, 5:50 AM
Thread Re: [Andy] How to get a total from certain fields?
Westin 12580 Apr 29, 2009, 6:41 AM
Thread Re: [Westin] How to get a total from certain fields?
Andy 12571 Apr 29, 2009, 7:23 AM
Thread Re: [Andy] How to get a total from certain fields?
Westin 12572 Apr 29, 2009, 7:34 AM
Post Re: [Westin] How to get a total from certain fields?
Andy 12543 Apr 29, 2009, 7:51 AM
Thread Re: [Westin] How to get a total from certain fields?
Andy 12596 Apr 29, 2009, 7:59 AM
Thread Re: [Andy] How to get a total from certain fields?
Westin 12562 Apr 29, 2009, 9:31 AM
Thread Re: [Westin] How to get a total from certain fields?
Andy 12657 Apr 29, 2009, 10:02 AM
Thread Re: [Andy] How to get a total from certain fields?
Westin 12436 May 10, 2009, 7:16 PM
Thread Re: [Westin] How to get a total from certain fields?
Andy 12451 May 10, 2009, 11:30 PM
Thread Re: [Andy] How to get a total from certain fields?
Westin 12463 May 11, 2009, 3:26 AM
Thread Re: [Westin] How to get a total from certain fields?
Andy 12482 May 11, 2009, 3:32 AM
Thread Re: [Andy] How to get a total from certain fields?
Westin 12488 May 11, 2009, 6:21 AM
Thread Re: [Westin] How to get a total from certain fields?
Andy 12472 May 11, 2009, 6:34 AM
Post Re: [Andy] How to get a total from certain fields?
Westin 12422 May 12, 2009, 1:35 PM
Thread Re: [Westin] How to get a total from certain fields?
Andy 12411 May 12, 2009, 11:29 PM
Thread Re: [Andy] How to get a total from certain fields?
Westin 12459 May 13, 2009, 12:13 AM
Post Re: [Westin] How to get a total from certain fields?
Andy 12351 May 13, 2009, 12:22 AM
Thread Re: [Andy] How to get a total from certain fields?
Westin 12354 May 13, 2009, 12:32 AM
Thread Re: [Westin] How to get a total from certain fields?
Andy 12417 May 13, 2009, 12:46 AM
Post Re: [Andy] How to get a total from certain fields?
Westin 12402 May 13, 2009, 3:52 AM