Do Field Events work in List Pages. I've tried for hours...
In a simple accounting project I have a transactions table. I've created a custom view into the table called Reconcile - which ony displays records which have not yet been reconciled against the bank statement (A checkbox field in the record is unchecked).
The Reconcile List Table uses spreadsheet mode because I need to be able to tick the "Reconciled" checkbox as each record/entry is checked against the statement. In the Designer I unchecked inlineEdit for all fields except for the checkbox field.
This all words good. I click the checkbox and the contents of that record row go blank - as you'd expect as the record no longer applies to the custom view which is only displaying records with the unchecked Reconciled field.
What I am trying to do with a "click" Field Event on the checkbox field is, before the contents of that record row is blanked out, extract the value of the "Amount" field in that record and use/store it as a variable. Essentially, I want to do a progressive sum of the "Amount" Fields in the table as I go through selecting the reconciled checkbox in the record.
Hope that all makes sense????