Line 20: | Line 20: | ||
==Field and Quick Form== | ==Field and Quick Form== | ||
Below is Example are doing following actions | |||
* Create UDF_JobTitle at Maintain User | |||
* Create New Form at Maintain User | |||
===Steps=== | |||
:01. Right Click at '''User''' | |||
[[File:MaintainDIY-02.jpg|center]] | [[File:MaintainDIY-02.jpg|center]] | ||
:02. Select '''New Field''' | |||
[[File:MaintainDIY-03.jpg|center]] | |||
:03. Click '''New''' button | |||
[[File:MaintainDIY-04.jpg|center]] | |||
:04. Enter Description (eg Calc-Field) | |||
:05. Click the + button to add the New UDF Field & Enter/Select the option as above picture | |||
* Available Data Field Type | * Available Data Field Type | ||
:{| class="wikitable" | :{| class="wikitable" |
Revision as of 04:41, 2 November 2015
Menu: Tools | DIY | Maintain DIY...
Introduction
This Additional Module(DIY Fields Module) where user can
Function Description Field and Quick Form User can Self Create new User Define Field(s) & Design the Layout Script Customise the Application Calculation Override the build in Calculation (SQL Payroll ONLY) View Template For Advance Form Mode Report Data Deprecated
Field and Quick Form
Below is Example are doing following actions
- Create UDF_JobTitle at Maintain User
- Create New Form at Maintain User
Steps
- 01. Right Click at User
- 02. Select New Field
- 03. Click New button
- 04. Enter Description (eg Calc-Field)
- 05. Click the + button to add the New UDF Field & Enter/Select the option as above picture
- Available Data Field Type
Field Type Definition String Text data of a fixed length (up to 8192 bytes) Unicode String A field representing a Unicode (16 bits per character) string. Boolean A Boolean value. Integer Whole numbers in the range of long integers (32 bits). Currency Currency values with the same range as the Real data type. Bcd Real numbers with a fixed number of digits after the decimal point. Date A date value. Blob Binary data with no size limit (BLOB stands for binary large object). The theoretical maximum limit is 2 GB. Memo Text of arbitrary length.
- ----------------------------------------------------------------------------------------------------------------------------------------------------
- ----------------------------------------------------------------------------------------------------------------------------------------------------
- More Coming Soon...
See also
- SQL Control Center
- Others Customisation