1 Reply Latest reply on Apr 27, 2014 9:33 PM by philmodjunk

    Total "Checks" per value in checkbox...

    jasonperl_1

      Title

      Total "Checks" per value in checkbox...

      Post

           Hello,

            

           I have a database which I am tracking daily staff. I have a values list "Staff" with all of the names of employees and it populates a check box set for the field ("DailyStaff") so employees can be checked in each day they work. This system also tracks volunteers, who have a minimum number of days they must work which is the main reason I need total days worked per employee. I would like to set something up that will automatically total the number of days each employee has worked based on the information in the "DalyStaff" field and ideally it would just be a running total for all records.

           Before I had every employee entered as a separate field, with a separate summary field for each, but being that I am in a seasonal industry I decided to go the values list for simplicity but now I am stuck on the counting portion. Is there any way to get a count of days worked for each employee based on their checks on the values list?

           Example

           Values list = Employee 1, Employee 2, Employee 3

           If Employee 1 is checked three days and emp 2 is checked 2 days, and 3 hasn't worked, I would like a field that showed that information (emp 1 = 3, emp 2 = 2, emp 3 = 0).

           Any help would be greatly appreciated. Thanks in advance.

           I have looked into the ValueCount and ValueList formulas, but I am not sure those are the right solution... Thanks again.

        • 1. Re: Total "Checks" per value in checkbox...
          philmodjunk

               It will be very difficult to extract such statistics from a return separated list of values in a single field--which is what is produced by such a check box set on a single field. A better approach would be to "check in" an employee by creating a related record with the date worked recorded in a date field. That then allows you to count related records to get the total days worked.

               It's possible to set up a list of employees with a button to check them in by performing a script that creates such a record. And conditional formatting can make that button look and function just like your check box.