Web Form: Text Question Type with Special Formatting

The "Text" Answer Type allows you, the Form's designer, to permit the form filler to enter text as a response to a question.  The text can be formatted for special functionality in SchoolFi.  The formats are:

• Free Form Text {no formatting, raw text}
• Integer {whole numbers}
• Decimal Values {numbers with the number of decimal places as stipulated}
• Money Values {always 2 decimal places, rounded)
• E-Mail Addresses {user@domain.com}

In addition, the web form can include a type of "Sum of Answers" and the web form can total text answers that utilize the same special functionality.  This is limited to Integer, Decimal Values or Money Values.  

How to utilize this feature in a Web Form

The following illustrates how to utilize the Text answer type with the Money Values special functionality in conjunction with a total that is calculated by SchoolFi for a Professional Development Reimbursement request form.  In addition, we will utilize an expression to multiply the # of miles times the reimbursement rate to calculate the Mileage amount.

Here is a sample web form.  The blue highlights will utilize the Text answer type  with the Money Values special functionality, the yellow highlight will utilize the Text Box answer type  with the Integer special functionality to calculate the Mileage, the red highlights will will utilize the Read Only Expression answer type and the purple highlight will utilize the Sum of Answers answer type.

The sample Web Form can be downloaded from the library if you would like to copy and paste the information into your web form as noted in: Employee Forms Library: PD Request form sample for Text Question Type with Special Formatting

How to create the questions in the Web Form:

The staff member will enter the amount requested for each respective category.  The question will utilize the Text Box answer type  with the Money Values special functionality (blue highlights):

To calculate amount of mileage reimbursement, the staff member will enter the number of miles and the system will calculate the dollar value of the mileage reimbursement.  The question will utilize the Text Box answer type  with the Integer special functionality (yellow highlights):

To calculate amount of mileage reimbursement (assuming a mileage reimbursement rate of $0.47 per mile), the question will utilize the Read Only Expression answer type  with the following MACRO in the Expression field (red highlights).  Please ensure you replace CODE with the question CODE that is utilized for the number of miles (yellow highlights)

${rw:multiplyBigDecimal(formAnswersByCode['CODE'].bigDecimal, rw:toBigDecimal('0.47'))}

The Total Requested utilizes the Sum of Answers answer type.  The Question codes to sum are extracted from each of the CODES from a blue highlighted question (red box below).  Please note that the CODES are separated by a comma and there are NO spaces before or after the comma.  Lastly, the display format is set (purple box below).

What does the Staff Member see in their Portal?

This is what the employee will see in their employee portal when they are completing the form:

And when the Save button is selected, SchoolFi will all up all of the fields whose CODE was included in the question.

And when the # of miles is entered into the form, the system will calculate the mileage by multiplying the # of Miles times the District's reimbursement rate.

The Mileage is calculated and the Total Requested is updated when the Save button is hit.