Scheduling a recurring newsletter

Hello everyone,

I am new to bubble and still learning as I go. Wanted to have opinion of seasoned users to ensure what I did is good/optimal. :grinning:

Thank you in advance for your help!

What I am trying to do
I have users that can setup one or various newsletters from their admin. I want the system to send these newsletters every monday 9am on Paris timeline.

How I implemented it / want to implement it

  • I created a backend workflow to send the newsletter.
  • Everytime a newsletter is created, I am scheduling this backend workflow and storing the scheduled workflow id.
  • If a newsletter is deleted I go and delete the scheduled workflow using the id.
  • If a newsletter is modified, I am removing and reprogramming a workflow. Because from what I understood, at the time of scheduling I don’t send a reference of the object so if its modified I need to reschedule so that the right newsletter is sent.
  • Then in the scheduled workflow, I just automatically reschedule for the next week and refresh the apiworkflow id reference.

Multiple questions:

  1. Is the overall logic here ok?
  2. Is the following setup ok to setup an email to be send next monday? I have a hard time with this one.