Drop Down Box

If the selection made in the Field Style field is SQL Query, the field here will change.

Dynamic values can be sent to the drop down box with the query. During this submission, two fields (values) must be sent while writing the query. The first value is the value that will be kept in the database and the second value is the value that the end user will see when he/she clicks on the drop down box tool on the Client screen. If two values are not sent, Not Data Found will be displayed and no result will be returned.

Data Text Field: This is the section where the field containing the information to be displayed to the user when the drop down box tool is clicked on the Client screen from the query in the drop down box tool is written. 
Data Value Field: From the query in the drop down box tool, when the drop down box tool is clicked on the Client screen, the field containing the value to be saved in the database is written. 
Tab Order No: Specifies the order of the form tool on the tab key. 
Multiple Selection: Allows multiple selection among the values in the drop down box. 

 

The selected values are separated by commas in the database. For example, the information that will be stored in the database when Belgium and Denmark are selected and saved: Belgium, Denmark  When using the Multiple Selection feature, records of nvarchar data type are added to the database. For this reason, the Text option can be selected from the format section or the format section can be left blank. When the format section is left blank, the system creates the data type of the related field as nvarchar by default.  Since the data to be kept in the database may be long when the Multiple Selection feature is used, the Table Length value, where the length of the field to be created in the database is entered, can be written high. A maximum value of 4000 can be entered.

Fit Horizontal: Fits the form tool horizontally to the full screen on the user's screen. 
Pin Right: Pins the form tool to the right. 
Display: Makes the form tool not visible on the Client screen. 
Form Only: Allows the information entered in the form tool to be created only in the form by not saving it to the database. Subsequent changes made here do not affect the database. 
Auto Fill: When the form is opened on the client screen, the query in the drop down box runs in the background and fills the data in the drop down box. When the user clicks on the drop down box tool, they can directly view the data in the drop down box. 
When this feature is off, when the user clicks on the drop down box tool, the query in the drop down box runs and the returned data is displayed. 
Selection Compulsory: If this feature is on, it becomes mandatory to select one of the options in the drop down box. If the user tries to enter a value that is not defined in the drop down box, the system automatically deletes this value and displays the drop down box with the first option selected. 
Actions that can be used in the Drop Down Box tool 
There are different actions for each added form element on the form page. The actions defined for the Drop Down Box tool are as follows.

On Focus: It works when the mouse is clicked into the drop down box or when the enter keys are pressed from the keyboard.

On Blur: It works when another element is passed through the drop down box.

On Value Change: It works when the value inside changes.

Keyboard Input: Works when any operation is done with the keyboard.

Validation: When the value inside the drop down box changes, it is used to check the value

Icon Clicked: If an icon is added to the form tool, it works when this icon is clicked.

Template

To add a template to the drop down box form tool, first select the drop down box form tool and then click on Add Customization (No:3) on the drop down box.

On the left side of the screen, under the drop down box form tool, the Template screen will be displayed as added and the Template screen will appear. Drag and drop the necessary components to the Template screen as shown in the image below. 
In order to show the UserID and UserFullName data in the SQL query in the SQL Query section of the Drop Down Box form tool in the template property, let's drag and drop four Label form tools to the template area and name them. Two of these four Label tools are headers and the other two are the fields that we will use when pulling the data from the table. For this reason, after writing ID, Name in the first two Label tools, let's write $PUserID$ and $PUserFullName$ (in $Pxxxx$ format) (No:8, No:11) in the Label tools we added opposite them. The final version of our Template tool will be as follows. 
Template Field fields must be filled in for the fields from which we will extract data. Otherwise the template feature will not work.(No:9,No:12) 
The Value option has been selected for the SQL query in the SQL Query section of the SQL Query section of the Drop Down Box form tool, since a numeric value such as $PUserID$ in the XPODA_CLIENT_USERS table will be displayed. (No:9) 
For the $PUserFullName$ Label field, the Text option has been selected because it returns a textual value result such as First Name Last Name from the XPODA_CLIENT_USERS table.(No:12)

If the Field Type property of the drop down form tool is selected as 'Multiple Column', the Column Name field in the 2nd image should be filled in order for the system to understand which column to create a template for.