Hi All,
I have a table where I am storing users date of birth. It has around 15k rows. I need to send them birthday wishes on their birthday. What would be the best way to approach this?
Thanks.
You can use a recursive backend workflow, scheduled every 24h, that checks users whose birthday is today, and perform whatever action you define.
Hey you can try to use a recurring event daily to check if the current date is the user’s birthday and if so send him a message (in this case try to run it outside peak hours).
Or you can create a schedule workflow.
For example, once the user sign up to your page set a schedule workflow do be triggered on his birthday. The problem on this last case is that if the user changes his birthdate then you’d have do remember to change the scheduled workflow too.
So probably the recurring event would be the best option if you wish to send an email for instance.
But if you want merely to display something on the page when the user is logged in them just use a conditional to show something (e.g.: a popup) when page is loaded and current date = current user’s birthday.
You can set up a backend workflow in Bubble to check birthdays daily and send wishes automatically. Create an API workflow that runs every day, looks for users whose birthday matches the current date, and sends them a message. Use a “Do a search for” action in the backend workflow to find users with today’s date (excluding the year) in their date of birth field. Then, trigger an email or notification for each user. To automate this, schedule the workflow to run daily at a set time.
This topic was automatically closed after 70 days. New replies are no longer allowed.