On the Kuika platform, you can quickly create your data tables with the help of Kuika AI. Kuika AI speeds up the table design process by suggesting the appropriate data type based on the column name you enter.

In this tutorial, you’ll learn how to create a data table using Kuika AI in the Datasources module.

Steps for Creating a Table

1. Log in to the Kuika platform and open the project you’ll be working on from the Apps screen.
2. Click the Datasources icon on the top navigation bar.
3. Expand the Managed DB heading in the left panel, click the + icon next to the Tables heading, and select New Table from the dropdown menu.
4. The table screen opens with a default name (e.g., Table2). Enter the name of your table in the field at the top left and confirm with the ✓ icon.

By default, the new table starts with an Id column of type Guid, marked as the primary key (PK).

1. In the Enter column name field in the last row of the table, type the column name.
2. Select the column’s data type from the Choose type list or get a suggestion from Kuika AI. (See “Using Kuika AI to Determine Data Types”)
3. If necessary, define the column’s other properties:
   
   • Size: Maximum length for types such as text. Use MAX to define an unlimited length.
   • Scale: Number of decimal places for decimal types
   • Required: Whether the field is required
   • Unique: Whether the value must be unique
   • Default: Default value
4. A new blank row is automatically added below each column as it is added.
5. After adding all columns, click the CREATE button in the upper-right corner to create the table.

If you want the table to be usable on mobile devices even without an internet connection, you can use the WORK OFFLINE toggle next to the CREATE button. See the Offline Table Usage section for details.

Data Type Determination with Kuika AI

After entering the column name, click the Kuika AI (✦) button next to the Type field. Kuika AI analyzes the column name and suggests an appropriate data type. 

Examples:

• EmployeeName: Kuika AI suggests the String data type.
• BirthDate: Kuika AI suggests a data type that includes a date (e.g., DateTimeOffset).

Check the suggested type before accepting it; if necessary, you can select a different type from the Choose type list.

Table Update Process

• You cannot directly update columns in an existing table.
• If you want to change a column’s name or data type:
  
  1. Delete the relevant column.
  2. Recreate the column using the new name or data type.

By following these steps, you can create data tables quickly and accurately with Kuika AI’s support.