Extend a table in Guided Application Creator

Extend a table in Guided Application Creator to create a custom table that copies an existing table. You can add more fields to your child table.

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

Plan which table to extend. Review the extension model so that you can track which database tables are created after you extend your table.

Role required: sn_g_app_creator.app_creator or admin

Procedure

1. To select a table creation method, on the screen, select Extend a table.

   

2. In the Table field, select a table to extend.
3. Select Continue.

   The fields from the parent table are copied over to your custom table. You can't change the copied fields.

4. To add a field to your child table, select + Add a new field and then 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. Note: Extended tables inherit the display value of the parent table. Setting a separate display value for the extended table overrides the parent table's display value.
   Mandatory	Requires that the field must contain a value before the record can be saved.

5. Select Continue to define properties and permissions for your custom table.
6. 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.

7. Select Continue.
8. On the confirmation screen, select Continue.
9. To add more tables to your application, follow the steps in Designate data tables in Guided Application Creator.
10. 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.