Alert when a "check out" event is missing
Hello Fellow SmartSheeters, we're using SS to track when individuals come and go from our laboratory. We're using this to identify individuals at risk of COVID exposure. For example, student A is working in laboratory in limited capacity. She develops COVID symptoms and tests positive. We would like to be able to rapidly identify individuals who were in the laboratory in the 72 hours prior to them testing positive.
In order to determine who may have been exposed, we would like to have a record of when people are in the laboratory. We have a check-in / check-out form that we are using and is working well. However, I would like to send an alert when there isn't a pair of in/outs for a given day.
Any thoughts on how to accomplish this?