I’ve been struggling with the database, specifically linking data types/tables. Were it not for some spectacularly kind people on here taking the time to guide me, I’d probably have given up so I’m indebted to those who’ve helped me. Thank you all.
I think I’ve now managed to get my head round the concept of the database and how it works with my app and wondered if anyone could support or correct my thinking . Once I’ve got this sussed, I feel I’ll finally be on my way.
My thinking is that Bubble is building apps that contain data and not for building databases (I know that sounds obvious but stick with me) so I can pretty much forget about 0ne to Many and One to One relationships with inner and outer joins etc because Bubble’s simpler than that. To link two “tables” (ie data types) I just put in a field in one table and set that field’s data type to be the name of the table (data type) I want to link it to. I don’t even have to put any data in that field. It acts as an informational pathway along which Bubble can move data between tables. In order to pull data across this pathway I use “apostrophe language” in dynamic expressions in an element’s properties on pages such as “Value” = “Current User’s” “FirstName” or “Do A Search For” “Product’s” “Price” etc (if I have a Price field in a Product’s table). That’s how I push data to a table and pull it from another one. Obviously there are lots more expressions I can use but I’m new to this and haven’t learn them yet.
Does my thinking about this make sense? Have I missed anything or am I barking up the wrong tree completely? I’d love it if someone who knows can add their experience and I appreciate that this is very generalised thinking but, for my tiny brain at least, it’d give me confidence if I’m on the right lines.
As ever, thank you so much for reading this far.