Grab dynamic image from a table B based on input from table A

willmai · 2024-08-22T04:00:43.334Z

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!

Website1545×2000 364 KB

msgiblin · 2024-08-22T04:23:05.201Z

If the Comic Brand field on the comics_all" datatype is of type “comics_background”, you’d be able to set that image to This comics_all’s Comic Brand’s Brand Background Photo.

build.marshall · 2024-08-22T06:37:47.850Z

Hope this helps, any questions please let me know:

willmai · 2024-08-22T13:01:07.813Z

Thank you very much, this solution works too! I really appreciate it.

willmai · 2024-08-22T13:01:29.165Z

Thank you very much, you are a legend! This works for me.

build.marshall · 2024-08-22T20:24:07.809Z

No problem, happy to help

system · 2024-10-31T04:00:57.110Z

This topic was automatically closed after 70 days. New replies are no longer allowed.