1. Help Center
  2. Database
  3. Create a data table and load data into the data table

How to create a data table

An overview on how to create a data table and different ways to create it.

There are 2 different ways to create a data table.

  1. Create from Scratch
  2. Create using Excel

Create a Data Table from Scratch 

  • On Quixy dashboard page, click Admin Menu> Database > Create Data Table.

  • Select Create from Scratch > Next.

  • On Create Data Table page, give a Name to the data table and select a Workspace.

Note: If you do not select a workspace when creating a data table, the data table will save as a Global Data table and can be used in multiple workspaces, i.e., you can store data of apps from different workspaces or fetch data from the global data table in any app from different workspaces.

A global data table has its Pros and Cons

Pros Cons
The global data table can be used in any workspace Once a data table is created as global, in future it cannot be confined to a specific workspace.
  You cannot create data source using global data table
  • Select Key Type.
1. Primary Key: 
    • A primary key is a special relational database table column designated to uniquely identify all table records.
    • A primary key’s main features are:
      • It must contain a unique value for each row of data.
      • It cannot contain null values.
    • A primary key is either an existing table column or a column that is specifically generated by the database according to a defined sequence.
    • For example: students are routinely assigned unique identification (ID) numbers, and all adults receive government-assigned and uniquely-identifiable Social Security numbers.

    2. Composite Key: A composite key is a candidate key that consists of two or more attributes (table columns) that together uniquely identify an entity occurrence (table row).

    • Select Key Value.

    • Drag-and-Drop the Element Fields on the left to the data table builder canvas according to your requirement to build the UI of the data table.

    Caution!: If you want to save data from an app in a data table, the Form Element Fields in the app and the Elements Fields in the data table must be the same.

    Tip: Take only the required Fields to create a data table for which you want to store the data. It is not necessary to take all the fields similar to app's to create a data table.

    • If you select NO, the system will save the data table without creating the CRUD Functions.
    • If you select YES, the system will create the CRUD Functions and then save the data table. Further You can edit these functions according to your requirements.

    • You can see the newly created data table in the data table list page.

    There are best practices that you can follow while creating a data table to get yield best results.

    To get a visual understanding on how to create a data table, refer to the video below.

    Create Data Table