Posted on

Pivot Form

PivotGrid Overview

media_1448032907497.png

The Pivot Grid is a tool for data visualization application for multi-dimensional data analysis

media_1448560130678.png

Displaying the Chart

media_1453378771628.png

To view the chart, right click on the top of the Pivot Grid and click the Show Chart option.

media_1453378803605.png

The chart wil appear on the bottom.

Drag the seperator up or down to increase/decrease hight of chart.

Editing Data

media_1453378830225.png

The Pivot Grid is used for analysis and does not allow the editing of existing data.

To edit existing data, click on the Default View drop down and select Edit View.

media_1453378838942.png

The list changes to a Grid List and editing can occur by double clicking on a row

Posted on

Tree Form

TreeList Overview

media_1448032891356.png

The TreeList Form displays data and it’s relationships in a hierarchical format.

media_1453379731544.png

Editing Data

media_1453380133309.png

Double clicking on any record will bring up the Detail View for that record.

Posted on

Grid Form

Grid Overview

media_1448032863244.png

List View

media_1448560024280.png

Editing Data

media_1448560072758.png

Double clicking on any record will bring up the Detail View for that record.

Posted on

Adding a Form

media_1447997368382.png

Click on the form type you would like to add and drag it onto the Designer.

media_1447997446791.png

Name – the name of the form.

Caption – the text your users will see.

Navigation – where in the navigation your form will appear. There will be no navigation if left blank.

Image – double click to add an image.

media_1447997455832.png

Select an image from the existing images or…

media_1448821177024.png

click the Custom Images to add an image of your own.

Click the Plus button.

media_1448821222740.png

Select the image you would like to add and click Open.

media_1448821266948.png

Click the Ok button when finished.

media_1447997379496.png

The new Form will appear on the Designer.

Posted on

Overview

media_1447901060768.png

The Designer is where you will build the base of your software.

It is broken up into several sections.

Designer
Form Toolbox
Ribbon

Form Toolbox

media_1447902103029.png

The Forms toolbox will contain the many different types of Forms that can be added.

Ribbon Sections

media_1447901942241.png

Layout Section

Refresh – reorders the forms into a more organized layout.

Tools Section

Select – sets the cursor to allow for item selection.
Pan – sets the cursor to a hand to allow for Designer navigation.
Zoom – allows the zooming in and out of the Designer.

media_1447902036414.png

Forms Section

Edit – brings up the form to edit Form details.
Remove – deletes the selected From and removes it from the Designer.

Text – brings up a list of Static Text elements on the Form.
Hyperlinks – brings up a list of Static Hyperlinks on the Form.
Banner – brings up a list of images that will be shown within a banner.
Browsers – brings up a list of browsers that can display webpages.

Add to Library – add the Form to the Library that can be used to clone in other projects.

media_1447902057823.png

Properties Sections

Edit – bring up the form to edit Property Editor details.
Add – add new Property Editor when Form is selected.
Remove – remove selected Property Editor from Form.

Rules – bring up Rules designated for selected Property Editor.
Items – preselection items for Property Editors like Combo Box.
Formula – opens up the Formula Builder for Calculation Editors.

 

media_1447902067209.png

Relationships Section

Select – changes cursor back to arrow for selectibility.
One To One – allows for a One To One relationship to be created.
One To Many – allows for a One To Many relationship to be created.
Many To Many – allows for a Many To Many relationship to be created.

 

Designer Navigation

media_1447902077074.png

To search for Forms, type in text you would like to search on and click the Search button.

All Forms with that text will be brought into the middle of the Designer.

Clicking the Search will bring the next Form that meets the text criteria into focus.

media_1448820396840.png

To bring the diagram into the center of the Designer, click the center button on the bottom left.

media_1448820405192.png

Click the Thumbnail button to see a Thumbnail view of the entire diagram.

Moving the Red square will move the main diagram.

Zooming in and out can be accomplished by changing the 100% or by clicking the + or – buttons.