Background Lookup

If a user selects a specific item from a list, for example, you may want the form to go retrieve data from a database and then populate that data into a field elsewhere on the form.

Popup Lookups

You may require your form to be able to extract data from a database or LDAP system. For example, a parts catalog is stored in an Oracle or SQL database and you want to allow the user to search that catalog and return the official part name, unit price and code back into the form.

Writing to database tables

PerfectForms™ can add information to a database table.

Calling stored procedures

PerfectForms™ can send information to a stored procedure.

Directory Services (LDAP)

PerfectForms™ treats LDAP like a database and is able to perform background and popup lookups.

Web Services

PerfectForms™ has the ability to pass data from the form to a Web Service. This is a good approach for developers as well as being the standard SOA type interface for many products such as SalesForce.com, SAP and more.

Text/CSV

PerfectForms™ has a connection type that allows a text (ASCII, delimited) file to be treated as a database.