Navigation:  Enterprise Forms Modules > Form Template Manager >

Form Template Details

Previous pageReturn to chapter overviewNext page

Form Template Details is the main entry point for creating and modifying form templates. The facility allows users with appropriate security access to other sub maintenance screen of the form template.  These include form designer, custom security role designer, states and workflow designer.

There are two types of form templates: Parent and Child template.

A parent form template is a complete form template and can exist in its own.  It contain all the required meta data such as the form layout, custom form roles, security mappings, states and workflow details.

A child form template only contains the form layout and can not be used by itself.  It needs to be associated with a state of the parent form template.  A typical scenario of where a child form template is used is when there is an approval process, in a particular state additional data is required on a separate form for providing feedback and comments etc.

Both parent and child templates are required to go through an approval process before it can be utilized for capturing data.  The approval process is a build-in workflow system in which a form template must go through before it can be used.  This approval process is described in detailed here.

 

FormTemplateDetailsDevNav

Form Template Details navigation bar when template is being locked by the current user

 

FormTemplateDetailsDevNav3

Form Template Details  -  links specific to navigation bar when template is In Development state and Not Locked

 

FormTemplateDetailsDevNav2

Form Template Details - links specific to the navigation bar when template is in Available state

 

Button

Description

Form Designer

Link to the form layout designer for developing form layout

Database Queries

Link to the Database Queries screen for setting up database query tokens for use throughout the form template.  Database query tokens are specialized tokens that represent a call to a stored procedure or group of SQL statements

Access Roles

Link to the Access Mapping and creation screens for custom form roles management

Form States

Link to the Form States page for creating and managing workflow states.  Workflow security access is also managed via this link

Workflow

Link to the Workflow page for managing the complete workflow for the form.  Here you could design your own custom workflow processes as well as defining workflow processing tasks.

Localization

Link to Localization page for managing content localization for static text in Label and HTML field elements

Change State

Link to the Form Template State Management screen for form approving and publishing of the form template

Preview

Link to view the actual form layout when it is being used.

Validate

Link to Validate the form template.  A form template must contain all required properties before it could be published for use.

Instant Publish

Button to instantly publish a form template.  This button is only available when the form template is in Development state and the user has been granted to all 3 template access roles (CREATOR, APPROVER, PUBLISHER)

Instant Development

Button to instantly changes the form template to In Development state.  This button is only available when the form template is Available state and the user has been granted to all 3 template access roles (CREATOR, APPROVER, PUBLISHER)

Manage Archives

Link to the Manage Archives screen for form data archives management

Delete

Button to delete the form template from the system.  This action can not be reversed and will completely remove the form template and associate properties including form data from the system.  This button is only visible to users with Portal Administrator or Super User access only.

 

FormTemplateDetailsMain

Form Template Details main property section

 

Property

Description

Template ID

This is an auto-generate unique ID of the form template.  The ID is automatically generated when the form template is created is used throughout the system.

Type

Field to indicate the template type.  Current support types are

Parent - a complete form template with all required meta data associated
Child - a partial template with on form layout defined.  A child form template can not be used alone and need to associate to a workflow state of a parent form template.

State

Indicates the current state of the form template.  Available states include

In Development - Form template being developed
Pending Approval - Development completed pending approval from an Approver
Pending Publish - Template Approved pending publish from a Publisher
Available - Template available for Use
Archived - Template being archived
Closed - Template closed from further use

Version

Current version of the form template

Name

Name of the form template

Description

More detailed description of the form template

Use Flat Table Structure

Indicates whether to use normalized table for storing form data.  By default this option is selected.  See here for more information on how Enterprise Forms stores data when this property is selected.

Single Submit Per User

Indicates whether the form only a single submission per user.  By default a user can submit as many instances of the form as possible.  When selected, this option restrict registered users from making multiple submissions of the same form template.

When Created

Displays date & time of when the form template was created

Last Updated

Displays date & time of when the form template was last updated.  A change in the form template such as state change, field element modification, workflow state change updates the Last Updated property

Locked By

Displays the Display Name of the user whose have exclusive lock access to the form template

When Locked

Displays the date & time of when the template was locked

Lock

Button to initiate exclusive Lock access to the form template.  In order to edit the form template layout, the user must have exclusive lock access to the form template.  The Lock button is only available when the template is In Development state and is not locked by another user.

Unlock

Button to revoke Lock access from the form template.  The Unlock button is only available when the template is In Development state and is locked by the user.

 

FormTemplateUsageInfo

Section describing the Form Template Usage Information

 

Property

Description

Template Usage Information

This section is only visible when there are instances Enterprise Forms modules referencing the form template.  In addition the section is only visible to users with Admin or Super Users privileges only.

Total Form Submissions

Displays the total count of the number of unique submitted instances

Module Type

The name of Enterprise Forms module instance type.  Instances include Data Collection Manager, Workflow Manager and Report Manager.

Report Name

Name of the Report Instance.  This column is only applicable to Report Manager module type

Module Name

Name/Title of the actual module being referenced

Page Name

This is the name of the Portal page where the module instance resides.  Upon clicking on the provided link the system will open the page in a new window/tab in the browser for preview.

View Access Log

The link takes to a View Access Log screen to view all the available access log entries available for the selected module instance.

 

FormTemplateDetailsHistory

Form Template Details changes history section

 

Property

Description

Date Modified

Date of when change was made.  A change that incur a history record include

Lock or Unlock of the form template
Change in form template state
Version rollback

Modified By

Name of user triggered the change

Template State

State at which the change was made

Description

Description of the change

Version

Version of the template when the change was made.

Records Per Page

The number of records to display per page

 

 

Functionalities available from Form Template Details screen

Create/Edit Form Template Details

Create/Edit Form Layout

Create/Assign Custom Form Template roles

Create/Edit States

Create/Edit Workflow

Localize Form Fields (optional)

Preview the Form Template

Validate the Form Template

Publish the Form Template

 

Other optional functionalities available within this screen

Lock/Unlock for exclusive editing

Preview previous Form Template version

Rollback to previous Form Template version

Delete Form Template

Modify Sort Order for Change History List

Modify Paging Size for Change History List

Navigate between pages in Change History List

 

Create/Edit Form Template Details

Select an item from the Create From Template property option if required to create the new form template from an existing form template.  If this option is selected everything associated with the selected form template (state, workflow, security settings) will be copied to the new form template.

Select the Form Template Type from the Type field.  There are two possible Form Template types, Parent and Child

Provide a name for the Form Template in the Name field.  This field is mandatory as indicate by the formtemplatedetailsb1 image next to the field.  This field will be used an the form template identifier throughout the system.

Provide a description for the Description field.  This is an optional field

Select "Use Flat Table Structure" option if form data is to be stored in a separate table/view generated by the system.

If this option is selected the system will generate two database objects, table and view, named EFTable_{TemplateID} and EFView_{TemplateID}, e.g EFTable_1 and EFView_1 if the form template id is 1.  Select this option if data is required to be accessed by external systems to Enterprise Forms.

If this options is not selected Enterprise Forms will store data in a built-in data structure provided by the system.

Select "Single Submit Per User" option to restrict the number of times a user is allowed to submit the form.  In other words, a form user is only allowed to submit a form once.

Description of read-only fields:

Template ID:  this is the unique ID of the form template generated by the system when created.

Version:  This is the current version number of the form template.  The version number is incremented when there is a change made in the system such as locking, unlocking or changing the state of the form template

State:  The current state of the approval process for the form template.  This value is changed when the the form template is progressed through the workflow.

Owner:  Name of the user who created the form template

When created:  Time stamp of when the form template was created.

Last updated:  Time stamp of when the form template was modified

Locked by:  Name of the user who has exclusive access to the form template.  A user needs to have exclusive lock access to the form template in order to make changes to the Form Layout

When locked:  Time stamp of when the form template was locked

Click on the Update button to apply the changes

 

 

Create/Edit Form Layout

Click on the Form Designer link button (formtemplatedetailsb2) to open the Form Template Designer screen to edit the form layout

 

 

Create/Assign Custom Form Template roles

Click on the Access Roles link button (formtemplatedetailsb3) to open the Custom Form Roles designer screen to create and map DotNetnuke® native roles to each created Custom Form Role

 

TIP:

Custom Form Role is essentially a group of one or more native DotNetnuke® role.  Custom Form Role is used for determining and assigning the appropriate security access to each state of the workflow.  One or more Custom Forms Role must exist for a form template to be valid.

 

 

Create/Edit States

Click on the Form States link button (formtemplatedetailsb4) to open the Form States screen to create and edit form states for the workflow

 

TIP:

Workflow states are the essential component of a workflow.  A workflow is basically a series of connected states.  A workflow must contain one or more connect steps.  Thus it is recommended to have at least two states in a workflow, even though it is possible to have a single state workflow whereby the same state can begin and end a workflow

 

 

Create/Edit Workflow

Click on the Workflow link button (formtemplatedetailsb5) to open the Form Workflow screen to create and edit the workflow

 

 

Localize Form Fields

Click on the Localization link button (formtemplatedetailsb6) to open Field Localization screen to create and maintain separate language versions of the form.

 

Preview the Form Template

Click on the Preview link button (formtemplatedetailsb7) to Preview what the form will look like when it is in used

 

TIP:

Fields with Databinding properties may display error messages if they can not be bound to the field.  These errors will be to be addressed before it can be validated

 

 

Validate the Form Template

Click on the Validate link button (formtemplatedetailsb8) to perform overall validation on the form template

 

TIP:

A form template must be validated before it can be published for use.  The validation process check for

Existence of form fields in the Form Layout

Existence of Custom Form Roles and associated mappings to native DotNetnuke® roles

Existence of States and Workflow

Errors for fields with Databinding properties.  Note that Conditional Databind properties can not be validated until it being used

 

Publish the Form Template

Click on the Change State link button (formtemplatedetailsb9) to begin the process of publishing the Form Template

 

TIP:

When a form template is In Development state, it must not be unlocked before being able to progress the form template to the next level

 

Lock/Unlock for exclusive editing access

Click on the Lock/Unlock link button (located next to the Lock By property) to Lock or Unlock the form template for exclusive edit access to the form template.

 

TIP:

This functionality is only available in the following conditions

The Lock/Unlock link button is only available when the form template is In Development state.

The Lock link button is only available when no user has exclusive exclusive lock access to the form template

The Unlock link button is only available to the user who currently has exclusive lock access to the form template

When the form template is locked, the read-only properties labels Locked By and When Locked display the appropriate information about the user who currently has exclusive lock access and when it was locked.  In addition, the Last Update property is also updated

A history record is added when the form template is Locked or Unlocked by a user

 

Preview previous Form Template version

Click on the Preview button (formtemplatedetailsb10) located on the far right of each row of the Forms Template Changes History list to Preview the form template at that particular version

 

 

Rollback to previous Form Template version

Click on the Rollback button (formtemplatedetailsb11) located on the far right of of each designated row of the Form Template Changes History list to rollback the current version of the form template to the listed version

Press Ok to confirm the rollback process or Cancel to cancel the rollback process

 

TIP:

Some additional notes to be aware

Rollback functionality is only available when form template is In Development state

Rollback functionality is only available when the current user has exclusive lock access to the form template

When rollback occurs, only the form layout of the form template is rolled back

A minor (or point) increment is applied to the current form template version

 

 

Delete Form Template

Click on the Delete link button (formtemplatedetailsb12) to delete the form template

Press Ok to confirm the delete process or Cancel to cancel the delete process

 

TIP:

When a form template is deleted, ALL information including data instances of the form template is removed from the system.  Once deleted, it can not be recovered.

 

 

Modify Sort Order for Change History List

To sort on how Form Template Changes History list should be displayed, click on the header name link button for the required column to sort

How the list is being sorted is indicated the by red arrows (formtemplatedetailsb13 formtemplatedetailsb14) next to the column header name.  The red arrow pointing down indicates the list is being sorted in descending order for the selected column.  The red arrow pointing up indicates the list is being sorted in ascending order for the selected column.

TIP:  Sort ordering of Form Template Changes History list is personalized thus the next time the user gets back to this screen the sort order will be remembered.

 

 

Modify Paging Size for Change History List

In the Records Per Page  field, select a page size from the list of available sizes.  This action re-orders the list and displays form template records up to the size selected.

 

TIP:

Form Template Changes History paging size  is personalized thus the next time the user gets back to this screen the paging size will be remembered.

 

 

Navigate between pages in Change History List

To navigate between pages of the Form Template Changes History list, click on the the required number link button displayed at the bottom bar of the list.

 

TIP:

The Page currently being viewed is indicated by the Red font color