Smartoo Databases Overview

Smartoo databases explained

Smartoo Databases are the central memory system for your workspace. They store all the information your apps use, from client lists to project statuses.

Unlike a standalone spreadsheet, these databases are "relational" and workspace-wide. This means you can create a single list of clients and reuse it across five different apps, ensuring your data is always consistent no matter where you view it.

The building blocks of your database

If you have used a spreadsheet before, you already understand the basics. A Smartoo database is built from three main components:

1. Tables

A Table is like a single tab in a spreadsheet. It holds a specific collection of items.

Examples: Projects, Clients, Invoices, Team Members.

2. Records

A Record is a single row in that table. It represents one specific item.

Examples: "Website Redesign Project" or "Client: Acme Corp."

3. Fields

A Field is a column that defines the details you track for each record. Smartoo supports various types, including text, numbers, dates, files, and status dropdowns.

Examples: Due Date, Priority, Email Address, Total Budget.

Connecting your data with relationships

The real power of Smartoo lies in linking tables together. Instead of typing a client's name manually into every project, you create a Relationship.

For example, you can link the Projects table to the Clients table.

• The benefit: When you click on a Client, you can instantly see all their related Projects. If a client changes their phone number, you update it in one place, and it updates everywhere.

Common relationships include:

• One-to-Many: A Project has many Tasks.
• Many-to-Many: A Task can be assigned to multiple Team Members.

How databases power your apps

Your database lives in the Data tab, but your users interact with it through the Apps you build.

When you drag a widget (like a Table or List) onto an app screen, you are displaying live data.

• Real-time sync: If a user updates a task status in the app, the database updates instantly.
• Shared access: Multiple users can view and edit the same data at the same time without conflicts.
• Automation: Workflows and AI Agents can read this data to send notifications, approve requests, or generate reports automatically.

Best practices for data structure

To keep your workspace clean and efficient:

• Define your "nouns" first: Before building screens, list the things you need to track (e.g., "I need a table for Events and a table for Attendees").
• Avoid duplicate entry: If you find yourself typing the same category or customer name repeatedly, turn it into its own table and link it.
• Keep fields practical: Only add fields that answer specific questions, like "Who owns this?" or "Is it done?"

Summary

Think of Smartoo Databases as the foundation of your house. While the "App" is the interface you live in (the walls, windows, and decoration), the Database is the solid structure underneath that holds everything up. By organizing your data into clear tables and connecting them with relationships, you build apps that are powerful, scalable, and easy to maintain.