Dictionary Entry :

Types Of Fields :

1. String
2. Reference
3. Choice field (Dependent field)        
4. True/false field
5. List
6. Journal

 

 

To find the table name of a field ,Right click on that field,Click on Configure Dictionary as shown in below picture,

 

 

Details of that field will be displayed as shown in below picture,

 

 

To add new column to a Table ,Right click on the required form, click on Configure -> Dictionary as below,

 

 

Click on New to create new field on the following form,

 

Clicking on New Button ,Following form will be displayed where we can create fields of different types.

 

 

e.g  create a State field of Type String as shown in below picture,

 

The new field can be seen in the table as below,

 

 

 

Choice Type Example :

Lets convert the State field to Choice Type. Right click on that field, Click on Configure Dictionary, as below

 

 

 

State field in Dictionary Entry will be displayed.

In below Section, Choice List Specification, Select Dropdown with None as a Choice ,as shown below,

 

 

Save the changes as below,

 

 

To add values in that dropdown ,

Click on Choices Tab in below Section, Click on New Button, as shown in below picture,

 

 

The following form will be displayed after clicking on New Button.

 

The List can be seen in the Dropdown as below,

 

 

Dependent Field :

This field is dependent on another field in a table.

e.g  City depends on State

 

 

In Dictionary Entry for City , assign Dependent field as below,

 

 

We need to set Dependent Value also, as shown below,

 

 

  Now, If we select Maharashtra state, Cities from Maharashtra only displayed in City dropdown., as shown below

 

Similarly for other state,another cities are displayed.

 

You can use existing Choice table also to display the List.

 

 

Reference Field :

Field refers to another field.

 

 

The Reference field User will be added to the form as below,

 

 

You can select any user from a list of users from sys_user table by clicking on magnifying glass next to User as below,

 

 

After selecting a record, Display Value of that table (Reference table) will be displayed as below,

 

 

 

 

Display Value :

This Value is a representation of that record in a reference field that is for whole table.Therefore

there will be only one Display Value for a table. If there are more than one display value for a table then the updated value will be set as Display value.

 

 

 

Clicking on Open Record button , the entire record can be seen as below,