Tables & Data

Tables & Data help you:

Design an efficient database structure for your application
Store and organize your information in a structured format
Define the types of data you need to track
Create relationships between different pieces of information

Tables & Data

Tables are the containers that hold your records (individual entries) and fields (data categories). In a table, each row is a record and each column is a field. Together, they form the data that powers your application.

For example, you might have tables for:

Customers (with fields for name, email, and phone)
Orders (with fields for date, total, and status)
Products (with fields for name, price, and inventory)

Tip: Before creating tables, think about how your data naturally organizes itself and what relationships exist between different types of information.

Key Components

Table Management: Learn how to create, organize, and maintain the foundation of your application's data structure
Records : Discover how to add, edit, and organize the individual entries within your tables
Fields: Understand the different types of fields available and how to configure them for your specific needs
Importing: Importing data allows you to quickly add records to your Knack application from spreadsheets and other external sources.
Connections: Create relationships between tables to build a powerful relational database