(Example) Create a Formula to Calculate the Total Hours Requested for the Create Absence Request eForm

To design the Total Hours Requested formula form control for the Create Absence Request eForm, do the procedure in this topic.

How to Start

  1. (Example) Create a Process-Based Application for an Absence Request.
  2. (Example) Start an Absence Request Process with an eForm.
  3. (Example) Configure the Form Settings for the Create Absence Request eForm.
  4. (Example) Set Columns for the Create Absence Request eForm.
  5. (Example) Configure the Total Hours Requested Formula Control for the Create Absence Request eForm.

Procedure

  1. On the Form Control Quick Menu, click Formula Formula icon.

    Formula
  2. The Formula Builder screen shows.

    Formula Builder screen
  3. In the Formula field, enter this formula. 
    sum( ${LeaveDetails/Hours:[*]})

    Enter the formula
  4. To make sure the formula is correct, click Validate.

    Validate
  5. Click OK.
  6. The eForm Builder shows the Total Hours Requested formula field for the Create Absence Request eForm.

    Create Absence Request