Change the total based on the checkbox value [message #588327] |
Tue, 25 June 2013 01:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/529b0fc41767dfed25d52d9f5a7c5339?s=64&d=mm&r=g) |
kotwani.div@gmail.com
Messages: 1 Registered: June 2013
|
Junior Member |
|
|
Hi,
I have created a custom form which fetches certain records. There is a column called invoice_create_flag which is check box. By default when we query this form, value of check box is 'Y'. Another column is Amount.
Initially when form is called, all the records are selected. Hence it should show the total of all the records.
Now If the users unchecks any record, System should deduct the amount of that particular record from the total amount.
Could anybody help me to achieve this functionality.
Attached is form screenshot for reference.
|
|
|
Re: Change the total based on the checkbox value [message #588401 is a reply to message #588327] |
Tue, 25 June 2013 10:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
How do you calculate the total amount? Manually, or is it a summary column? If "manually", you might use WHEN-CHECKBOX-CHANGED trigger (and add/subtract amount to/from total amount. If you used a summary column, I *think* (don't have Forms here - you'll know better as soon as you check its Property Paletter) you can't include any condition in there so you'd need to switch to a manual option.
|
|
|