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.
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.
