How to create a Data Table
  • 01 Dec 2022
  • 2 Minutes to read
  • Contributors

How to create a Data Table


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

ProsCons
The global data table can be used in any workspaceOnce a data table is created as global, in future it cannot be confined to a specific workspace.
 
  • 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.

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.
  • Click Save.
  • The platform will ask your permission to create Basic CRUD Functions.

  • 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.

 





Was this article helpful?