I have a database of companies and would like to send them different recurring emails at varying frequencies depending on what they have subscribed to (this is depicted by a field attached to each company).
I have a field (subbedwkflw - list )attached to each company which decides what emails they should receive.
Email A - should be sent yearly
Email B - should be sent quarterly
Email C - should be sent quarterly
Im on the personal plan and it looks like I can on set a recurring event (send email A, send Email B send, Email C - recurring event) per thing. This isn’t great as I want to go through all the companies and set a recurring workflows to send emails dependant on what each subbedwflw field contains.
I ve tried using the database trigger workflows for each email with conditions that check if the email type is in the subbedwfklw field and then it should set the recurring workflow. But this has shot up my WKU into the 20,000s for running it on 3 companies in app.
I just need a way of setting whatever recurring workflows that is mentioned in subbedwkflw field for each company.
How can I do this in an optimised way and without having to upgrade to a more expensive plan?
Backend workflows that schedule themselves after sending the email and scheduling them according to the concept you outlined of quarterly or yearly…basic math can get that correct so you have things for schedule and use ‘current date plus year 1’ or ‘current date plus months 4’
thats a great way of setting the frequency intervals thanks. But how would I initially trigger the workflow that sets the recurring workflow of sending the regular emails ? it looks like i can only set one per company at the moment or am i getting confused ?
I do not keep track of the changes Bubble makes to their plans and included feature sets, so that may be the case.
Schedule the backend workflow when the user does something in the app, like signup or when they provide the information needed to populate the emails.
currently i have it set up as shown:
So the app user selects that a company should be sent Email A, Email B and Email C an api workflow gets called which adds the email to the company subbdwklw field and also set the recurring events with the conditions that only allow it to be set if the email type is in the subbdwkflw field. So when i run it now it only sets on out of the 3 recurring workflows where it should set all three?
As you can see its only set Annual accounts email when it should have set PAYE and VAT too.
so would that be done individually or is there a way i can do it on multiple companies ate on time?
@jici helped me out, had a separate thing per email type
