Create a table in Guided Application Creator

Create a table in Guided Application Creator to customize your application to fit your business needs.

Before you begin

Complete:

1. Create an application record in Guided Application Creator
2. Define roles in Guided Application Creator
3. Select user experiences in Guided Application Creator
4. Designate data tables in Guided Application Creator

Role required: sn_g_app_creator.app_creator or admin

Procedure

1. To select a table creation method, on the screen, select Create table from scratch and then select Continue.

   

2. Add fields to your custom table.
   1. Select + Add a new field.
   2. On the form, fill in the fields.

      Field	Description
      Field Label	Unique label for the field.
      Field Name	Name of the field in the database.
      Field Type	Type of field. For more information on the different field types, see Field types. By default, there are only 18 field types to choose from. You can add a property to include more field types in Guided Application Creator. For more information, see Add field types in Guided Application Creator.
      Display	When used as a reference field, the field is used as the display value for the table. Only one field can be defined as the display value for a table.
      Mandatory	Option to require that the field must contain a value before the record can be saved.

3. Select Continue to define properties and permissions for your custom table.
4. On the form, fill in the fields.

   Field	Description
   Table label	Unique label for the table (such as Laptops or Thin clients). The label appears on list and form views for the table. See Field Labels in Data dictionary tables.
   Table name	Name of the table in the database. The table name is automatically populated based on the table label and the application scope that you defined earlier.
   Make extensible	Option to enable other tables to extend this table. For more information on table extension, see Table extension and classes.
   Auto-number	Option to add a number field to the table and automatically increment the ID numbers as they get added.
   Manage access	User permissions for your application. For each role that you selected earlier, you can give different levels of access. Create Enables users to insert new records (rows) into a table. Read Enables users to display records from a table. Write Enables users to update records in a table. Delete Enables users to remove records from a table or drop a table.

5. Select Continue.
6. On the confirmation screen, select Continue.
7. To add more tables to your application, follow the steps in Designate data tables in Guided Application Creator.
8. To finish designating tables, select Done with tables.

What to do next

Continue building your application by following the steps in Customize user experiences in Guided Application Creator. If you exit Guided Application Creator, the tables that you configured are not saved to the system.