A data table is a collection of related data arranged in rows and columns. Each row holds one record, and each column holds one detail of that record.
- Data tables help you store, view, and manage data in an organized way. You can apply natural sorting for easy searching of data in views and reports.
Data in a data table can be stored in two ways:
- Manually enter data in the data table. Learn more
- Use applications to insert data using:
You can create a data table in three ways:
- From Scratch
- From Excel
- From External Database
- Data Table Indexes: To optimize the data search. Learn more
- Connected Records (Relational Database): Link one table to another using foreign keys. Learn more
- ER Diagram View: View all your data tables visually in an Entity-Relationship (ER) diagram. Learn more
- Data Sync: Import and update data from external databases or APIs at scheduled intervals. Learn more
Each data table contains sensitive information. Giving access to everyone can lead to errors or data breaches. The Data Admin role controls this access in Quixy. A Data Admin decides who can view, add, edit, or delete records in a data table. Only users with this role can manage data in the assigned sandbox stage. Learn more about Data Admin