You can enter constant values to this tool or values can be entered with the SQL query. When the box is clicked, the fixed values entered or the values received with the query of SQL are displayed in the desired order, allowing choosing.
Drop Down Box tool icon at Toolbox
How it looks like on the Canvas
Compatibility
| Free Form | Responsive Form | Mobile |
 |
 |
|
Properties
-
Name: The name of the tool is written. To edit, go to the Property Panel which is located on the right. This area is saved to the database.
-
Info Text: Information text is written about how to enter information within the tool in the Client-side. You can write your text in the Info Text area, to be information text in the Drop Down Box. This text will not be saved anywhere. It will appear visually.
-
Field Style: The Selection is made if data inputpwill be through constant or SQL queries. You can add your data as a Constant Value or SQL Query.
-
Default Value: The value entered here comes as the default into the tool. If you want to enter data as the default value, you can write in the Default Value part. It fills the drop-down box area on the client screen.
-
Table Length: The length of the information which will be saved to SQL is entered. At the same time, whatever first entered value in here, it transfers to the database. Check here before saving.
-
Text Size: Sets the size of the tool.
-
Minimum Characters: The minimum character value of information to be written is entered into a drop-down box.
-
Icon: You can choose from the Icon area, to add an icon to the drop-down box tool. You can change the color and location of the icon.
-
Text Fonts: To change the font of text in the tool, you can use the Text Fonts area.
-
Color: It arranges the interior and/or the text color of the tool. To edit the text color and background color of the text you can change from Color area.
-
Height / Width:. To adjust the location of the tool on the screen, you can edit the height and width area. (The width field has been removed from Responsive Forms).
-
From Left / Top: To adjust the location of the tool on the screen, you can edit from the left and top area. (This field has been removed from responsive forms).
-
Format: The format of information to be entered into the form is selected. You can edit it for your format from the Format area and it seems your format in the client and the database.
-
Linked Object: Action a connection element formed on an object. When the object element works, populated by the object area information. Linked Object field makes it seems an object element coming from the action. When the object element is running, this information is filled according to the object area.
-
Linked Object Area: The selection is made from the sections of the linked object field.
-
Values (Text * Value): The values of the selected drop-down box as the field style fixed value are entered.
-
SQL Query: The query of the selected drop-down box as the field style SQL query is written
-
Tab Order: It indicates the order of the tool within the form. On the Tab Order, when you skip with <TAB> key the cursor will proceed according to the line.
-
Multiple Selection: It provides the ability to write multiple lines into the tool.
-
Fit horizontal: It fits the tool into a full screen on the user's screen.
-
Pin Right: It aligns the tool to the right
-
Display: It ensures not to display the tool.
-
Form Only: It arranges only as in the form by not saving the information entered into the tool in SQL.
-
Auto Fill: When an old record is called, it is activated to write its value in the text field, not its value in the table.
-
Selection Compulsory: If this feature is No, a value other than the values in the box cannot be written to the drop-down box. If it is typed, it always brings the first value into the drop-down box.
Actions
-
On Focus: Assign an “Action” as on focus handler. For more information please click here.
-
On Blur: Assign an “Action” as on blur handler. For more information please click here.
-
When the value changes: Assign an “Action” as on value changes handler. For more information please click here.
-
Keyboard Input: Assign an “Action” as on keyboard input handler. For more information please click here.
-
Validation: Assign an “Action” as on value tool handler. For more information please click here.
-
Calculate: Assign an “Action” as calculate handler for grid tool. For more information please click here.
-
Icon Clicked: Assign an “Action” as click handler for the icon. For more information please click here.
Examples Used
If the Field Style area is Constant Value, you can write in your data to Values(Text*Value) area.
If you write in the values to this area, the values are saved as the same values to the database.
This screen below will be seen automatically after you focus on another area.
Otherwise, you can write the value part yourself, that is saved in the database.
In this place, the first parts seem on the client screen. The second part is saved in the database.
Client view on screen
Another example;
If the Field Style area in SQL Query, you can write a query from the database in the SQL Query area. Here, the first data are saved in the database. The second data seem on the client screen.
When a field style SQL Query is selected, information from any existing table in the database can be listed in the drop-down box. The important thing here is that what we need to choose two fields from the table in the drop-down box and the first field we write (UserTableID is the example) is saved in the database, and the second field we write (SectionName is the example) is the part that will appear in the drop-down box.
The query writing process can be done with Xpoda wizard without writing code. When the section marked red in the following screen is clicked, the wizard opens and the fields are included in the SQL Query with drag-drop
SQL Query Wizard
Clicking on the wizard opens the following field. Tables are available on the left. To withdraw from the required table, clicking on the desired area and drag to the area pointed by the red arrow on the left. Thus, the query is written in the field shown with the blue arrow. Click on the field pointed by the green arrow and save the SQL Query.
Report Builder screen from SQL Query Wizard
The result of SQL Query in Report Builder
Client view on screen
Another example;
A constant value can be exported from the Values (Text*Value) field in the drop-down box properties tab.
In the above two examples, the drop-down box gives fixed values. The drop-down box views on the client side are the same. The only difference between them is the value sections. The left side of the screen saves the values as 1 and 2, while the right side of the screen saves the values as woman and man on the database.
The modification in the Format area is affected by data types on the database.
Whether or not a SQL Query is requested in the drop-down box, or whether constant values are written, an important issue is how to register the drop-down box tool in the database. It is stored in the database according to the data type selected from the format field shown below. For example, when the format is selected as an integer, it will be stored in the database as int. If you want to pull a field of text type nvarchar data type in SQL Query in this drop-down box then the system will give us error and data will not be saved. In this chase, it is necessary to change the format of the field according to what is desired to be saved in the database. However, once the field is registered to the database, we need to replace the data type with the SQL code.
One thing that should be considered in the drop-down box added to the form is that if the selection is required only in the drop-down box, the selection is mandatory and after filling in the drop-down box with the keyboard, the auto-fill options should be selected as yes. The fact that these two options are active creates a more dynamic and accurate usage for the user.
If Multiple Selection property is Yes, you can choose the data more than one.
Client screen