Apex Code Development You need to sign in to do that
Don't have an account?
Best Data Schema for tracking attendance or hours worked
What is the Best Data Schema for tracking attendance or hours worked?
Should there be an object with a record for each day, with fields for in and out times? But then data entry involves creating new records for each day?
Or records automatically created for every day of the year and then only times or checkboxes filled in?
Should this hypoethetical Time object be in a master-detail relationship to the Student/Worker/etc object?
Or any other arrangements?
I would appreciate any examples that you may be using.
Thank you!
Should there be an object with a record for each day, with fields for in and out times? But then data entry involves creating new records for each day?
Or records automatically created for every day of the year and then only times or checkboxes filled in?
Should this hypoethetical Time object be in a master-detail relationship to the Student/Worker/etc object?
Or any other arrangements?
I would appreciate any examples that you may be using.
Thank you!
Hi Brian,
You are going in right direction.
Make a Custom Object Attendence Sheet.
Make the Student/Worker as Master Object and Attendence Sheet as Detail Object.
You can include Date, Hours Logged etc in the Attendence Sheet Object.
You have to create record for each day.
OR
You can use one record for a week in attendence sheet.
Then the fields will be like Start Date of week, End date of week. Fields for hours for each day(Monday to Sunday), Total 7 fields for hours.
Records need to be created for each week..
OR
If you can make 30 fields for hours for each day. It would reduce the records number.
Use one record for each month, then the fields will be like Year, Month, 1 to 31 for hours of each day.
Then you have to create one record for each month.
Hope this helps.
Regards.