Manual Database Population

Accessing Your App's Data

First, you need to know where your data lives. In the Bubble editor, all of your application's data is managed in the Data tab. Within this tab, there are several sub-sections. The ones you've worked with are Data types and Option sets. Now, we'll focus on App data.

The App data section is where you can view, create, and modify the actual records—or "things"—in your database.

Creating Your First Tool

With your data structure defined, creating a new entry is straightforward. You will navigate to the App data tab, select the Tool data type, and create your first "thing." Let's create an entry for a "Word and Character Counter" tool.

The process involves clicking a button to open a form where you'll fill in the fields you defined in the previous lessons.

Now, follow these steps in your Bubble editor:

1. Go to the Data tab and click the App data sub-tab.
2. In the list of views on the left, you should see all your data types. Click on All Tools (or whatever the default view for your Tool type is). The main area will likely say "No entries found" for now.
3. Click the New entry button. A popup will appear.
4. Fill in the fields for your first tool:
   • Name (text): Word and Character Counter
   • Description (text): A simple tool to count the words and characters in a block of text.
   • Icon (image): You can leave this blank for now. We will handle images later.
   • Category (Category): Click the dropdown. You should see the list of categories you created in your Category Option Set. Select the most appropriate one, like Text Tools.
5. Click Create.

You have just created your first record in the database! You should now see one row in your All Tools view.

Making Linked Data Readable

After creating the entry, look at the Category column. You might see the category name you chose, like Text Tools. However, sometimes Bubble will instead display a long, seemingly random string of text. This is the unique ID for that option. It’s how Bubble identifies things internally.

To ensure Bubble always shows a human-readable value, we need to confirm the primary field is set correctly. For an Option Set, this is the Display value by default, which is what we want. For custom data types, this step is essential.

The following video demonstrates this exact scenario. The creator is trying to link an author to a book and initially only sees the author's unique ID. Watch how they solve it by setting a primary field.

Since you're using an Option Set for categories, Bubble is usually smart enough to use the Display text automatically. But knowing about Primary Fields is a critical skill that will save you a lot of confusion as your app grows more complex.

Practice: Build Your Tool Inventory

Now it's your turn to populate the database. A single tool isn't enough to build and test a gallery page, so your task is to create at least three more sample tools. This will give you a good variety of data to work with in our next lessons.

Follow the same process as above to create these new entries. Here are some ideas relevant to your multitool platform goal:

• Tool 2:
  • Name: Case Converter
  • Description: Convert text between UPPERCASE, lowercase, and Title Case.
  • Category: Text Tools
• Tool 3:
  • Name: HEX to RGB Converter
  • Description: Instantly convert color codes from hexadecimal (HEX) to RGB format.
  • Category: Converters or Image Tools
• Tool 4:
  • Name: Simple Loan Calculator
  • Description: Calculate monthly payments for a simple fixed-rate loan.
  • Category: Calculators

Feel free to come up with your own ideas! The goal is to have a small collection of tools spread across different categories.

A Note on Scaling Up: Bulk Uploads

Manually entering data is perfect for getting started and for testing. However, once your app is live, you might want to add dozens of tools at once. For that, Bubble has a CSV upload feature.

It's a powerful tool, but it's best avoided for now. It's very common to find small issues with your initial database structure once you start building. Manually creating a few records, as you've just done, is the best way to spot these "holes" early. Deleting and recreating a handful of test records is easy; doing so for a CSV import of 1,000 records is not.

This advice is echoed by experienced Bubble developers.

Conclusion

You've successfully transitioned from designing the blueprint of your database to adding the first pieces of furniture. This is a significant step from abstract structure to concrete data.

Here are your key takeaways from this lesson:

• You can now navigate to the App data tab to manage your application's records.
• You have learned the hands-on process of creating new entries (or "things") in your database.
• You populated various field types, including text fields and, crucially, the link to your Category Option Set.
• You understand the role of Primary Fields in ensuring linked data is displayed in a human-readable format.
• You have created a small but functional dataset of sample tools that will power the next stage of development.

In our next lesson, we will finally move from the backend to the frontend. With data now in your database, you'll build a homepage layout that dynamically displays your tool categories using one of Bubble's most powerful elements: the Repeating Group.