Hi,
I'm trying to build a staff presence tracker. I have a list of employees and I need to put 365 days next to each employee. There are a lot of employees though so this would take a lot of copying and pasting, and adding or deleting staff would be time-consuming. Here's what it's starting to look:
Name Date Presence
John. 01/01/17. Sick
John. 02/01/17. Working from home
John. 03/01/17. Present
Etc. Repeated for all staff. Is there an easier way to do this? Can I add a subfield for date? I know putting each date as a column would eliminate this issue but this would require lots of scrilling. Any ideas would be much appreciated.
I'm trying to build a staff presence tracker. I have a list of employees and I need to put 365 days next to each employee. There are a lot of employees though so this would take a lot of copying and pasting, and adding or deleting staff would be time-consuming. Here's what it's starting to look:
Name Date Presence
John. 01/01/17. Sick
John. 02/01/17. Working from home
John. 03/01/17. Present
Etc. Repeated for all staff. Is there an easier way to do this? Can I add a subfield for date? I know putting each date as a column would eliminate this issue but this would require lots of scrilling. Any ideas would be much appreciated.