Create a Form-Based App with a Database Table (Classic)

To create a form-based app that uses a database table as its data source in the Classic Add an App experience, do the procedure in this topic.

Prerequisites

Good to Know

  • AgilePoint does not support non-English characters in database table column names. These characters are supported:
    • Alphanumeric
    • Underscore
    • Space
  • This procedure creates a new form-based app with these components:
    • A Create form where a runtime app user can enter data. This form is the main UI for the app.
    • An Update form where specific users can change the data that was entered on a Create form.
    • A View form that shows a list view of the data from all instances the Create and Update forms for your app.
    • A View form that shows a list view of the data from all instances the Create form that have been recently submitted for your app.
    • A View form that shows a list view of the data from all instances the Update form that have been recently submitted for your app.
  • The form name is based on your database table name.

    Format:

    • New [Database Table Name]
    • Update [Database Table Name]
    • All [Database Table Name, Plural]
    • Recently Created [Database Table Name, Plural]
    • Recently Modified [Database Table Name, Plural]

    Example:

    • New Customer
    • Update Customer
    • All Customers
    • Recently Created Customers
    • Recently Modified Customers
  • The Oracle database creates only 1 view with the name in the format All [Database Table Name, Plural]. The Recently Created and Recently Modified views will not be created for Oracle database.
  • By default, the runtime app user can change the form, but you can set the app permissions to configure which AgilePoint NX users can create or update form data.

    For more information, refer to How Do I Use Application Level Permissions?

  • After you create a form-based app, you cannot change the app to use a different data source. For example, you can not change a form-based app to use a different entity or SharePoint list than the one specified when the app was created. This limitation also applies to cloned apps. That is, you cannot clone a form-based app, and then change the data source in the cloned app.

How to Start

  1. Click App Builder.

    Build Apps screen
  2. On the App Explorer screen, click Add App.

    Add App button

Procedure

  1. On the App Type screen, select Form-Based App.


  2. Click Next.
  3. On the New App screen, complete these fields:


    Field NameDefinition

    App Name
    Function:
    Specifies a name for your app.
    Accepted Values:
    One line of text that can have spaces.
    Default Value:
    None
    Example:
    Refer to:

    Language
    Function:
    Specifies the language for your app.
    Accepted Values:
    A language from the list.
    Default Value:
    None
    Accepts Process Data Variables:
    No
    Example:
    Refer to:

    Category
    Function:
    Specifies a category for your app.
    Accepted Values:
    A category from the list.

    The category list comes from Tenant Settings > Categories tab.

    Default Value:
    None
    Limitations:

    This field is available in these releases:

    App Description
    Function:
    An optional description for your app.
    Accepted Values:
    More than one line of text.
    Default Value:
    None
    Example:
    Refer to:

    Choose Theme
    Opens this Screen:
    Choose Process Model Theme
    Function of this Screen:
    Specifies a process theme.
  4. Click Next.
  5. On the Select Primary Data Source screen, select Database Database icon.


  6. Click Next.
  7. On the Database Configuration screen, click the Configuration tab.


  8. On the Configuration tab, in the Data Source Name field, enter the name for your database repository.
  9. In the Database list, select your database access token.

    To create a new access token, click Create Add Token icon. For more information, refer to Access Token for Database.

  10. In the Schema Name list, select a schema associated with the specified database.
  11. In the Primary Entity Name list, select a database table that you want your form to collect data.
  12. Click the Fields tab.


  13. On the Fields tab, select the database columns you want your form to contain.
  14. Click the Related Entity tab.
    Note: The word entity on this screen refers to a container within your data model. For Data Entities or Salesforce, this container is called an entity. For a database, entity refers to a database table. For SharePoint Integration, entity refers to a SharePoint list. For Microsoft Excel, entity refers to an Excel table.


  15. On the Related Entity tab, select the related database table to use in your form.
  16. Click Finish.
  17. On the eForm Builder screen, configure your form as necessary.

    For more information, refer to eForm Builder.