Create a Database
Create a database to power your application.
A database is like the brain of your app. It keeps everything organized behind the scenes so your users see the right things at the right time. If you're building something like a client portal, job board, or inventory tracker, you’ll need an easy way to store and manage your data—that’s where your database comes in.
Why do you need a database?
Imagine your app is a filing cabinet. Without folders and labels, it would be chaos. A database works the same way—it helps you store your information in a clear, structured way.
Here’s why it matters:
- Keeps things organized: You can track people, products, tasks—whatever your app needs.
- Shows the right info to the right user: For example, a client only sees their own projects.
- Updates automatically: When someone adds or changes something, your app reflects it right away.
Starting with a database helps you figure out what kinds of information your app needs, how different pieces connect, and how they’ll change over time.
Databases: Tables, Records, and Fields
Databases are actually pretty simple once you break them down:
- Tables: Think of these as folders. Each table holds a group of similar items, like a list of customers or products.
- Records: These are individual items in your table. One customer = one record.
- Fields: These are details about each item. A customer might have a name, email, and company name.
You can mix and match different types of fields—like text, numbers, dates, and even images—to match your app’s needs.
Linked (Related) Records
Let’s say you have two tables for your business:
- One lists your customers
- The other lists the items they’ve purchased
Now you want to know:
👉 Which customers bought which items?
👉 And which items were purchased by which customers?
That’s where linked records (also called relational databases) come in. They let your tables talk to each other so you can connect the dots without copying and pasting the same info everywhere.
Instead of managing scattered bits of data, linked records help you build a clear, connected view of your work. For example:
- On a customer’s profile, you can instantly see all their past purchases
- On a product’s record, you can check who’s bought it and when
Learn more about linked records and tables here.
Client Portal Database Example
Here is an example of a database structure for the Client Portal. This setup lets each client log in and see only their own projects and files.
Tables:
- Clients:
- Fields: Name, Email, Company, Projects (Linked record to Projects table)
- Projects:
- Fields: Project name, Status, Deadline, Client (linked to Clients table)
- Files:
- Fields: Name, File upload, Description, Projects (linked to Projects table)
If you have not created a structured database yet, we recommend first defining the database structure before you start building it, so you can consider what information you want to display to your users and what tables and fields you will need.
What data sources should you use for your apps?
You can set up your database in different ways depending on what works best for you:
- Softr Databases: Easy to use, built right into your app, and great for performance.
- External data sources: Already using tools like Airtable, Google Sheets, monday.com, or Notion? You can connect those to Softr apps right away. Explore available data sources here.
- Multiple sources: You don’t have to restrict yourself to one Database; you can connect Softr blocks to different data sources that can help bring different data into one place.
Tip: If you want to streamline your app and data storage in one tool, you can import your data into Softr Databases and store it all in one place. We currently support CSV import, Airtable import, and more coming soon.
Last updated on June 17, 2025