Forum Academy Marketplace Showcase Pricing Features

Database structures (types and fields)

Hi,

I have some knowledge of SQL databases and I know how I would do this using that. I would like to know what is the most efficient and easiest way to do this on bubble.

Example:

  • Table 1: I have a table with country, population and tax rate.
  • Table 2: I have a table with country, property-name and rent.

User selects country in form number 1 (Table 1) and on the next page I want to show all the properties and the corresponding rent for the property (Table 2) based on the country that the user has selected on the previous page.

One way I could do it is to send the country data from the first page to the second one. And then on the 2nd page make a repeating group with dynamic data where it shows property-name and rent if the value of country in table 1 = value of country in table 2.

That’s pretty much exactly how I would do it. Just make sure you send a parameter so that table 2 on page 2 knows what value the user is interested in from table 1 on page 1.

Another way is to set the 2nd page data type to “country” - this depends on you having a data type country - and sending the country as data when the page navigates (rather than a parameter). Then anything on that page references the country - you may be able to get more flexibility that way depending on your page structure and whatever other data you plan on displaying.

1 Like

@romanmg thanks!

So I did that and on the search results page, the text fields return without problems however for some reason the images don’t appear.

Can someone have a look here:

The types are locations & apartments.

Can you try re-uploading your images in the database? All but 1 look corrupted and all but 1 (Berlin - Big One) display. Your setup looks right.

Yeh I reuploaded images and it works. But when I use the previous 3 they still do not work. Weird.

Thanks for taking a look into it @romanmg !

1 Like