Conditional report emailing?
Hi there - greetings from the Merchandise Mart in River North! The main app we have here at Allstate is a weekly timesheet app where everyone enters their working hours at the end of the week - it'...
Forum Discussion
Hi Dustin, what if you had a Formula - User field on each record in the employee table, and that field contained a conditional formula. If that employee has logged less than 40 hours for the previous week, then the formula shows that user. But if they have already logged at least 40 hours for the previous week, then the formula would just be blank.
That way, you can set up a simple email reminder on Mondays which would always send to the user listed in that field. You could use a summary field, depending on how your app is set up, to count the # of hours each employee has logged during the previous week.
(I'm assuming here that, for employees that haven't logged a time card for the previous week, they have no record yet on the time cards table for that week.)
------------------------------
Brian Cafferelli
------------------------------
That way, you can set up a simple email reminder on Mondays which would always send to the user listed in that field. You could use a summary field, depending on how your app is set up, to count the # of hours each employee has logged during the previous week.
(I'm assuming here that, for employees that haven't logged a time card for the previous week, they have no record yet on the time cards table for that week.)
------------------------------
Brian Cafferelli
------------------------------