Continuing from previous article, Managing External Database Connections, this article describes the process of Managing Database Queries. 

What Is a Database Query? In Enterprise Forms a Database Query is basically a way of providing data interactions between forms and database objects (tables, stored procedures and raw sql) as defined through supported external database connections.  Once defined, they are used in forms as specialized tokens with its own namespace.  For example, say we have a database table called “Users” and wish to retrieve data from a column called “username” we could define the Database Query such that when used it is accessed as simple token  “[USERS:username]”. 

A Database Query is specific to each form template, thus a database query created in one form template cannot be accessed from another form template.  A form template, however, can have as many...

Read More »

Enterprise Forms 4.1 introduces a new feature called External Database Connections (EDC), which essentially provides the ability to connect to external databases other than the default portal database.  Not only it is possible to connect to other Microsoft SQL databases, EDC also support other database servers such as Oracle, MySQL, VistaDB, PostgresSQL and of course Microsoft Access.

This article discusses the process of enabling and configuring External Database Connections in Enterprise Forms.  To setup External Database Connection you will need to

Activate External Database Connection feature for the portal Add database connections and associate with form templates Activate External Database Connection feature

To use EDC the feature needs to be enabled via a configuration settings which only a Host or SuperUser can have access to.  The EDC feature is a per portal setting which needs to be enabled or disabled for each portal Enterprise Forms is being...

Read More »

Paypal Workflow Task is an Advanced Workflow Processing task providing a mechanism to integrate form submission and Paypal payment processing.

To use the Paypal Workflow Task, simply select the PayPal Payment Gateway item from the list of available workflow processing tasks.  Note that the Paypal Payment Gateway must be enabled via Advanced Portal Features before it could be used.

Enterprise Forms has a mechanism called Conditional evaluation in which a number of powerful features derive from. 

• Conditional Databind: the ability to bind data to form fields based on a condition
• Conditional Visibility: the ability to hide/show as well as enable disable form fields based on a condition
• Conditional Workflow: the ability to move a form to different workflow states based on a certain condition
• Conditional Processing Task: the ability to execute advanced workflow processing task based on a certain condition.