- 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
Once a DC is created, you can start creating fields by selecting from the available options under the New. Select the field type as per need. Most field types are self-explanatory. The advanced fields like table fields & the form elements will be described in later sections.
If you want to display additional details about the field with instructions, use the Purpose/Help Text option in the dev site.
Help text appears as a ? in the field name area as shown on the run time.
Save a tstruct
Once your form elements are created, Click on the Save button in the top toolbar. This will save the tstruct and will be available at run time. After Save, use the Form Design option to design the form. The Form Design need not be done if a tstruct is not published as a form to the user.
In the Employee details DC you have created, Add fields like Employee Name, Gender, Date of Birth, Age, Qualification. Pick suitable field types and create them, Save the form after completion.
Create Field in run time (11.2 & above)
On the developer site, create a button in the toolbar “Add New Field” and save the structure.
Visit the Run site and go to the created tstruct. Click on options and click on add new field button.
An axpert developer screen to add new field appears.
Insert the necessary details and submit. Go to the run site and refresh the form.
Remove Field in run time (11.2 & above)
Go to the axpert developer page where the field was created and click on the remove button.
Visit the run site and reload the tstruct
See it working
Login to www.agilecloud.biz/run using the given credentials. The form will be automatically added to the menu. Click on it, and see it working. Axpert manages all the functionality related to the saving, listing, searching, editing & deleting data in the form.