Attendance Tracker

Thanks Mark, this was very helpful. I am about 95% of the way there now but trying to figure one last thing out. The only thing I really changed from what you said is that I had the pipeline create all the entries in another tracker table but with the attendance NOT selected. Instead, I created a third table with a form that triggers a pipeline to fill in the attendance as checked when the corresponding area and shift is selected from that form. 

It all works almost perfectly, but I want a field that you can choose any employees that are absent for that day and those attendance check blocks in the tracker table will not be checked from this second pipeline.

My second pipeline is set up by triggering On New Event when the area / shift are selected. Then it will search records in the tracker table that have the matching area and shift from this new table. Then a For Each Loop that search those records in the tracker table and update the record with the check block as checked. 

What I was trying to do was add in a multi-select field in the new table where you could select the employees absent (a pre-made list) and those employees would not have their check block checked. I was thinking of doing this by adding that as a filter in the "search records" part of the pipeline (the second step) where the employee in the tracker table does not equal this multi-select field. But it appears you cannot have it do this with multiple employees selected. Do you know if there is a way to make this possible or some workaround?