MySQL database not updating on bubble

Need help Database
1

Hello, would love some help on this.

I am trying to create a system where I have a yes/no data column in MySQL that responds to an element in Bubble. So when the value is ‘No’ the element is hidden, and when the value is ‘Yes’ the element is visible.

The part I am having an issue with is where bubble does not automatically take the updated value of the MySQL database. Instead, I have to refresh the page for it to recognize that I changed the value from No to Yes.

Is there a way around this? I’d love for there to be a way for bubble to read the updated values in the database without needing to refresh the page for it to take effect.

Thank you in advance for any information! :slight_smile:

2

There are two well-established methodologies to solve this problem. First, you could “poll” the database (run a workflow every X seconds) to check for an update and then refresh based on the value returned. Or, you could fire a trigger event from your mysql database to hit an API/endpoint within your Bubble app (“push” update).

One of these two methods will be your best option for solving the problem as stated.