- Create Form
- Create DC
- Create Fields
- Grid DC/frames
- Formulae in fields
- SQL in fields
- Drop down fields
- Autogenerate fields
- Table fields
- File upload fields in forms
- Photos & Image fields
- Fill Grid
- Posting data – Gen maps
- Updating fields in DB tables – MD Map
- Toolbars in tstructs
- Tracking changes/Audit trial
- Try it yourself
Users & Roles
Publish Axpert Apps
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.
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.
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.
The headerId also will be created as a field in the Detail table with a foreign key relationship with headerid in the header table.
So, when data is stored in these tables at run time, the referential integrities are automatically established.
Click on the DC Layouts button to choose the layout. It has a default layout.
Single Column: Non-grid dc fields align 1 below other as name-value pair and this will not allow field Drag &Drop and Resize
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
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
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.
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.
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.
To add a new label right click on the white area of the form design.
Click on add label and enter suitable caption in the 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.
Tstruct application properties
To modify or set tstruct application properties click on the settings button available at the top left of the window.
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).
This option in Tstruct design properties shrinks the field size in the Tstruct.
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.
The result of enabling static run mode will be as shown below
When we disable the option the result will be
This option in the Tstruct design properties shows a wizard view of the DC’s in the tstruct.
This view is enabled only if the form has more than one DC.
In the previously created employee form, add an appropriate Caption like Axbox Employee Details to be displayed and click on Submit.
A DC is created successfully. To add fields to the created DC, move to the next section.