How to Count Checked Items in Checkbox ?
Binu Alexander 18 Jun, 2015 6:55 PM
I am developing a solution for a Book translation agency . They require the monitoring of the chapters translated in each language and thus to know the status of each Book being done . The format for reporting by translators is like this :
I plan to use check boxes / to mark the Chapters completed for each book .
What I need to know is how can I count the the checked chapters ( YELLOW ) and display it in the fields on the right (GREEN) ?
Is there a script that can be written or a feature in Filemaker that can help me with this ?
ValueCount ( checkBoxField )
will return the number of selected values in the field.
But in some cases, it may be better to have one related record for each chapter where setting the check box sets a value in this related table or which even creates or deletes that record. This can make some other types of reporting easier to set up.