LyteRAD is a free rapid application development tool to put together complex applications in minutes. Specially designed for lightweight database applications.

A huge collection of ready to use application templates are available for various domains. You could start using them straight away or use it to get a head start in building your own solution. Best of all, everything is free!.




Getting Started

Building applications in lyteRAD is as simple as 1-2-3!

1. Identify data that needs to be stored and create tables to hold it. A table is a generic structure to hold repeating attributes/fields of data.

2. Create charts and reports which are nothing but visual representation of data stored in tables.

3. Widgets provide user interaction for your application. Select a bunch of widgets based on your application needs like a data entry form, search button and so on.
Save your application, and you're done!



Workspaces

Workspaces are used to group a bunch of related charts, reports, tables and application data into a logical workspace area.


Tables

Tables form the fundamental structures to store data in lyteRAD applications. Tables consist of rows and columns, where columns define the specific datatypes and rows capture the actual values. Create new tables by defining what datatypes will be stored in each column.

Identify various attrributes/values that need to be captured repeatedly, These repeating items will form the columns. Specify the type of data that will be stored in each column.

Simple DataTypes

Numeric, Decimal, Boolean, Date, Text

Complex DataTypes

SmallImage, LargeText

Special DataTypes

MultiItem, Link, Triggers


Reports

Reports are generated from table data by retrieving records that match a specific criteria. Records can be grouped and categorized on a specific column to build a periodic or categorized view of data.

Report Columns

When you choose a table for reports, by default all the columns in the table are included. To specifically display or hide report columns open the column editor.

The column editor allows further customization of every column by specifying fonts, colors and modifiers.

Filter Criteria

The report can have a filtering criteria attached to it. Click on the search/filter button to specify a filter criterion. Report data can also be grouped by a specific column.


Report expressions

To calculate subtotals and mathematical expressions, click on the expressions button to start the expressions wizard.

Headers & Footers

Edit report headers and footers using the wizard.


Application

LyteRAD creates applications by combining data and various user interactions elements called widgets. These applications can be packaged and distributed to other people.

Widgets

Widgets are user interface elements that provide the primary means of interaction with users. They visualize and render existing table data. Multiple widgets can be used to provide different representations of the same data.

The Application Designer

The designer layout is split into three areas. There is a large preview pane on the right side, which shows a preview of the currently selected widget. You can select widgets for preview by clicking on the widget toolbar on top.



On the bottom left is a list of widgets that are currently added to the application. After adding all the required widgets click on save and the application will be saved.