By EThuongmai Support on 12/5/2008 4:19 AM
Field Group Name is an undocumented feature that has been around since version 3.6. Field group name is essentially a property from the Edit Field element window that describe the name of a Group the field element belongs to. It is a way of categorizing field elements. By itself the property is not in any way a feature but when used in conjunction with Conditional Visibility it is time saver.
Pretty much all Enterprise Forms field elements have this property, FieldGroupName, and is generally located at the bottom of the General Tab of the Edit Field Element screen (as shown below).Â
 ... Read More » |
By EThuongmai Support on 12/4/2008 3:00 AM
One of the common requirements is to have a facility to be able to update captured form data to a custom database table other than the default storage location for EF forms. This article describes the basic steps to add/update submitted form data to a custom data table using the Execute Stored Procedure/SQL workflow processing task.
Â
Enabling Execute Stored Procedure/SQL Workflow Processing Task Execute SQL workflow processing task provides a mechanism to execute a stored procedure or a a set of raw SQL statements upon a form submission or workflow trigger. Like any workflow processing tasks, it must be activated and enabled by the portal super administrator before it could be used.
 Enable the Execute Stored Procedure/SQL Workflow Processing task Log in with a super user account Go to Form Template Manager module and select Advanced Portal Features Select the Execute Stored Procedure/SQL task from the list of Disabled Workflow Processing Task ... Read More » |
By EThuongmai Support on 12/3/2008 2:16 PM
This article describes the underlying storage area in Enterprise Forms. For most users this information is somewhat over the top however for developers and form designers with requirement to integrate with other systems this will provide a useful insight on how Enterprise Forms stores form data and how it could be used by other applications such as advanced report generation.
By default each unique form stores its data in its own normalized table called EFTable_{x} with {x} is the form template unique ID. In addition there is also a database view called EFView_{x} which is a replication of the EFTable_{x} except the column names in the view are the field elements names instead of the unique 43 characters ID in the table. Each data column in the table represent a data entry field in the form. In Enterprise Forms, a data entry field are those field elements of the following types
Textfield Textarea Richtext Checkbox Radio button Select list Radio list... Read More » |
By EThuongmai Support on 12/2/2008 5:16 PM
In version 4.2 we added the ability to attach a tooltip in form fields. A tooltip is a small pop-up window that appears when a user pauses the mouse pointer over a form element.
To add a tooltip to a form element
Edit the form element via the Form Layout Designer and navigate to the Layout tab
Layout tab of the Edit Element popup for the Select List field element Provide content to the Tooltip property and save changes NOTE: Each field element will have a different set of properties for the Layout tab. Thus the location of the Tooltip property may be different to the image shown... Read More » |
By EThuongmai Support on 12/1/2008 1:19 AM
One of the more popular feature requests is the ability to perform date range search in Enterprise Forms reports via the Report Manager module. We have heeded to the requests and decided to implement and include the feature for version 5.0.
The new feature will only take effect when new reports are generated and existing reports will be unaffected and function as normal.
The process of generating reports is the same as before except that if a date type field is selected as a Searchable report field users will be given the option to search on a data range instead of only a specific date as previously implemented.
The process of creating a Report in Enterprise Forms
Â
 ... Read More » |