Home
Building applications
The following topics contain information on how to build and efficiently use applications in HCL Domino Leap.
Adding formulas to your application
Use formulas to assign values to items on an HCL Domino Leap form or app page. They are divided into two categories: Item Formulas, which list formulas created from the Properties panel, and General Formulas, which list complex formulas created from the Settings tab.
Creating a Formula from the Properties panel
You can set a formula on a form or app page item using the Properties panel. The following instructions describe how to open the Formula editor and select formula options.

Building applications
The following topics contain information on how to build and efficiently use applications in HCL Domino Leap.
- Creating an application
  This topic gives a general overview of the application creation process, from opening the Domino Leap interface to launching a completed application.
- Creating an application from an excel spreadsheet
  Domino 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.
- Moving items in an application
  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.
- Copying items
  Items may be copied from one form to another form within any application.
- Creating an accessible application
  When you create an application, the following information helps you make it accessible for users with disabilities.
- Enabling dynamic layout
  When you build applications, you can now set the display width of your Domino Leap application. Setting this feature reduces or removes the need for horizontal scrolling when you have an unknown or limited amount of space.
- Globalization features
  The following information describes the languages formatting features supported by Domino 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 or app page. You can create composite rules that govern how your form or app page - and the data in it it - 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 services into your applications
  The following topics describe how to incorporate services into your Domino Leap application.
- Adding formulas to your application
  Use formulas to assign values to items on an HCL Domino Leap form or app page. They are divided into two categories: Item Formulas, which list formulas created from the Properties panel, and General Formulas, which list complex formulas created from the Settings tab.
  - Creating a Formula from the Properties panel
    You can set a formula on a form or app page item using the Properties panel. The following instructions describe how to open the Formula editor and select formula options.
  - 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 items
  You can use specialized form or app page 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
- Domino Leap document integration
  HCL Domino Leap's document integration feature lets you use previously built PDF files and populate them with data captured by Domino Leap in a Domino Leap form.
- 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 responses
  After a Domino 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 panel

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

About this task

You must set the formula on the form or app page item that stores the result. For example, to add two numbers, 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 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 item - the Properties panel appears on the side of the screen for the selected item.
Click the Formula tab in the Properties panel.
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 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 or app page.
- 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 an 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 an 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 an item.

Results

Save and preview your form to test the formula.