Gossamer Forum
Home : Products : DBMan : Customization :

Re: Calculate field based on other fields

Quote Reply
Re: Calculate field based on other fields In reply to
The amount will be computed when the record is added. The 'paid' field is editable by admin, but I want the 'balance' field to be based on:
1) Days attended (Sat, Sun, Both)
2) Amount Paid (cfg default is zero)
3) Member status (member vs. non-member)

So there's a total of 6 possible fees (based on membership and days of attendance) and the balance will equal the appropriate fee less the amount paid.

Of these fields, only the member status and days of attendance can be changed by the user. I want the user to see the total fees at the outset, as well as the balance once admin has recorded an amount paid.

At present I have fields for 'paid' and 'balance' but I don't have one for total. I suspect it would be easier if I added this.
Subject Author Views Date
Thread Calculate field based on other fields bboru 1452 Oct 9, 1999, 12:35 PM
Post Re: Calculate field based on other fields
JPDeni 1357 Oct 9, 1999, 2:14 PM
Post Re: Calculate field based on other fields
bboru 1359 Oct 9, 1999, 4:49 PM
Post Re: Calculate field based on other fields
JPDeni 1351 Oct 9, 1999, 5:58 PM
Post Re: Calculate field based on other fields
bboru 1354 Oct 10, 1999, 4:38 AM