Is there a Way to Update Lists Quickly?

Need help Database
1

Hello Everyone!

I have Items in a database (we’ll call it “T1”) with information in a Column (we’ll call it “C1”). This column needs to update other items (we’ll call them “T1a”,“T1b”,“T1c”,etc ) that are attached to T1.

Now I can make a change to T1 in C1 with one workflow and then have it make a change to “a list of things” which will get and update “T1a”,“T1b”,“T1c” which can be done frontend/backend with an API . However, I’m wondering if there is a way to link the data. So that “T1a”,“T1b”,“T1c” automatically watch what happens to T1’s C1. So when T1 is updated it automatically updates “T1a”,“T1b”,“T1c” without the need to make a change to a list of things which requires a 5 second delay in between each item. This delay isn’t bad if you have a few items but when that is a massive list it can become very time consuming for the user in the end. Especially if the user has to wait for the workflow to finish. I am aware that API workflows don’t require the user to wait till it’s done in order for them to do other operations however with my particular case the workflow needs to finish quickly so that other functions can perform properly.

So in summary. Is there a way to create a “webhook” like function to allow “T1a”,“T1b”,“T1c” to watch the item it’s attached to and update automatically without a workflow that has a delay on a list of items?

2

Not sure if this will make it fast enough for your use case, but you can try to make changes using the Bubble Data API and see if that’s any faster.

Automatically detecting when another data type is changed would be difficult, If there is just 1 or 2 rows in the database that you’ll need to be checking, and a similarly small number of columns to check, it could work.