Database Structure - is it just me or?…

[daniel30]

Hi bubblers (love saying that), your daily noob here

So - here it is…I don’t think it’s bubble, I think it’s me.

I am working on a trip planning/management application. In each of these boxes information relative to the trip is stored. For example on day 1, we will have the activities that the user has planned for those days).

Easy, right? So here’s the problem…

The user should be able to transition between different trips that they may be planning and the information within the tiles should change relative to the trip that they have selected (are inside).

———

How have I set it up?

• The user lands on this page and all the tiles are blank - ready to be filled in. (Some tiles are edited on the outside such as the calendar dates, when a user clicks on a day - a pop up group appears with the information)

What should happen?

• After editing when the user is ready she can hit save using the button below.
• When they hit save it is saved in a DB Type named “Trips”. In this one data type, all the data input by the user can and should be stored relative to the trip.

My challenge is getting the information that is saved correctly so that I can call it back out later when the user reopens a certain trip. As seen in the section on the left.

The user will also need to be able to edit this trip - so I made an update button for this.

---

This saving system is not repeat group friendly.

I cannot call the data correctly. This is the page loaded in preview, the RG displays blank information for each activity and also shows all the activities in the database, not just the trip the user is in.

Here’s how I am calling it in the RG.

Here is a screenshot of the data base with some random testing data. (I haven’t modified it to show all the elements).

———

How do I get this to tie altogether neatly?

Ask me questions if anything is unclear!

[equibodyapp]

How is the page searching for trips?

[veronica.kornilova1]

Hey Guys!

If you’re looking for useful info for planning the database, let me suggest you visiting Zero Code Series 1.4, where experts in Bubble app development will discuss details of planning and building a fast and effective database in no-code. The event is free, all the details you can find at its page: Zero Code Series 1.4 Tickets, Thu, Oct 7, 2021 at 10:00 AM | Eventbrite.

And here is the direct details for joining: Launch Meeting - Zoom

Meeting ID: 861 3419 2597
Passcode: 836746

You will have a possibility to receive a reply to all your questions from the Bubble development experts Petter Amlie, the author of “The Ultimate Guide to Bubble Performance” and Founder of Amlie Solutions. and Vlad Larin, co-founder of Zeroqode . Please drop us a line in case any questions arise and waiting you on the event

Best regards,

Veronica Kornilova
Marketing Manager @ Zeroqode
#1 Bubble Publisher and Developer

100+ Bubble Templates
25+ Bubble Courses
250+ Bubble Plugins
20+ Bubble Building Blocks
Convert Web to iOS & Android
No-code Development Services
Zero Code Conference Replay - watch all the no-code industry leaders share their expertise

[daniel30]

When a page is saved, a link is created where the trip data is then stored,

When this page is loaded (link opened) , the data belonging to that trip should be called and displayed in the tiles.

This is working for like the calendar functionality - everything else not so much

[equibodyapp]

Have a look at your privacy rules on the datatype/s.

[daniel30]

All data types in use set to publicly visible for the moment

[equibodyapp]

Looks like the something is not linking with the correct record in the database - but I can’t see how all your elements and database is set up.

But I’d say go through one by one and make sure it’s all connected

[daniel30]

Couldn’t find it - so I am going to create separate pages for each of the trip walls and store the data entered by the user in each page. So this way each element in each page will have it’s own DB type - to avoid the calling issues.

Quick question - I want each user to have this set up be blank (like I dont want to make a trip and then everyone on the platform can see it).

Is this a privacy settings issue or is there another way to make sure that it’s all happening on a user to user basis.

[equibodyapp]

If I’m understanding you properly - are you thinking of making a separate page for each separate trip row in your database? If that’s what you mean…then don’t do that That’s definitely not the way to go.

Bubble works in a way that you make ONE page or ONE element to show a thing (datatype) and then you use dynamic expressions to display the correct row (or list of rows if that’s what you want) of data at the appropriate time.

What I’d suggest is having a look at the Bubble lessons and if you need more help then doing the bootcamps or 1:1 coaching. This is really going to give you a solid foundation for how to use Bubble to its full capacity and get you much further along in your development journey

In regards to not letting the wrong eyes view the wrong data - it’s usually through a combination of privacy settings and the dynamic expressions that are built in to the elements depending on how the element calls the data.

[daniel30]

I think you may have misunderstood me Let me try and explain better

Currently there is one page - it (should) acts as a template for all possible trips a user might create but also in this page the user should be able to load previous trips that they have created.

I am having issues with the DB structure on that.

Here is my new solution,

Rather than having one page that acts as a template for creating and displaying information for all these different trips.

I will have a separate page for each possible trip.

i,e “Empty Trip 1” which has it’s own page with a template and DB setup

• “Empty Trip 2” which has it’s own page with a template and DB setup
  “Empty Trip 3” which has it’s own page with a template and DB setup

The user can then click into empty trip 2 for example and then begin editing - changing the name and content inside the template. Because this is on a separate page and has it’s own DB type and there is no conflict or issues when calling information or saving it

The test version I built of this is working.

This of course does take more time and I probably wont use it at scale - ( for example creating up “Empty Trip 50”).

Test pages work fine so far

---

I am I overlooking an obvious challenge I will run into?

[equibodyapp]

Yeah - that is not the way Bubble is made to work Definitely messy and not scalable.

Get your database structure right and get the searches and conditionals right on your page and you should only need the one page

Have you looked at the Bubble bootcamps or finding a coach? This is a good way to get some help on your specific issue, while teaching you some of the logic that you can carry forward and apply to anything later on

[jared.gibb]

You should only need 1 page for any trip if you set up your data structure appropriately.

You can set a page to be type “trip”. I feel with an hour of coaching you’d be all caught up on this and building a lot more efficiently.

Learn more

Need to have your database located in your region! Tired of struggling with Bubble or API’s? Need a little functionality that’s not available yet thru current market plugins?

Are you ready to step-it-up or speed it along? Need some custom code or a plugin built? Contact me today to learn how to book a 1-on-1 session, get your plugin built, or yet freelance building support!

[daniel30]

@equibodyapp - do you have any coach recommendations please?