Attendance tracker (1 Viewer)

MajP

You've got your good things, and you've got mine.
Joined
May 21, 2018
Messages
8,778
In response to

Here is a properly designed attendance tracker with a few bells and whistles. It allows you to color code one or more attendance codes for a given dates. This uses color codes stored in the attendance code table and then uses rich formatting to wrap the attendance code. Obviously without the color coding and multiple events per day this would be even simpler.

The data is entered in a normalized format.
ex
tbl_Attendance tbl_Attendance

AttendanceIDAbsenceDateEmployeeIDAbsenceIDAbsenceTimeAbsenceReason
169​
5/1/2024​
3​
2​
8.00​
Personal Day
177​
5/2/2024​
3​
4​
8.00​
Called in at 4:30am and left a message stating he needed a FMLA day due to his sinus issues and a doctor appointment.
184​
5/2/2024​
3​
1​
6.50​
Bobs wife called several times about the smell of a natural gas leak smell in the house. Bob left at 7:30pm
191​
5/3/2024​
3​
2​
10.00​
Personal Holiday
194​
5/3/2024​
3​
17​
8.00​
Vacation
218​
1/4/2024​
3​
1​
2.00​
In Trouble
219​
2/5/2024​
3​
19​
1.00​
Smoking dope
220​
3/6/2024​
3​
6​
12.00​
Jury duty
225​
1/1/2024​
3​
1​
1.00​
Sick
226​
1/1/2024​
3​
4​
2.00​
death
227​
9/2/2024​
3​
20​
4.00​
Test
228​
3/2/2024​
3​
16​
5.00​
Test
229​
3/3/2024​
3​
5​
5.00​
Test
231​
2/1/2024​
3​
1​
5.00​
Bad
232​
2/1/2024​
3​
2​
3.00​
Excused
248​
5/1/2024​
3​
4​
2.00​
Death in family
In this case you can have more than one absence code for a given day and assign an amount of time.

There are currently two working views. One view you can pick an employee and assign all of their absences for a given year. The other shows all the employees and you can assign absences for a given month.
In the image below the Year view is shown over the month view for employee Chad Zebra for the month of March.
You can see on 24 march on both calendars there are two absence codes.
The two calendars basically use the same code to format the dates. There are only slight modifications.

If you do not like the format you can modify it easily, but the code should be pretty reusable.

Year.png


If looking for other trackers, calendars, or calendar controls see
 

Attachments

Last edited:
AttendanceError.PNG

I get this error on opening, i think it's the language setting. "mrt" is short for March in Dutch. What would be a quick fix, without using the windows language settings?

May be using month numbers?
 
Name your forms appropriately?
Or convert mrt to.mar ?
 

Users who are viewing this thread

Top Bottom