Modules are the sub sections of the screen where the input fields are placed. User can add rows and columns in module based on their respective designs. User can drag and drop the required fields inside module layout to create the desired form. The module configuration provides a list of features to include in an entity. One module is mapped to one table in the database. Module configuration require user to specify the database table name, table keys and sequences of the associated table. It also provides an option for user to write manual SQL queries to retrieve values from the database using some alternate logic.
AppDesigner supports 3 types of modules:
1-1 Module
1-Many Module
Reusing Module
The 'Reusing module' allows user to reuse modules existing in other entities and copy to your smart form. It saves the work for the designer when they have to create very similar modules. The Module Configuration of a Reusing Module is same as that of 1-1 or 1-Many Module configuration depending on the type of module copied. Only the way of creation is different.
(1-Many) module displays and manages data fields for multiple records in the database. It shows data in tabular form. The One to Many (1-Many) module is based on grid and card layout design and allow users to handle large num1-1 module displays and manages data for one record in the database. It is based on row and column layout where you can simply add rows and columns as per your required design. Simply drag the 1-1 Module icon to the desired Tab to create a 1-1 Module.
The 1-1 Module configuration provides a list of property settings (1-5) as shown below:
- This icon is used to open "Module Configuration" property window. 1-1 Module configuration property window provides a list of settings which can be helpful in specific needs or special purposes. All 1-1 Module configuration settings along with their usage are listed in table below:
Module Item
Default value
Mandatory
Description
Module ID
N/A
Y
Module ID is the unique ID and it is generated by system automatically.
Module Name
1-1 Module
Y
The appropriate name for a module.
Table Name
N/A
Y
The table associated with that module.
Template Code
Responsive2016
Y
Default to same as template Code used for an Entity.
Theme Code
Responsive2016
Y
Default to same as theme Code used for an Entity.
Show List Layout
GRID
Y
Show Grid Layout / Card Layout for the search result.
Module Key
N/A
Y
This is set the field to be used as the Key to the Module.
Prefix
N/A
This is used to configure prefix that will be added to the beginning of the Key when automatically generated.
Postfix
N/A
This is used to configure suffix that will be added to the end of the Key when automatically generated.
KeyLen
N/A
Y
Key Len is to set size of key.
Sequence
N/A
Y
Database Sequence to be used for key generation.
SQL Show List
N/A
This is used to set the manual SQL Command used to query data to display in Module in Tabular Format (Only used in 1- Many Modules).
SQL Work Queue
N/A
This is used to set the manual SQL Command to query data to display in Search Results.
SQL Select Row
N/A
This is used to write the manual SQL Command to be used to query data in 1-1 Module.
SQL Duplicate Function
N/A
-
View Mode Flag
N
Make your module in View/Read Mode only.
Paging Flag
N
Enables paging for search result.
Ordering Flag
N
Enables sorting in the headed of data grid.
Multiple table Flag
N
-
- This Icon is used to drag and drop modules to rows and columns in Multi Column Tab Form layout.
- This Icon is used to set the Column Layout which determines how many columns the module has. It has 3 options to choose from - 1 Column, 2 Column and 3 Column. User can select any options based on the layout requirement. User must click on 'Accept' button after choosing a desired option.
- This Icon is used to delete a Module from your Smart Form Layout.
- This Icon is used to add column or row inside your Module Layout. First Icon add Column in your module and second icon is used to add row. User can add multiple rows and columns inside module Layout on basis of smart form requirements.
1-Many) module displays and manages data fields for multiple records in the database. It shows data in tabular form. The One to Many (1-Many) module is based on grid and card layout design and allow users to handle large number of items and columns.
The 1-Many Module configuration provides a list of property settings with 2 icons as shown below:
- This icon is used to open "Module Configuration" property window. 1-Many Module configuration property window provides a list of settings which can be helpful in specific needs or special purposes. All 1-Many Module configuration settings along with their usage are listed in table below:
Module Item
Default value
Mandatory
Description
Module ID
N/A
Y
Module ID is the unique ID and it is generated by system automatically.
Module Name
1-Many Module
Y
The appropriate name for a module.
Table Name
N/A
Y
The table associated with that module.
Template Code
Responsive2016
Y
Default is set to same as Entity Template. No Edit Required.
Theme Code
Responsive2016
Y
Default is set to same as Entity Theme. No Edit Required.
Show List Layout
GRID
Y
Select GRID Layout or Card layout for the list for 1- Many.
Module Key
N/A
Y
This is set the field to be used as the Key to the Module.
Prefix
N/A
This is used to add to configure Prefix that will be added to the beginning of the key when automatically generated.
Postfix
N/A
Used to configure suffix that will be added to the end of the key when automatically generated.
KeyLen
N/A
Key Len is to set size of key.
Sequence
N/A
Y/N
Database Sequence to be used for key generation.
SQL Show List
N/A
This is used to set the manual SQL Command used to query data to display in Module in Tabular Format (Only used in 1- Many Modules).
SQL Work Queue
N/A
This is used to set the manual SQL Command to query data to display in Search Results. Only for 1-1 Modules
SQL Select Row
N/A
This is used to write the manual SQL Command to be used to query data in 1-1 Module. Only used in 1-1 Module.
SQL Duplicate Function
N/A
-
View Mode Flag
N
Set your module in View/Read Mode only.
Paging Flag
N
Enables paging for 1- Many Module.
Ordering Flag
N
Enabled sorting in the header of data grid.
Multiple table Flag
N
-
- This Icon is used to delete a Module from your Smart Form Layout.
