A simple list

In this learning path, you will learn how to build a simple product list with the ability to add new elements and edit existing ones.

Below is the material presenting the resulting functionality.

Issues presented in the current article

DATA STRUCTURE Building a data structure Adding fields to the data structure Updating data structures Building relations of data structures	LIST Building a list List properties Actions on the list Adding list items (elements) Editing list items (elements)
FORM Building the form Form Toolbox Actions on the form Popup window configuration Modifying the appearance of an action	DICTIONARIES Defining the dictionaries Using a dictionary on the form and the list Updating dictionaries in database

STEP 1 - DATA STRUCTURE

In this step:

1. You will create a data structure of product
2. You will add the following fields: name, quantity, price, currency
3. You will update the created structure in the database
4. You will check the presence of the structure in the database

STEP 2 - LIST

In this step:

1. You will create a list of product
2. You will use a SQL query to fill data into the list
3. Based on the data structure, you will automatically generate the list column s
4. You will set the column names and the title of the list
5. You will display the list in the browser

STEP 3 - FORM

In this step:

1. Based on the previously created data structure, You will create the products form
2. You will build it based on the form's data structure
3. Based on the data structure, you will automatically generate the list columns
4. You will display the form in the browser

STEP 4 - ACTIONS (ADD ELEMENT, SAVE)

In this step:

1. You will define the action A dd element on the list
2. You will parameterize the popup window for the above-mentioned action
3. You will define the action Save on the form
4. You will add the first products to the created list

STEP 5 - ACTION (GO TO THE FORM)

In this step:

1. You will add an action column to the list
2. You will define the action Go to the form (EDIT)
3. You will modify the appearance of the added action and embed it in the list record
4. You will modify previously added products in the finished list

STEP 6 - MENU

In this step:

1. You will define a menu object for the application
2. You will add a menu item navigating to the list

STEP 7 - DICTIONARIES

In this step:

1. You will define the dictionary element
2. You will add the dictionary field to the data structure
3. You will use the update dictionaries database tool
4. You will use the dictionary field on the form
5. You will define a column on the list that will display dictionary values

STEP 8 - RELATIONS

In this step:

1. You will define a relational element in an existing structure
2. You will use the update structure in database tool
3. You will add a relational field to the initial mappings of the form
4. You will use the relational field on the form
5. You will define a list column that displays the related relational item