I am struggling to figure out how to relate two tables of data (pardon my terminology, have not quite learned the Bubble lingo works when it comes to data). I am basically trying to relate and report on two levels of data. One table will contain Projects and another Time Slip (hours logged working …

Can you recreate (or copy/paste) it in the forum app. [image] Bubble Editor - Forum_app Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications. …

I think there are two different ways you could accomplish. Create relational database with primary/foreign keys that are maintained through workflow Create a list field in your Projects data type 2.1 Create Project data type 2.2 Create Time Slip data type 2.3 Create new field in Project dat…

I may need to read up elsewhere about the primary/foreign key method…but that may be an option I went back and worked the lesson on lists. It was helpful, but I am still fumbling somewhere here. Here is what I did so far: I created the two datatypes: Projects and Time Slips. I added a “Time S…

[image] taylor: I may need to read up elsewhere about the primary/foreign key method I added two fields to my Time Slips data type: Project Number (to tie to specific project) Fundamentally, this is the bit that makes Bubble (and others) a bit different to a traditional relational DB. You do…

very good explanation Nigel. Thank you! But one question maybe: Lets say I have a thing called Project with a lot of text fields, picture fields, etc. I could now (for example) create 10 fields for pictures under the thing Project (Image1, Image2, Image3, etc) OR I could create the thing Pro…

NigelG and Kfawcett… thank you for your explanations. It is very helpful and gets me back on track.

Actually one more question: What if I have existing data (CSV file) that I need to import. Is there a way to import the CSV of the timeslips in so that they are included in both the timeslips and Projects data type? Do I need to upload it to the Timeslips data set first and then run something withi…

Thank you for nice example. now it s clear to me also :slight_smile:

Yes, that is still the way to do it. Upload the Projects. Upload the timeslips, linking them to projects by matching on a field. Then run a Bulk API. The issue I had with the Bulk API timing out is now fixed. It is slow at scale, but works.

Understanding Relational Database Nature of Bubble

Need help

taylor July 30, 2016, 3:50pm 9

Got it to work. Found this post in the forum that answered it pretty well.

Imported data into linked tables?

Topic		Replies	Views
Relational Database Questions	13	4418	September 4, 2019
Are many-to-many relations supported? Database	26	10486	July 10, 2021
Connecting two dynamic "Things"? Database	3	2967	February 10, 2021
Struggling to understand some things Database	2	359	February 14, 2023
Thoughts...Understanding the concept of the database in Bubble Database	8	1514	November 14, 2022

Understanding Relational Database Nature of Bubble

Related topics