Form Gallery

QLR Manager supports the design of Forms to search for and add, edit or delete data in a database table. Compare this capability to most web based Form Generator applications which only support the creation of Forms to add data to a database table.

There are two ways to access a Form in QLR Manager. The first is to log on to the QLR Manager application and choose a Form from a Menu. The second method is to create a QLR Widget which allows direct access to a Form. QLR Widgets can also be defined to access Reports, Macros and Menus. A widget is simply an http URL. These URLs can be used in e-mails, web pages, browser bookmarks, or even saved as a link on your desktop.

Below are several examples of QLR Form Widgets. Some are embedded into this web page inside an IFRAME and others are HREF links to a URL.

Note: Although these forms access live data, you will not be able to save and delete any data.

Form examples #1:
This first example is a Form that allows for the editing of Frank's Bait and Tackle customer information. The form is a "Free Style" layout, which allows for the placement of input fields anywhere in the form and works with one record at a time. When a form is defined to edit or delete data, a search panel is first presented to the User to find the appropriate data. This form is a widget embedded in an HTML IFRAME.
 

This second example is the same form as above except the layout has been changed from "Free Style" to a "Tabular" layout. A Tabular layout can be defined to edit from 1 to 100 rows of data at a time. This Form Widget is configured to open in a new window instead of in-line as an IFRAME. Click to open:  Customer Edit

Form examples #2:

The default input field for a form element is a text input. Utilizing QLR Manager's ability to create Input Controls, input fields can be defined that are select lists, check boxes, radio buttons, text areas, date input, even pop-up text areas. Regular Expressions can also be defined to create customized data validation, such as for e-mail addresses. In addition, there are some predefined controls which support file uploads and other features.

This is an example of a form that allows for the editing and uploading of photos. It utilizes a pop-up text editor field and a file upload control. The Widget URL was also edited to call reportwin2.html instead of reportwin.html, which has the header frame size set to 0, effectively hiding the header. This approach may be more suitable when the content of the Widget is loaded into an IFRAME. The background color was also changed by editing the value for &QLRbgc= in the Widget URL.
 

By simply changing the "Form use", a form's use can be quickly altered. In this example, the above photo edit form has been changed to a photo delete form. The input fields are automatically changed to only displaying data instead of permitting the data to be edited. Click to open:  Baitshop Photo - Delete

More examples:
Extensive formatting options for tabular report output Report Styles
5 chart styles with over 40 modifiable characteristics Chart Styles
Free form layouts using nested reports or charts Custom Layouts
Reports or charts embedded into PHP web pages Report Objects
 
Want to see more?

You can launch the QLR Manager demo and create your own reports, charts and forms from Frank's Bait and Tackle database. After launching the demo, you'll notice some instructions on the Connect panel, including the User ID and Password. This area can be used by the Administrator to post instructions or messages for their users. Please click the link below to launch the demo.

Product Demo