Duplicate a set of rows for each item (subdatasheet?)

Nov 16, 2017
Reaction score

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question