I’m creating an application that informs when the invoice is overdue, but I need the “overdue invoice” information to be dynamically changed in the database when it exceeds the current date, I’ve tried several ways but the data is not changed in real time. Can someone help me?

[image] Change database when condition is true Database Hi there, @felipe.kluk … so, first, we will assume you’re on a paid plan based on the advice you were given in the first thread where you asked this question. Given that you have access to backend workflows, here is an…

You’ll need to schedule a backend workflow to run on the due date of the invoice, which can change the relevant information.

Thank you, in this case do I need to migrate to the paid bubble plan?

Yes, indeed, you can’t run backend workflows on a free plan…

Is the “Personal” plan enough in this case?

Yes, all paid plans give access to backend worklfows.

@adamhholmes thanks for the help, but I’m still at a loss as to how I’m going to make the bubble automatically update the data, I tried using a trigger and the change is made when I register a new invoice, but when the date is greater than the current date, the change doesn’t automatically occur in…

Are there any videos or tutorials that show how to do this?

@felipe.kluk You don’t want to use a trigger… just a regular backend workflow… All you need to do is schedule it to run on the due date, and have an action to make the relevant changes if it hasn’t been paid… @mikeloc ’s example on your other thread shows you perfectly how to do it…

Changing data dynamically in the database

Need help Database

mikeloc November 24, 2022, 11:48pm 9

Topic		Replies	Views
Change database when condition is true Database	1	454	November 24, 2022
Backend Workflow Recurring vs data trigger Database	5	362	August 9, 2023
Change Status using the Backend Workflow Need help	7	1448	December 15, 2022
Where can I find "Current date/time"? Database	6	2359	November 22, 2022
Backend workflow that runs when date in thing is in the past Questions	6	351	November 18, 2023

Changing data dynamically in the database

Related topics