Turn your spreadsheet into a custom table in Guided Application Creator to store data for your custom application.

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

Review the spreadsheet guidelines to ensure that your data uploads as expected.

Role required: sn_g_app_creator.app_creator or admin

Procedure

  1. To select a table creation method, on the screen, select Upload spreadsheet and then select Continue.
    Table creation options
  2. Upload your spreadsheet.

    You can drag and drop the spreadsheet file or browse your system to select the spreadsheet file.

  3. In Enter a row for the table header, enter the number of the header row on your spreadsheet.

    For example, if your spreadsheet has two columns in which the headers are in the second row (such as in the following image), you would enter 2.

    Spreadsheet with horizontal columns and a header label for each
  4. Select the Import spreadsheet data option.
  5. Select Continue.

    Your spreadsheet content is parsed into fields for your custom table.

  6. 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 Requires that the field must contain a value before the record can be saved.
  7. Select Continue to define properties and permissions for your custom table.
  8. 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 select to give your 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.
  9. Select Continue.
  10. On the confirmation screen, select Continue.
  11. To add more tables to your application, follow the steps in Designate data tables in Guided Application Creator.
  12. 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.