Automatic recurring background actions on database

Need help Database
1

I want bubble to check the database for specific data in the database, and delete it.

I want it to happen once a day.

It should be triggered automatically, has nothing to do with User Interface element event.

How do i trigger this?

1 Like
2

I think you’d use a scheduled workflow. If you want to do it once a day, you’ll need be on the Team plan, according to bubble.is/pricing

3

@andrewgassen if it’s a daily scheduled workflow event the free tier of Zapier can do that… Set up and end point and run the Zap against that with whichever criteria you need

myzap
myzap.png1270Ă—805 42.3 KB

3 Likes
4

Neat! I haven’t integrated Zapier in one of my apps yet, so that’s handy to know. Thanks for sharing!

5

I was always actually quite reluctant… Adding another service…Blocksrping, Zapier etc etc is just adding additional another overhead not in terms of cost in this case but the risk of something failing and adding unnecessary complexity. I was pleasantly surprised just how efficient and quick… There is a clear update every day on its success (you can see report any time you login ) and in this case if it’s only a daily occurrence fits within their free plan. But I’m trying to do bubble out of their revenue nor am I trying to scavenge free services… If we don’t pay for this stuff in the end the services will not be provided.

6

@andrewgassen

I don’t see anywhere in the Event where i can specify the Frequency of the event

7

Hi @Bubbleboy, thanks for sharing this. Do you know if using Zapier for making API Workflows recur is still the most viable method?

8

I’m not him, but you can use a scheduled workflow that reschedules itself to run again in 24 hours from now.

1 Like
9

Oh nice thank you! I was trying to find something like that but couldn’t, would you be able to link me to some kind of doc or tell me where i’d set that up?

10

For sure! There’s this entire thread about it, it concentrates most of the knowledge about the subject. There are some gems scattered around the forum that you can do searches for, but with this thread you should be able to get it rolling already:

1 Like
11

Ah what the heck haha, idk why I didn’t think of that. Thanks a bunch!

12

yes, i prefer this over Bubbles inbuilt option