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.
    Table creation options
  2. Add fields to your custom table.
    1. Select + Add a new field.
    2. On the form, fill in the fields.
      FieldDescription
      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.
    FieldDescription
    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.