Pulling data from one type to another (VLOOKUP like)

caioamelo · 2024-10-14T02:05:36.285Z

I have two Data types: “Electricity Companies” and “Electricity Plans” types which have a common field “Company Name”. I have uploaded JPEG logos to a list of around 50 under a “logo” field. I have around 1500 Electricity plans which I need to distribute these logos to each one, matching the “Company Name”. What is the most efficient way of doing this? I’m noob to Bubble io and I’m spending a LOT of time trying to figure out things that I was able to do almost instantly with excel … Any help would be greatly appreciated!!!

siddharth · 2024-10-14T06:54:26.791Z

Instead of distributing the logos to each plans, you can reference the logo according to company name, this way you will save save your database space.
Well to refrence it you need to say how will you exactly use it.
For eg, if a user login and go to his plan you can show his bill with logo, referenced to the company and so on

caioamelo · 2024-10-14T14:02:06.036Z

I can make that work for 1 instance, but the issue is that I’m using a repeating group for each Plan, where I want the repeating group to pull information from my “Electricity Plans” type in some locations and “Electricity Companies” types on other locations. I need each Plan to show the correct logo and rating based on the “Electricity Companies” data, while the repeating group is setup to pull data from “Electricity Plans” type - See snip below.

Screenshot 2024-10-14 0900201237×607 88.7 KB