|
|
| (80 intermediate revisions by the same user not shown) |
| Line 3: |
Line 3: |
| ==Introduction== | | ==Introduction== |
| This Additional Module where user can self | | This Additional Module where user can self |
| * Create new field (DIY Fields Module) | | * Create new field ([[DIY Fields]] Module) |
| * Modified the SQL Accounting (DIY Script Module) | | * Modified the SQL Accounting ([[DIY Script]] Module) |
|
| |
|
| ==DIY Fields== | | ==See also== |
| * Available Data Field Type | | * [[Maintain DIY]] |
| :: - Boolean
| | * Others [[Customisation]] |
| :: - Currency
| |
| :: - Date
| |
| :: - Float
| |
| :: - Integer
| |
| :: - Memo
| |
| :: - Picture
| |
| :: - String
| |
| | |
| * For Explanation for Each Data Type may refer to http://www.w3schools.com/sql/sql_datatypes_general.asp
| |
| | |
| :::----------------------------------------------------------------------------------------------------------------------------------------------------
| |
| ::::{|
| |
| |-
| |
| | [[File:Template.Warning-01.jpg|80px]]||
| |
| Avoid use '''Picture''' data as it will cause your database size increase very fast.
| |
| |}
| |
| :::----------------------------------------------------------------------------------------------------------------------------------------------------
| |
| | |
| * User can create DIY Fields either at '''Header Fields''' or '''Item Fields'''
| |
| * In each Table had the below interface
| |
| ::[[File:DIYField-01.jpg|700px]]
| |
| | |
| ::{| class="wikitable"
| |
| |-
| |
| ! Name !! Description
| |
| |-
| |
| | Name||
| |
| * Field name
| |
| * Only Alphanumeric & no spacing
| |
| |-
| |
| | Data Type ||
| |
| * Type of Field
| |
| |-
| |
| | Size ||
| |
| * The Field Size | |
| * Only applicable for '''Float''', '''Integer''' & '''String''' Data Type
| |
| |-
| |
| | Sub Size ||
| |
| * The Field Sub Size normally is the Decimal Point
| |
| * Only applicable for '''Float''' Data Type
| |
| |-
| |
| | Caption ||
| |
| * Field name to be shown at user interface.
| |
| |-
| |
| | Required ||
| |
| * To tell the system the current field '''MUST''' not empty
| |
| |-
| |
| | Default Value ||
| |
| * Default Value to insert on New record
| |
| |-
| |
| | Display Format ||
| |
| * Set Display format for '''Float''', '''Currency''' & '''Integer''' Data Type
| |
| |-
| |
| | Load ||
| |
| * Reload again the Script from the Database (Only for DIY Script)
| |
| |-
| |
| | Load From File ||
| |
| * Load Script/Fields from the Text File.
| |
| * Be careful as system will delete the existing field before load the file to the system
| |
| |-
| |
| | Save ||
| |
| * Save Current Script/Field
| |
| * Don't do Delete, Rename & Insert in same time (Only for DIY Fields)
| |
| |-
| |
| | Save To File ||
| |
| * Save Current Script/Fields to Text File
| |
| |-
| |
| | + Button ||
| |
| * Add New Field
| |
| |-
| |
| | - Button ||
| |
| * Delete Selected Field
| |
| |}
| |
| ===Header Fields===
| |
| Below is the example for Sales Invoice
| |
| ====Add New Fields====
| |
| ::[[File:DIYField-02.jpg|700px]]
| |
| # At the left panel look for '''Sales Invoice | Header Fields'''<br />
| |
| # Click the '''+''' Button on top to add New fields as above picture<br />
| |
| # Click Save button<br />
| |
| | |
| ====Design Layout====
| |
| | |
| ===Item Fields===
| |
