Greetings,
Am new to no-code/bubble.io and decided to start a project to get to grips with how things work.
I am making a gig tracker i.e get alerts when a band is touring near you sort of thing.
I have a workflow to create a new band where details of the band are input (i.e band name, genre, bio) the details of which are saved to “Band” database.
I then have a workflow to create tours for that band (country, city, venue etc) which are saved to “Tours” database.
I also have a workflow to edit details about a band (i.e maybe they change their name, alterations to their bio etc). When the edit button is clicked, a pop-up is shown whereby the user can modify the details of the band accordingly. I have the workflow set up and functioning in so much as it updates all the modified information.
However, if the band name changes, then if I use the function to view tours for that band, nothing shows up, because the Tour database is unaware of the name change and thus lists nothing for them under their new name.
My edit-band popup has “band” type content sent to it, and the relevant data pushed to it via workflows. So it seems I cannot simultaneously push tour data to it as well to then figure out a way to also change the name of the band in the tour database when it is changed in the band database.
I’ve stared at the screen for a few hours to try and figure out how to solve this but not coming up with ideas. I’m wondering if the way I have structured the system is fundamentally flawed and needs redesigning, which would be a shame since I’ve put quite a lot of work in to make everything function as it does and I’m happy with how its progressed so far.
But if there’s a way to make it such that when I save changes in the edit-band pop-up, I can subsequently make the change to the band name in the Tour database such that it retains all the other information about the tour, then any ideas on how to do so would be greatly appreciated.
Thanks.