Automatic form-filling for each user, if they don't do it themselves.

So I have an attendance form, wherein people mark themselves as present everyday while submitting the form. I want to write a deluge script in which if a user does not submit the form, the form is automatically filled for the user with the status field marked as absent.

So far, I understand that it will be a scheduled workflow based on an hour of the day, where if the script does not find an entry for a user on the current day, a form will be auto-filled for all the relevant users with the status field as "Absent". Though I'm lost on how to pull all the users in the script.

I would also really appreciate, if one can help with adding holiday exceptions for this. So for an example if we set pre defined holidays in another form and sundays, this script won't function.

Thanks a lot in advance for the long read, please get back if you have any info on the topic.