Finding empty cell values for 7 days

Is there any way we could have the bot determine if there are no punch records for a particular employee . See below as an example – if a team member has no punches >7 days in a row, I want to sent a mail .

Any easiest way to do it.

Hi @sachinns,
Yes, we can do it if there is any unique id for a employee .

1.We can filter the data table using that employee id.

2.We can then again filter that resultant data table for empty punch records column.

3.Then count the number of rows in the datable with empty records, if it is greater than 7 trigger the mail.


the data is not in a structured way to filter it out. Attaching the file as well.

Attendance Report - Master Data 13-11-2019.xls (548 KB)