Is it possible to have a job that can run daily. I want to have email reminders for meetings that are two weeks out. For example, If i have a meeting on June 12, 2024. I want an email reminder of the meeting 2 weeks before the meeting. Ideally, I would like it to comb through my database for meeting dates, and send out reminders if the meeting dates are withing 2 weeks. So this job will need to be ran daily not scheduled.
@magazine yes, this can be done quite easily 
You would set up a backend workflow that runs every 24 hours and within the you would do a workflow to sendemail but have a condition on it that it will only run if the job date is = jobs date - 14 days.
I hope that makes sense.
1 Like
@pattokane
Thanks Pattokane, if i make this job in the backened, does any workflow need to trigger it or will it run on its own? How do I schedule date for every 24 hours? Do i select it to run as Schedule date = Currente date/time? I would assume i would then somehow need to trigger it but not sure how.
So you would need to trigger it from some. What you can do is stick a button on a test page that triggers this and then once it is setup properly it will just run.
To set it up for every 24 hours…
For the trigger you will have it trigger at currentTime or a specified time of your choosing.
First step would get a list of meetings that job date is = jobs date - 14 days. You want to also have a trigger here that schedules the first schedule (first triggered one) for currentTime+24hours.
Then you would set up another scheduled workflow that would iterate through the list and within this workflow, you would send the email. Gets a little tricky at this point coz you would want to trigger the second workflow (one iterating through the list) as long as the list of emails is >1.
I hope this all makes sense lol I am not the best at explaining things. If you need help reach out 
1 Like
Thank you, this is helpful to know it needs to be triggered some how.
@pattokane , so i am testing it out, and i triggered it. It isnt correctly set up but I am getting non-stop emails at the moment as it is automatically running. How do i stop the backend workflow. I tried to delete it in the workflow but it is still going!
Also, should my workflow for schedule API workflow be a schedule api workflow on list? I am wondering if the list to run on should be “Do a search on meetings with date == …”
Ah thank you for the video @pattokane ! my email was getting bogged down!
Haha I have done that kind of thing plenty of times
As I said if you need some help I can jump in and have a look
Sounds good, thanks @pattokane will take you up on your offer. Will PM you.
Also, If in my database, I am storing the date of meeting from a date picker, which stores it as date and time, if i do current date/time + 14 days. would it be exactly 14 days to the exact time. Would this mean that it would not catch meetings that don’t occur 14 days from the trigger at the exact hour? I am trying to figure out how to extract the date and time to just date. I tried to look into the current date/range in dynamic insert but do not understand how to use it.
This topic was automatically closed after 70 days. New replies are no longer allowed.