Another newbie here, we have requested that staff send an email to a mailbox with the subject SignIn or SignOut so that we know who is in the office at any given time. In an emergency this allows us to see who might be stuck in the office in the event of a fire evacuation. This is a short term solution...
I have it all working with Automate and it adds a row in with the persons name and date/time they sent it. The format is a little hard to read and i can't seem to set it to dd/mm/yy hh/mm. It currently looks like 2020-09-24T21:09:46+00:00
The other part is that i only want to store this data for 22 days, how can i get automate to run each night and delete all entries that are 22days or more.


Report
All responses (
Answers (