 |
| ||||||
| Scripting - Show Exception Employee's in a Summary Report | ||||||
| ||||||
| Question | |
| ||||
| We have a client that wants to use an exception script to flag late employee's and have a report that will only show the excepted employee's. Can this be done? | ||||||
| Answer | ||||||
| If certain criteria are met for our script this can be done using a script and a clock prompt which we can then filter for in the Summary Report. First we will need to set up one of the labor clock prompts (x/y/z), for our example we will use 'y'. Al that needs to be changed is the 'Data Collection Mode:' field to 'Show online, but do not collect anything' and the 'What do you want to name this field?' to what you want the column on the time card to say. For our example we will use 'Employee Late'. Now you will save the prompt. Next we will need to know the employee's start time or the time the client wants to use for the exception. In this example we will use 8:00am. Below is an example script for the exception based on our example time (8:00am): if (inismissing = false and istimes = true) { if (intime >= 8:01am) { exception = "Employee is LATE!" ; y = "Late"; }} This is basically the Scripting - Exception but we add the 'y = "Late";' which will display (when triggered) a column on the time card based on our clock prompt we setup earlier and the word 'Late' next to the exception punch. Now all we do is go to Reports > Summary Report and to have it filter for this exception, in the 'Filter By:' drop down box select our prompt (Filter by Y/Employee Late) and in the next pop-up box 'Which one?' enter 'Late' (without quotes) which is case sensitive. An issue that can come up is if the employee's have breaks because this can potentially interfere with the script. What happens is the script sees the in punch off of the break and if it falls within the exception script it will also flag this. To resolve this you may be able to add an hours script that will only do it off of a certain hour range. See below for an example. if (inismissing = false and istimes = true) { if (intime >= 8:01am) { if (hours < 3) { exception = "Employee is LATE!" ; y = "Late"; }}} We add to our earlier script the 'if (hours > 3)' so that the in punch must be assigned to a punch lasting less than 3 hours before it triggers. You would just edit the amount of hours used to fit within the employee's schedule to match the amount of hours they usually work before they take a break. If you have further questions on this issue please submit a Support ticket to us. Also attached is a how to document with visuals on this procedure Exception Reportst.doc | ||||||
| Back to Search Results | ||||||