Tutorial: Connections between applications

In this example we will be seeing how to make a connection between applications within the Dashboard.

Creating the Applications

1 – In this example, we will use 4 applications: A Grid using the order table, an order form, a second form, of the editable grid type, with the order items and finally, the Dashboard application that will join the other applications.

2 – Application 1: Order details form

2.1 – Create a new Form application of the type “Editable grid (view)” based on the table “order_details”

2.2 – In “edit fields”, we will select the following fields for display:

2.3 – Generate the source of the application.

3 – Application 2: Order form

3.1 – Create a new Form application of the “Single Record” type based on the “orders” table

3.2 – In “Layout >> Blocks“, we will create a new block and configure them according to the image.

3.3 – In “edit fields”, we will select the display fields and organize them among the available blocks:

2.3 – Generate the source of the application.

4 – Application 3: Grid based on the “orders” table

4.1 – Here we will use the application started by the search, activate the option “use iframe”, and leave only the search and grid modules active.

4.2 – In “edit fields”, we will select the following fields for display:

4.3 – In “Search>> Advanced search >> Select Fields”, we will make the following fields available:

4.4 – Now in “Application link“, we will create a new connection of the type “field“, using “orderid“.

• Select the order form application created in step 3 and associate the primary key parameter of the orderid field.

Creating the Dashboard

5 – Application 4: Dashboard

5.1 – After creating the form and grid applications, we will create the dashboard application.

5.2 – We will create 3 widgets. In the first, on the left, we will associate the Order Inquiry, in the second, on the right, at the top, we will call the Order Form application, and in the third widget, the Order Items Form.

5.3 – In the first widget, we will select the displayed application, the application it will be linked to, and which other widget this link will be executed in.

5.4 – We will do the same in widget 2.

5.5 – The third widget will be as follows:

6 – Now run the application.