Maintain DIY: Difference between revisions

From eStream Software
Line 31: Line 31:
:03. Click '''New''' button
:03. Click '''New''' button
[[File:MaintainDIY-04.jpg|center]]
[[File:MaintainDIY-04.jpg|center]]
:04. Enter any Description(eg Calc-Field) in the Name field (Only Alphanumeric & no spacing)
:04. Enter any Description (eg Calc-Field) in the '''Description''' field (Only Alphanumeric & no spacing)
:05. Click the + button to add the New UDF Field & Enter/Select the option as above picture
:05. Click the + button to add the New UDF Field & Enter/Select the option as above picture



Revision as of 05:42, 2 November 2015

Menu: Tools | DIY | Maintain DIY...

Introduction

This Additional Module(DIY Fields Module) where user can

MaintainDIY-01.jpg
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
MaintainDIY-02.jpg
02. Select New Field
MaintainDIY-03.jpg
03. Click New button
MaintainDIY-04.jpg
04. Enter any Description (eg Calc-Field) in the Description field (Only Alphanumeric & no spacing)
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.


----------------------------------------------------------------------------------------------------------------------------------------------------
Template.Warning-01.jpg
  • Only String data can increase the field size so plan properly before add the field.
  • User can't change from 1 data type to another once it save.
----------------------------------------------------------------------------------------------------------------------------------------------------


  • More Coming Soon...

See also