#framework BAT

Process All Invoice Records

This page uses a Hashtag List for all Invoice records, an Update Record command in the Row Template calculates and sets new values using math expressions.

Processed this Hashtag Markup:

<# start list for invoices; #>

<# start row #>
<# update record for "invoices.<# invoices.id #>" reference as "updated";
	set updated.status to "processed";
	set updated.subtotal to <# invoices.qty #> * <# invoices.each #>;
	set updated.tax to <# updated.subtotal #> * .10;
	set updated.total to <# updated.subtotal #> + <# updated.tax #>;
	round updated.total to 2 decimals;
#>
<# end row #>

<# end list #>

The updated records should now appear in this List of Invoice records
Form for adding a New Invoice record
Create New Invoice Record

The Invoices Mini-App uses the Hashtag Markup Language to demonstrate methods for processing records.

Invoice records are stored in an SQL database. The Process example uses math expressions for multiplication and rounding to currency standards.

List Templates
Update Record Command
Request Variables
Context - HTML