Livecycle

Performing a calculation in the Amount column

The Amount column must show the number of items ordered multiplied by the unit price. You perform calculations in LiveCycle Designer ES using FormCalc or JavaScript. We will use FormCalc for this calculation. FormCalc is a simple yet powerful calculation language modeled on common spreadsheet software. Its purpose is to facilitate fast and efficient form design without requiring a knowledge of traditional scripting techniques or languages. You use the Script Editor to enter calculations for the different objects on the form.

1.	If the Script Editor is not already showing, select Palette > Script Editor.

2.	If you want, drag the Script Editor palette bar until the palette is larger.

3.	Select the cell under Amount.

4.	Select Calculate from the Show list.

5.	Select FormCalc from the Language list and Client from the Run At list.

6.	In the Script Source field, type the following calculation:

quantity * unitPrice

7.	Deselect the cell to add the script to your form.

8.	To set this column as read-only, select the cell again, then in the Object palette, click the Value tab and select Calculated – Read Only from the Type list.

Click to continue: Adding rows to the purchase order table

Performing a calculation in the Amount column