This action is used when you want to open another form from another project or from the same project. This form is linked to other forms. It is the type of action that opens the detail field of the record by double clicking on the record in the form tool named List added to the form.
Open Form- Detail Action in Property Panel
Properties
Condition: Specifies how to open the new form.
In new window: Opens in new window
Note: In New Window option must be selected as a condition for this action to work properly.
Description: Description of the action is written. This description is used to give reference to the developer.
Form Title: The title added to the form to be opened.
Form Width: Determines the width of the form to be opened.
Form Height: Determines the height of the form to be opened.
Module: Select the project of the form to be opened. If you want to switch to a different form page within the same project, this field can be left blank.
Form: Select the form page to be opened.
Linked List: Displays the details in the list.
ListID Field: The ID information in the main form matches the ID information of the list to be opened.
ListType Field: The form type information in the main form matches the form type information of the list to be opened.
Closing Action: When the opened form is closed, the action in the form is selected for the action to be taken.
Fullscreen: Select whether the linked form will be opened fullscreen or not.
Run Condition: If the value in the query entered in this field is ‘0’, the related action will not run.
Request Confirmation: Select whether you want to ask for confirmation before running the action. If Request Approval is active, the Approval Message feature is opened and the message to be displayed when requesting approval is written.
Example 1
Let's create two forms to use in our example. We will add form tools to our first form where we will enter our records. First, let's create a form where we will save our data. This form will have three Text Box and three Figures Box fields. Let's name these fields as in the image below.
First of all, let's create our form where we will upload the records as below and enter our records.
Let's add a list tool for the second form and add the table query of our first form to the list. Then double click on the list widget and add the action. The important point here is the UserTableID field of the SQL Query in the list. If you type UserTableID in the query for the List-ID field of the action, the new screen will show all the information about this UserTableID. Therefore, the UserTableID field must be present in the query. The final version of the action we added to the list will be as follows,
Studio view of the action added to the list
Double clicking on the list for the second data will open the other form page linked to the list showing the details of the record.
List status of the form on the Client screen
Example 2
In this example, we will consider the case where more than one form reports. In these cases, UserTableID and FormTypeID must be present in the action and list query to know which form the relevant record is in.
In our example, let's add a list widget with the data we want to list and two buttons to load data by clicking. When the buttons are clicked, the desired information will appear in the list and when any record is clicked, the detail of the record will open. Since this record comes from different forms, UserTableID and FormTypeID must be in the content of the action to determine which form it belongs to.
Then let's create two forms with our Products and Customer information. Then let's add these forms to both forms we added to our report form with the Update action.
Let's add our action to the button where we will show our Customer table as below.
Type of action: When clicked
Operation: Update Value
Value Area: GridListe_1
SQL Query:
SELECT
OFD_CUSTOMER_FORM.UserTableID, FormTypeID,
OFD_CUSTOMER_FORM.Customer_ID AS [Customer ID],
OFD_CUSTOMER_FORM.Customer_Name AS [Customer Name]
FROM dbo.OFD_CUSTOMER_FORM WITH (NOLOCK)
In the same way, let's add our action to the button where we will show our Products table as below.
Type of action When clicked
Operation Update Value
Value Area GridListe_1
SQL Query
SELECT
OFD_PRODUCTS_FORM.UserTableID, FormTypeID,
OFD_PRODUCTS_FORM.Product_ID AS [Product ID],
OFD_PRODUCTS_FORM.Product_Name AS [Product Name]
FROM dbo.OFD_PRODUCTS_FORM WITH (NOLOCK)
Let's save and go to the Client screen with the Run button and check if the data is coming by pressing any of our buttons. Our list will look like below.
When we double click on any record in the list, our detail screen will open as below.