CourtneyRapp
7 years agoQrew Cadet
Lock down adding records to a table after a certain time period
I created a time card table to track how many hours an employee spent on a particular project. Each employee will be entering their own hours into the table for every week and I have a subscription setup to notify them Friday morning to double check their time.
Is there a way to setup a weekly time period factor into when they can add new records? For example, If they enter hours today for a project they worked on last week, the table would reject the new addition. I've ran two reports that show the current week and the previous week, and my goal is to make it that they can only add the current weeks hours to the table.
Is there a way to setup a weekly time period factor into when they can add new records? For example, If they enter hours today for a project they worked on last week, the table would reject the new addition. I've ran two reports that show the current week and the previous week, and my goal is to make it that they can only add the current weeks hours to the table.