Totaling a Grid Column in Job Manager/Virtual Ticket
MetaScript can be used to total grid columns in Virtual Ticket and Job Manager printing forms. This type of calculation can be useful when attempting to get a total for a column of prices.
The provided example is an Order Acknowledgement form which contains a grid. A variable field on the form named aTotal contains a MetaScript calculation to total the contents of the Price column. The Order Acknowledgement can also be found in a standard sample database.
To view this example perform the following:
- Download the example.osf file.
- Import the form using Virtual Ticket or Job Manager.
- Open the form in the Forms Editor.
- Double-click on aTotal to view the MetaScript calculation.