|
|
| (95 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 field type | | * [[Maintain DIY]] |
| :: - Boolean
| | * Others [[Customisation]] |
| :: - Currency
| |
| :: - Date
| |
| :: - Float
| |
| :: - Integer
| |
| :: - Memo
| |
| :: - Picture
| |
| :: - String
| |
| | |
| * For Explaination 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 Field had the below interface
| |
| ::[[File:DIYField-01.jpg|700px]]
| |
| | |
| ::{| class="wikitable"
| |
| |-
| |
| ! Name !! Description
| |
| |-
| |
| | Example || Example
| |
| |-
| |
| | Example || Example
| |
| |-
| |
| | Example || Example
| |
| |-
| |
| | Example || Example
| |
| |-
| |
| | Example || Example
| |
| |-
| |
| | Example || Example
| |
| |-
| |
| | Example || Example
| |
| |-
| |
| | Example || Example
| |
| |-
| |
| | Example || Example
| |
| |-
| |
| | Example || Example
| |
| |-
| |
| | Example || Example
| |
| |-
| |
| | Example || Example
| |
| |}
| |
| ===Header Fields===
| |
| | |
| ===Item Fields===
| |
