Stepper

 

It is an Xpoda tool for visualizing the structures to be displayed step by step in the form.

 

 

Compatibility

 

Features

Type: Shows the field type of the added form tool. The value here cannot be changed.

Name: The name of the field to be created in the database is written.

Info Text: Information about the added form tool is written.

Field Style: It is the field in which the Stepper tool will work in which way is selected.

Default Value: The value entered here defaults into the form tool on the Client screen.

Table Length: Edit the length of the form tool.

Text Size: The size of the values to be entered in the Date field is determined from this field.

Help Text: It is the text entered for the explanation to appear when the mouse hovers over the form tool.

Text Fonts: The text style is selected.

From Left/Top: Adjusts the position of the form tool.

Orientation: There are Horizontal-Vertical options in this field. It adjusts whether the Stepper appears horizontally or vertically on the client screen. (When no selection is made, it works with the default vertical selection.)

Linked Object: It is enabled to fetch a value from an object element created with the Create New Data Object action. When the object element runs, information is filled according to the object area.

Linked Object Area: Selection is made from the fields inside the linked object area.

Click here to go to Create New Data Object action.

Data Text Field:

Data Value Field:

 

Example

 

Let's open a new form of the Free form type and select the Type field as Report from the properties of the form. Then drag and drop the Stepper tool to the form among our tools on the left side.

In this example, since we will give a value to the Stepper tool with a SQL query instead of a fixed value, let's select the Field Style field in the properties of the tool as SQL Query and add the following query to the query field.

SELECT '1st Step '+convert(varchar, getdate(), 105),'',1 
UNION ALL
SELECT '2nd Step','',2
UNION ALL
SELECT '3rd Step','save',3
UNION ALL
SELECT '4th Step','',4

 

The 1st part of the SQL query is the text that will appear on the stepper, the 2nd part is the icon name (if there is no icon, it should be left blank), the 3rd part is the sequence number.

 

 

Note: 4 stepper steps are created in the SQL query. In this example, in SELECT '3rd Step','save',3, save is written in quotes and the 3rd stepper step is shown with the save icon in the client view.

 

After selecting the Orientation field as Horizontal, the image of our tool in the form will be as follows.

 

 

 

Let's save the form and before pressing the Run button, let's add an action to our form for the Stepper tool to run. First of all, let's select our form (Form_1 is selected in this example) from the area marked in red on the left side of the image below and go to the action tab from the red area on the right side and click the Add New Action button.

 

 

Since we will create an action that we want to be triggered when the form is opened, let's select the When the Form is Opened action in the Type of Action field. After selecting Update Value as Operation, select our Stepper tool in the Value Area field. The screenshot of the final version of our action will be as follows. Then click on the save button below and save our action.

 

NOTE: Saving the form does not save the action. To save the action, we need to save in the field where we created the action.

 

 

Then save our form and go to the client screen with the run button. The Stepper view on the client screen will be as follows.

 

 

The UserTableID of the step selected in the Stepper tool on the client screen can be shown in another field added to the form. For this, let's add a button to the form and update the stepper step with the action to be added to the button.

 

 

Let's drag the Text Box tool to our form to print the UserTableID and add a button to trigger it. Then select the Stepper tool and add an action. After pressing the Add New Action button, select On Value Change in the Type of Action field and Update Value in the Operation field. Then, after selecting the Text Box tool we added as Value Area, type the following SQL query in the SQL Query field.

 

SELECT '$PStepper_1$'

The final view of the action will be as follows.

 

NOTE: Saving the form does not save the action. To save the action, we need to save in the area where we created the action.

 

Then Run and go to the client screen. Select the step we want in our Stepper tool and observe that the UserTableID information comes to the Text Box field as in the image below.

 

 

 

 

To update the Stepper tool with the button we added to the form, let's go back to the studio and click on the button tool and add an action. Type of Action field will automatically be When clicked. Then, since we want to update the Operation field, let's select Update Value and our Stepper tool in the Value Area field. In our example, we added the following query to the SQL Query field because we want it to be updated to step 3 when the button is pressed;

 

SELECT '3'

The final image of our action will be as follows:

 

 

NOTE: Saving the form does not save the action. To save the action, we must save in the area where we created the action.

 

Then let's Run and go to the client screen and observe our new usage. When the button is pressed, we can observe that the stepper tool is updated to the 3rd Step step as follows.