Forum Academy Marketplace Showcase Pricing Features

Change database when condition is true

Hello friends, I need some help!

I don’t know how to make the bubble modify the database automatically when a condition is true, in my case, I’m developing a system that identifies when a charge is up to date or overdue, when it’s overdue, the status is changed to "overdue " automatically, I created a trigger but it only works at the time of registration, what am I missing?

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 example that should help you get down a good path.

Create a backend workflow that looks something like this…

The backend workflow will have an action that looks something like this…

Note that I have a status field on the Invoice data type, and that field is linked to an option set that defines the different statuses for an invoice. Also note that we are only setting an invoice’s status to overdue if the invoice is not marked as paid.

Finally, when an invoice is created, have the last step in the workflow schedule the backend workflow like this…

Hope this helps.

Best…
Mike