Creating Forms Using View

View Definition Type creates new forms based on Database views. You can also download the Database data in CSV format.
  1. Select View Option in Create New Form Definition pane.
  2. Enter the following details:

    Table 9-6 Field Description

    Field Description
    Code The application generates a unique value for Form Code and does not require any input.
    Name Enter the name of the form in Form Name. You can enter between 3 to 100 characters. Only alphabets, numbers, spaces, and underscores are allowed.
    Description The Form Definition description. You can enter between 3 to 100 characters. Only alphabets, numbers, spaces, and underscores are allowed.
    Created By The username of the logged in User who created the form.
  3. Click Apply.
    The View Selection tab is displayed.
  4. Click Apply.
    The Attribute Selection Tab is displayed.
  5. Click the drop-down arrow in the View Name field.

    The source attributes from the table and the mapped attributes from the Excel file are displayed. If the selected table has Child tables, the Child tables that you select from the Mapped Entities tab are also displayed in the Attributes tab.

  6. Click the check-box next to an Attribute Name , to include the Attribute in the Form definition.

    To remove the attribute from the form definition, uncheck the selection.

  7. Click Filter to apply filters to the form definition.
  8. Click Apply.
    The Data Preview Tab is displayed. You can view the sample form based on the selected view, attributes and filter conditions.
  9. Click Download CSV to download the preview data.
  10. Click Save as Draft if you want to save the Forms Definition in draft format.
  11. Click Submit if you want to submit the Forms Definition for approval.