Most of the techs in our IT team do desktop support. We support several hundred Windows and Mac users and most of them have computers purchased by funds provided by our organization. We have a fair amount of turnover of employees and computers. Sometimes we replace old computers with new ones. Sometimes we reimage computers because the image is old or the computer gets infected etc.
We have been using a spreadsheet in Google Drive to track this process. We have one sheet for incoming computers and one for outgoing (going into service or back into service). These sheets have columns for the various tasks we do to configure the computers and for the user's name, tag number description, the tech's name etc.
Often the outgoing sheet doesn't get all the data entered because when we start imaging (or reimaging) the box from SCCM, since that can take up to several hours we go do other tasks and sometimes forget to complete all the fields in the sheet. This is a source of frustration for our supervisor as he wants us to fill in all these fields.
I thought that if we had a system where any row in the sheet (equivalent to a record in a database) was started but not completed after a certain amount of time or let's say each day at 6:00 am that system would send an email reminder to the tech whose name is on that record as a reminder to finish filling in all the fields in the record. We typically enter our user name as the tech's name and this is the part of our email addresses before the @ sign so it seems simple for the system to take the tech name and build the email address to notify the tech of the incomplete record.
I realize this is a pretty ambitious request but does anyone know if MS Access or SQL can do this? If not then is there a commercial application that can do this task?