Home
Creating and managing applications
Creating and managing applications contains a variety of topics on how to build and efficiently use applications.
Adding formulas to your application
You can create and edit formulas to assign values to an item on your HCL Leap form.
Creating a Formula from the Properties side panel
You can set a formula on a form item using the Properties side panel. The following instructions describe how to open the Formula editor and the formula options available.

Creating and managing applications
Creating and managing applications contains a variety of topics on how to build and efficiently use applications.
- Creating an application
  This topic gives a general overview of the application creation process, from opening the HCL Leap interface to launching a completed application.
- Creating an application from an excel spreadsheet
  Leap allows you to create an application from an excel spreadsheet, automatically creating the widgets and importing the data found in the spreadsheet.
- Styling your application with a custom theme
  Style the colors, fonts, and other characteristics of the application by creating or importing a custom theme.
- Copying items
  Items may be copied from one form to another form within any application.
- Moving items on a form
  Form items are not static after they are added to a form. You can move items around on a single page, duplicate form items, and move items between pages on your form.
- Creating an accessible application
  When you create a form or application, the following information helps you design an accessible form for users with disabilities.
- Enabling dynamic layout
  When you build applications, you can now set the display width of your Leap application. Setting this feature reduces or removes the need for horizontal scrolling when you have an unknown or limited amount of space, such as when the application is displayed in a WebSphere_Portal portlet.
- Globalization features
  The following information describes the languages formatting features supported by HCL Leap .
- Creating rules in your application
  Rules help you gather the correct information from users and organize your information after data is entered in a form. You can create composite rules that govern how your form, and the data in your form behaves.
- Labeling data, performing data analysis, and exporting data
  You can add labels to data elements in your application that become the label in the export file.
- Incorporating web services into your applications
  The following topics describe how to incorporate web services into your HCL Leap application.
- Adding formulas to your application
  You can create and edit formulas to assign values to an item on your HCL Leap form.
  - Creating a Formula from the Properties side panel
    You can set a formula on a form item using the Properties side panel. The following instructions describe how to open the Formula editor and the formula options available.
  - Creating a formula from the Settings tab
    The Settings tab contains a Formula section from which you can view and create formulas.
  - Running a formula from an event
    After you add General formulas using the Settings tab, you can use the formulas when running events. For example, you can set a formula to run when a user clicks a button.
- Adding specialized form items
  You can use specialized form items to style text, echo text back, create dynamic lines, or add HTML.
- Managing the files associated with your application
  You can upload a variety of files, such as images, for use with your application. Managing these embedded files is done in the Files section of the Settings tab
- Leap document integration
  Leap's document integration feature lets you use previously built PDF files and populate them with data captured by Leap.
- Adding Stages to an application
  It is often desirable to have an application, or form, transition through a set of phases or stages. At each stage the form might be used by different people in different roles. The form also might be presented in a slightly different manner in each stage, such as having some items or pages hidden, or in a read-only state.
- Deploying applications and viewing data responses
  After an HCL Leap application is built it must be deployed. After it is deployed, you can supply users with the URL of the application so they can launch it. After users submit completed forms, you can view the responses.

Creating a Formula from the Properties side panel

You can set a formula on a form item using the Properties side panel. The following instructions describe how to open the Formula editor and the formula options available.

About this task

You must set the formula on the form item that stores the result. For example, if you want to add two numbers together, set the formula on the field where you want the result shown.

Note: If you are creating a formula to assign a string value to a Time form item, the content of the string must be based on a 24-hour clock. If the input value is not in a valid 24-hour clock format, the resulting value will not be correct.

Procedure

Select the form item.
The Properties side panel opens.
Click the Formula tab.
Select the function from the list of available options.
The available options are:
- Add – Adds two values together.
- Assign – Assigns a value to the specified form item.
- Table Average – Calculates the average column value of a table.
- Concatenate – Concatenates two values together into a single string.
- Power – Raises power of one value to another value.
- Table Max – The maximum column value of a table on the form.
- Multiply – Multiplies two values together.
- Minus – Subtracts one value from another value.
- Table Sum – The sum of a column of a table.
- Table Count – The number of rows in a table.
- Divide – Divide one value by another.
- Table Min – The minimum column value of a table.
After you select a function, input areas and a result area are shown.
Click the Input 1 field.
- Select a form item from the list.
- Click Or, Enter a Number. Enter a number in the Value: field, and click OK.
Click the Input 2 field.
- Select a form item from the list.
- Click Or, Enter a Number. Enter a number in the Value: field, and click OK.
Note: If your formula contains errors, an error icon is shown. Ensure that a formula is free of errors before applying it to a form item.

Results

Save and preview your form to test the formula.