Tables & Data

Tables are the foundation of your Knack application's data structure. Understanding how to effectively structure and manage your data will help you build powerful, efficient applications. You'll discover how to create and organize tables, manage records, define fields, and establish connections between different types of information.

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