I would like to check each morning for a form submission due but not yet submitted.
I have a list of people who are required to submit a form for today (Monday through Friday) by 9AM the next day. They are asking for a reminder to be generated at 7AM if they forgot to submit the form yesterday. I will use my SMS function or Sendmail to send the reminder.
The people submitting the form choose their name from a filtered lookup to a separate application.
The form has Date_field which collects the date the form is being submitted for.
Any advice on how to set this Schedule up?
Thanks!!