Agile-Developer

Create DC

Axpert 11

TStructs (Forms)

IViews

Scripts

Axpert Jobs

Axpert Cards

HTML Plug-ins

Users & Roles

Workflow

Axpert API

Application Var/Params

Publish Axpert Apps

Axpert Mobile

Settings

Utilities

Customization

WebServices

Axfast

Creating a DC(Data Container) in Axpert

Here is a Tutorial video on creating a DC,

A DC is a Data Container On successful creation of a form, the form elements are listed on the left panel. It shows the properties of a selected element on the right panel. For a new form, by default, a DC is added. A data container is a frame in the form. A DB table name can be set in the table name property of a DC. When the structure is created, the table is also created in the backend database. One or more fields can be created under a DC. Each field in the DC will be created as a component in the form. It is also created as a field in the table. A DC table that is created by Axpert will contain the TableName+Id as a field. This is the primary field for this table & Axpert populates this field with a unique number. This field is referred to as recordid in Axpert.

Agile developer lowcode Create DC

There can be more than one DC in a tstruct. The first DC in tstruct is called a Primary DC. The tables of DCs other than the primary DC will also contain the tablename+idfield of the primary DC table.

For example, consider a tstruct that has 2 DCs. The Primary DC table is the header and the second DC table in detail.
Agile developer lowcode Create DC Form
The header table will be created with HeaderId as its primary field. The detail table will be created with DetailId as its primary field. For example, in the table axemp1, axemp1id is the HearderId.
Agile developer lowcode primary field
The headerId also will be created as a field in the Detail table with a foreign key relationship with headerid in the header table.
Agile developer lowcode Create DC Header
So, when data is stored in these tables at run time, the referential integrities are automatically established.

Boolean DC

New property named as ‘BooleanDC’ was introduced for a DC. This property cannot be set for the primary DC. It can be used on the other DCs in a form except for the primary DC.
Agile developer lowcode Boolean DC Form' src=
Note: If any dc is set as BooleanDC, those DCs can be expanded/collapsed by using the switch button. For BooleanDC’s an additional property named as ‘default state’ to set the expand/collapse during the form load. For example, while creating use either of the options and save the structure.
Agile developer lowcode Boolean DC structure
In the run site it will be displayed as shown
Agile developer lowcode Boolean New Form
Boolean DC value can be fetched and stored in the DB by using the prenamed field as ‘axp_dcstate’ in primary DC.

For Ex.: In a form containing 3 dc’s and a second DC is collapsed during the save, then the axp_dcstate field value will be stored as ‘TFT’
A new function ‘GetDcState({dcname})’ is introduced in parse to get the current state of a particular DC. The function will return T/F based on DC Expand/Collapse state.
Ex.: iif(GetDcState({dc2}),AxDcCollapse({dc2}),AxDcExpand({dc2}))

DC Layouts

Click on the DC Layouts button to choose the layout. It has a default layout.

Agile developer lowcode DC Layouts

Single Column: Non-grid dc fields align 1 below other as name-value pair and this will not allow field Drag &Drop and Resize

Agile developer lowcode DC Layouts Drag Drop

Double Column: Non-grid dc fields align 2 columns of row as name-value pair and this will not allow field Drag &Drop and Resize

Agile developer lowcode DC Layouts Drag Drop 1

Triple Column: Non-grid dc fields align 3 columns of row as name-value pair and this will not allow field Drag &Drop and Resize

Agile developer lowcode DC Layouts Triple

Adding label and hyperlink in Tstruct

To set font and hyperlink for the created fields as well as adding new labels to the dc buttons is now possible.
Right-click on the field created. A dropdown appears with two options font and hyperlink.

Agile developer lowcode hyperlink in Tstruct

Click on a font to change the existing font. The Font picker appears allowing you to set the font. A sample section at the bottom allows you to preview your selection.

Agile developer lowcode Tstruct Font Picker

Click on OK after completion. You can view your changes on the button in the form design.
To add a hyperlink, click on the option and enter the values. Click on Ok.

Agile developer lowcode Tstruct hyperlink

To add a new label right click on the white area of the form design.

Agile developer lowcode Tstruct form design

Click on add label and enter suitable caption in the pop-up

Agile developer lowcode Tstruct pop-up

The created label will appear in the form design. To reset the font or add a hyperlink to the new label, right-click on it and choose from the dropdown.

Agile developer lowcode Tstruct dropdown

Tstruct application properties

To modify or set tstruct application properties click on the settings button available at the top left of the window.

Agile developer lowcode Tstruct properties

Font Size: Increase/reduce the field value and by default is 14px.
Control Height: Increase/reduce the control height and by default is 24px.
Form Width: Entire form will sync based on width and minimum width 50% and maximum width 100% (100% width is the default)
Form Alignment: If width is instated to 100% then form position can be set to either default/center/right.
Field Caption width: Field caption can be set as required, but this considers only name-value pair layout (single/ column/double column/triple column).

Compress Mode

This option in Tstruct design properties shrinks the field size in the Tstruct.

Agile developer low code Tstruct Compress Mode

Static Run Mode

This option in the design properties trims the space between the rows and columns.

For example, when we enable the static run mode option, the spaces in between as displayed as it is.
Agile developer low code Tstruct Run mode

The result of enabling static run mode will be as shown below

Agile developer low code Tstruct Run mode 1

When we disable the option the result will be

Agile developer low code Tstruct Run mode 2

Check out this video to know more about List View

Custom HTML

Custom HTML option in the properties will help you customize your form view. Use the existing HTML code to style your form or enter the customized code in the custom HTML section and save.

Agile developer low code Tstruct Custom HTML

Wizard DC

This option in the Tstruct design properties shows a wizard view of the DC’s in the tstruct.

Agile developer low code Tstruct Wizard DC

This view is enabled only if the form has more than one DC.

Agile developer low code Tstruct Project Master

Try Out

In the previously created employee form, add an appropriate Caption like Axbox Employee Details to be displayed and click on Submit.
For example:
Agile developer low code Tstruct Axbox Employee

A DC is created successfully. To add fields to the created DC, move to the next section.