MENU
Open All
|
Close All
Creating & Calling
General
Printing & Exporting
Sorting & Paging
Filtering
VIEW Mode
ADD/EDIT/DETAILS Modes
Foreign Keys
Master/Details Keys
:
Back
DataGrid Wizard - Assistance :: Contact Types (a_contact_types.php)
[ Switch to Code
]
[ : Back ]
Creating & Calling
PHP Extension
:
PDO
Database Type
:
MySQL
PostgreSQL
SQLite
Oracle
Cubrid
Firebird / Interbase 6
FreeTDS / MSSQL / Sybase (dblib)
Microsoft SQL Server (sqlsrv)
IBM DB2
IBM Informix Dynamic Server
ODBC v3 (IBM DB2,unixODBC,win32 ODBC)
DataGrid Unique Prefix (ex.: ab_)
:
*
Debug Mode
:
On
Off
Database Host
:
Database Name
:
*
Database User
:
*
Database Password
:
General Settings
PostBack Method
:
GET
POST
AJAX
Language
:
Arabic
Bulgarian
Catala
Chinese
Czech
Danish
English
Espanol
Finnish
French
German
Greek
Hebrew
Bosnian/Croatian
Hungarian
Italiano
Japanese
Korean
Lithuanian
Netherlands
Brazilian Portuguese
Polish
Romanian
Russian
Swedish
Serbian
Thai
Turkish
Direction
:
Left-to-Right
Right-to-Left
Collation
:
-- select --
armscii8_bin
armscii8_general_ci
ascii_bin
ascii_general_ci
big5_bin
big5_chinese_ci
binary
cp1250_bin
cp1250_croatian_ci
cp1250_czech_cs
cp1250_general_ci
cp1250_polish_ci
cp1251_bin
cp1251_bulgarian_ci
cp1251_general_ci
cp1251_general_cs
cp1251_ukrainian_ci
cp1256_bin
cp1256_general_ci
cp1257_bin
cp1257_general_ci
cp1257_lithuanian_ci
cp850_bin
cp850_general_ci
cp852_bin
cp852_general_ci
cp866_bin
cp866_general_ci
cp932_bin
cp932_japanese_ci
dec8_bin
dec8_swedish_ci
eucjpms_bin
eucjpms_japanese_ci
euckr_bin
euckr_korean_ci
gb2312_bin
gb2312_chinese_ci
gbk_bin
gbk_chinese_ci
geostd8_bin
geostd8_general_ci
greek_bin
greek_general_ci
hebrew_bin
hebrew_general_ci
hp8_bin
hp8_english_ci
keybcs2_bin
keybcs2_general_ci
koi8r_bin
koi8r_general_ci
koi8u_bin
koi8u_general_ci
latin1_bin
latin1_danish_ci
latin1_general_ci
latin1_general_cs
latin1_german1_ci
latin1_german2_ci
latin1_spanish_ci
latin1_swedish_ci
latin2_bin
latin2_croatian_ci
latin2_czech_cs
latin2_general_ci
latin2_hungarian_ci
latin5_bin
latin5_turkish_ci
latin7_bin
latin7_estonian_cs
latin7_general_ci
latin7_general_cs
macce_bin
macce_general_ci
macroman_bin
macroman_general_ci
sjis_bin
sjis_japanese_ci
swe7_bin
swe7_swedish_ci
tis620_bin
tis620_thai_ci
ucs2_bin
ucs2_czech_ci
ucs2_danish_ci
ucs2_esperanto_ci
ucs2_estonian_ci
ucs2_general_ci
ucs2_hungarian_ci
ucs2_icelandic_ci
ucs2_latvian_ci
ucs2_lithuanian_ci
ucs2_persian_ci
ucs2_polish_ci
ucs2_roman_ci
ucs2_romanian_ci
ucs2_slovak_ci
ucs2_slovenian_ci
ucs2_spanish2_ci
ucs2_spanish_ci
ucs2_swedish_ci
ucs2_turkish_ci
ucs2_unicode_ci
ujis_bin
ujis_japanese_ci
utf8_bin
utf8_czech_ci
utf8_danish_ci
utf8_esperanto_ci
utf8_estonian_ci
utf8_general_ci
utf8_hungarian_ci
utf8_icelandic_ci
utf8_latvian_ci
utf8_lithuanian_ci
utf8_persian_ci
utf8_polish_ci
utf8_roman_ci
utf8_romanian_ci
utf8_slovak_ci
utf8_slovenian_ci
utf8_spanish2_ci
utf8_spanish_ci
utf8_swedish_ci
utf8_turkish_ci
utf8_unicode_ci
CSS Class
:
Default
Blue
Gray
Green
Pink
X-Blue
X-Gray
X-Green
Caption
:
Footer
:
Allowed Mode Operations
:
Add
|
Edit
|
Delete
|
Details
Multi-Row Operations
:
Edit
|
Details
|
Clone
|
Delete
Enable
:
On
Off
Printing & Exporting Settings
Allow Printing
:
No
Yes
Allow Exporting
:
CSV
|
XLS
|
PDF
|
XML
Enable
:
No
Yes
Export all records
:
No
Yes
Sorting & Paging Settings
Allow Column Sorting
:
No
Yes
Allow Paging
:
No
Yes
Rows Numeration
:
No
Yes
Default Size
:
5
10
15
20
25
50
100
250
500
1000
Pager Positions
:
Bottom
Top
Both
Dropdownlist
:
No
Yes
Filtering Settings
Allow Filtering
:
No
Yes
Layout
:
Tabular (horizontal)
Columnar (vertical)
Advanced (inline)
Caption
Type
Table
Field Key
Operator
Width
Sensitivity
Comparison
Name
textbox
contacts_type
contact_type_name
%like%
No
string
+ Add New Field
VIEW Mode Settings
Table
:
*
-- select --
access
accounts
accounts_customer
accounts_doc
accounts_employee
accounts_employee_salary
accounts_expense
accounts_expense_category
accounts_expense_customer
accounts_expense_mismatch
accounts_expense_purchase
accounts_expense_sale
accounts_movement
accounts_object
accounts_payment
accounts_payment_category
accounts_payment_customer
accounts_payment_expense
accounts_payment_mode
accounts_payment_office
accounts_payment_supplier
accounts_payment_wallet
accounts_property
accounts_register
accounts_register_close
accounts_register_open
accounts_supplier
accounts_transaction
accounts_transaction_movement
accounts_transaction_product
accounts_transaction_status
accounts_transaction_type
accounts_user
banks
banks_account
brands
brands_doc
brands_doc_relation
cases
cities
constitutions
contacts
cordinators
countries
departments
departments_guideline
departments_manager
designations
districts
doc_types
documents
estimates_category
estimates_category_relation
estimates_category_sub
estimates_category_sub_alert
estimates_category_sub_item
estimates_category_sub_item_standard
estimates_category_sub_task
follows
form_1
form_2
form_2_a
form_2_b
form_2_c
form_3
form_3_a
form_3_b
forms
leads
leads_source
leads_status
menus
menus_category
menus_category_sub
menus_items
models
models_primary
notes
offers
offices
offices_doc
offices_employee
offices_payment_recepient
offices_user
opportunities
process_1
process_10
process_10_a
process_11
process_11_a
process_12
process_12_alert
process_12_attendee
process_12_csat
process_12_event
process_12_photo
process_12_standard
process_12_task
process_12_video
process_2
process_3
process_4
process_5
process_7
process_8
process_9
processes
products
products_category
reports_work
states
tasks
uqc
vendors
vendors_type
vendors_user
Query
:
SELECT * FROM TABLE (standard)
Custom
SELECT contact_type_id, contact_type_name FROM contacts_type
Fields
:
All fields (*) - auto generated
Specify by one
Layout
:
Tabular (horizontal)
Columnar (vertical)
Width
:
%
px
em
pt
ADD/EDIT/DETAILS Modes Settings
Table
:
*
-- select --
access
accounts
accounts_customer
accounts_doc
accounts_employee
accounts_employee_salary
accounts_expense
accounts_expense_category
accounts_expense_customer
accounts_expense_mismatch
accounts_expense_purchase
accounts_expense_sale
accounts_movement
accounts_object
accounts_payment
accounts_payment_category
accounts_payment_customer
accounts_payment_expense
accounts_payment_mode
accounts_payment_office
accounts_payment_supplier
accounts_payment_wallet
accounts_property
accounts_register
accounts_register_close
accounts_register_open
accounts_supplier
accounts_transaction
accounts_transaction_movement
accounts_transaction_product
accounts_transaction_status
accounts_transaction_type
accounts_user
banks
banks_account
brands
brands_doc
brands_doc_relation
cases
cities
constitutions
contacts
cordinators
countries
departments
departments_guideline
departments_manager
designations
districts
doc_types
documents
estimates_category
estimates_category_relation
estimates_category_sub
estimates_category_sub_alert
estimates_category_sub_item
estimates_category_sub_item_standard
estimates_category_sub_task
follows
form_1
form_2
form_2_a
form_2_b
form_2_c
form_3
form_3_a
form_3_b
forms
leads
leads_source
leads_status
menus
menus_category
menus_category_sub
menus_items
models
models_primary
notes
offers
offices
offices_doc
offices_employee
offices_payment_recepient
offices_user
opportunities
process_1
process_10
process_10_a
process_11
process_11_a
process_12
process_12_alert
process_12_attendee
process_12_csat
process_12_event
process_12_photo
process_12_standard
process_12_task
process_12_video
process_2
process_3
process_4
process_5
process_7
process_8
process_9
processes
products
products_category
reports_work
states
tasks
uqc
vendors
vendors_type
vendors_user
Fields
:
All fields (*) - auto generated
Specify by one
Layout
:
Tabular (horizontal)
Columnar (vertical)
Width (for modes)
:
Add/Edit:
%
px
em
pt
Details:
%
px
em
pt
Foreign Keys Settings
+ Add New Field
Master/Details Keys Settings
+ Add New Field
[ Switch to Code
]
[ : Back ]