Axpert 11
TStructs (Forms)
- 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
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
Formulae in fields
A formula can be assigned to any field in Axpert. A formula for a field is assigned in the expression property. The formula will be evaluated and assigned as the field value at run time. All fields in this tstruct/form that are before this field can be used as variables in the formula. The operators + – * / ^ ( ). { are used as quotes in Axpert. So, to use a constant string, enclose the string between { }. For example, a string hello in an expression is set as {Hello}. The list of functions that can be used in Axpert is available in the Axpert functions section.
Example: Consider a form that contains below fields
- ItemName
- ItemType
- SellingRate
- SaleQuantity
- DiscountPercent – This should be populated with 3% if ItemType=A and SaleQuantity> 5 or ItemType=B and SaleQuantity> 100
- SaleAmount – This should be based on calculation
Formula for DiscountPercent :
iif( ((ItemType={A}) & (SaleQuantity>5)), 3, iif((ItemType={B} &SaleQuantity>100), 5, 0))
Formula for SaleAmount :
(SellingRate*SaleQuantity) – (((SellingRate*SaleQuantity)*DiscountPercent)/100)
For more information on Axpert Functions check General Functions section.
Try Out