Chapter 1
Create your first form
Last updated
Was this helpful?
Create your first form
Last updated
Was this helpful?
In this chapter, you will create your first Form in the new Solution, connect it to a data source and add some fields and labels.
Forms
Components and data-bound fields
Value Lists and Type-Ahead lookups
Labels and data-driven text
Formatting (Dates)
The NG Client to preview and test
Publishing to Servoy Cloud
Create your first form by right-clicking the forms node in the Solution Explorer and select Create New Form.
Enter "orders" for the name. Select a datasource. Choose the orders table in the example_data database and click OK.
Choose the default values for the remaining properties and click Next.
The next section of New Form Wizard is to optionally place data providers (data-bound fields) on the form. Components can be placed on a form at any time, but in this tutorial, we'll take advantage of this wizard, when creating the form, to quickly get some fields an labels.
You'll see a list of data providers for the example_data.orders data source. We will choose from this list in a moment, but first, click the Advanced Configuration button to get more options.
Here we can configure a few options about which components to place for different data types, as well as default sizes and spacing. We can also choose to place labels and more.
Choose the following values to control how the fields are placed.
Next, you are ready to choose the data providers that will be placed on the form. Choose the following data providers and click Finish.
customerid
employeeid
orderdate
The Form Editor should open and you should see a form having the fields that you selected.
To see the form orders as the first form in your solution, you must set it in the firstForm property of your solution.
To set your solution firstForm property, click on the solution name in the Solution Explorer. In the properties view, this will show all the properties of the solution you just clicked.
Double click on the property firstForm, select the orders form and click the Ok button to save your changes.
The first form of the solution is now set and you are ready to run your solution.
Your solution will open in the default browser and you can see that the form is populated with data from the first record in the orders table.
Besides viewing the solution locally, you can also publish it to Servoy Cloud and view it in the browser, as a web application.
You must click the publish button every time you want to update your cloud application.
It may take a few minutes for changes to take effect.
For immediate results, run your solution locally.
To view your web application, use the link generated when you created your namespace with the format https://yoursolution-dev.yournamespace.servoy-cloud.eu or using the Cloud Control Center:
Using the side menu, go to Project Overview > Applications
Click on your application
Click the button Launch in ServoyCloud
Nice Work! It may not look like much, but you've created a web application, which connects to and queries your database and loads data in a form. Let's keep going and enrich the form a data labels and value lists.
In this step we will add a Value List to allow the user to choose values from other database tables. The form currently displays two fields, employeeid and customerid, both of which are foreign key columns to related tables. Therefore, the current display of the raw values is not so nice.
Let's use a Value List object to show more meaningful information about those foreign entities and allow the user to choose related records. To do this, we will delete the two fields and replace them with Type Ahead components, bind them to Value Lists.
Start by deleting the customerid field (we'll leave the label). Select the component on the Form Editor and push the del key (or right-click the component and select Delete).
Locate the Type Ahead component in the Pallet and drag it onto your form, positioning and sizing it accordingly below the customer ID label.
In the component Properties Editor, double-click the dataProvider property to open the Data Provider Chooser. Select the customerid column.
In the component Properties Editor, double-click the valuelist property to open the Value List Chooser. Click the button to Create New Value List. Enter the name customers and click Finish. (Click OK to dismiss the Value List Chooser.)
Now that you have created the Customers Value List, you are ready to edit its properties in the Value List Editor. This editor should have opened upon creation of the new Value List.
Select the Value List type by choosing the Table Values radio option. This option specifies that the values will be queried from a data source table.
Click the ... button to open the Data Source Chooser the data source for the Value List. Select the example_data.customers data source and click OK.
Choose the companyname data provider to "show in field / list". This is the value that will be used to render instead of the real value.
Choose the companyid data provider to "return in data provider". This value will not be displayed. Instead it is the value that will be stored in the target data provider / field.
You can see that the customerid is now hidden and the customers.companyname field is shown instead. Moreover, when you edit the Type Ahead field, your results will match on records in the table based on the companyname but the correct value will be stored in the orders.customerid field.
Let's create one more Value List for the employee connected to the order. This time we will create the Value List first then bind it to the employeeid field.
In the Solution Explorer, right-click the ValueLists node and select Create Value List. Enter the name employees for your next Value List. This will open the new Value List in the Value List Editor.
Follow similar steps as you did for the customers Value List. Set the data source to be example_data.employees. This time we will set multiple display values, using both firstname and lastname for the display. Use employeeid for the real value.
Delete the employeeid Text Box from the form and similar to the customer field, drag a Type Ahead component from the pallet to replace it. Set the dataProvider value to employeeid and this time, when you set the valuelist property, you will choose the employees Value List that we just created. Save your editors and preview your changes in the NG Client.
You can see that because we specified two display values, the employees value list shoes both firstname and lastname. Moreover the lookup will query both columns to match values!
In this section, we will quickly edit some of the labels that we have already placed, then we will explore how to add more data-driven text.
The labels for each of the fields defaulted to the name of the database column, which is rather ugly. Let's quickly update those labels to something nicer.
To edit the content of the label, simply double-click the label in the form editor and begin editing the text.
In Servoy, any text can be data-driven and localized. Let's place a label that shows some plain text mixed with merge tags.
Drag a Label component from your pallet onto the form.
Select the text property of the label click the ... button to open the Text Property Editor.
Enter the literal value "Order #" then use the data provider chooser to append the orderid column to the text, giving the value: Order #%%orderid%%
Edit the styleClass property, selecting h2. This will change the style of the label. (We will cover more on styling in a later chapter)
Save your changes and preview the results in the NG Client. You can see that the %%orderid%% tag was merged with the data value from the record.
In the final section of this chapter, we will see how to format data values, in this case, we'll set a format for the orderdate field.
Select the orderdate field on the form and select its format property, then click the ... button to open the Date Format Editor.
Edit the Display Format. Enter yyyy-MM-dd (or a format of your choice). This will format the value when it is being displayed.
Select the Use as mask option for editing. This will allow the user to just enter the value digits and not the separator.
Click OK and save your form editor and preview in the NG Client. You can see that the date is formatted and the user can enter with masking.
Servoy Developer comes with a built-in instance of the NG Client to preview, test and debug your solution at any time during development. To launch the client, click the icon.
To publish your solution to Servoy Cloud, click the icon.
Login into Cloud Control Center using the credentials set up in
Click the Save All button (or ctrl+shift+s) to save all your editors. Navigate back to your NG Client running in the browser and preview the change.
