Hi guys, I’ve been learning Bubble and would appreciate your help with my question. I’m building an app to help collectors display their digital comics, and I will simplify my question to make it easy. Please excuse the lengthy context.
I have two tables.
A table called comics_all which has columns: comics_name, comics_brand, comics_photo.
A table called comics_background which has columns: comics_brand, brand_background_photo.
My app would allow collectors to choose the comics_name from a SearchBox, then the comics_photo would display as a Photo in a Group. I want to have the group background image to be dynamic based on the brand of the comics.
Let’s say there are hundreds of comics that only belong to 2 comics_brand (Marvel and DC Comics), this is why I am storing the brand_background_photo in a separate table (just 1 photo for Marvel and 1 for DC Comics), instead of individual photos for individual comics, all in the comics_all, which will consume lots of space.
So the flow would be: The user selects a comic from a Search Box, which looks up the comics_name and comics_photo in the comics_all table to display the comics_photo, but I also want to use that input (comics_name) to find the comics_brand and display brand_background_photo as the Dynamic Image of the Group.
What formula should I set for the Dynamic Image section of the group so that it knows "Oh this user selects a Marvel Comic #1 from the comics_all table, which has comics_brand “Marvel”, I should go to the comics_background to find and display the brand_background_photo for comics_brand “Marvel”? Image below for better demonstration. Thank you!
