• Example Mini-Apps
• Invoices
• Process

Process Invoices to Calculate Tax

Process Invoices - Update Record call in the Row Template of an Hashtag List for SQL Table - `Invoices`

Processing this Hashtag Markup:

<# start list for invoices; #>
<# start row #>
<# update record for "invoices.<# invoices.id #>" reference as "var";
	set var.status to "processed with math expressions";
	set var.subtotal to <# invoices.qty #> * <# invoices.each #>;
	set var.tax to <# var.subtotal #> * .10;
	set var.total to (<# invoices.qty #> * <# invoices.each #>) * 1.10;
	round var.total to 2 decimals;
#>
(<# invoices.qty #> * <# invoices.each #>) = <# var.subtotal #> + <# var.tax #> = <# var.total #><br>
<# end row #>
<# end list #>

---

(22 * 29.99) = 659.78 + 65.978 = 725.76
(22 * 29.99) = 659.78 + 65.978 = 725.76
(26 * 29.99) = 779.74 + 77.974 = 857.71
(23 * 29.99) = 689.77 + 68.977 = 758.75
(23 * 29.99) = 689.77 + 68.977 = 758.75
(23 * 29.99) = 689.77 + 68.977 = 758.75
(23 * 29.99) = 689.77 + 68.977 = 758.75
(25 * 29.99) = 749.75 + 74.975 = 824.73
(23 * 29.99) = 689.77 + 68.977 = 758.75
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(5 * 29.99) = 149.95 + 14.995 = 164.95
(22 * 29.99) = 659.78 + 65.978 = 725.76
(22 * 29.99) = 659.78 + 65.978 = 725.76
(22 * 29.99) = 659.78 + 65.978 = 725.76
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(22 * 29.99) = 659.78 + 65.978 = 725.76
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(4 * 29.99) = 119.96 + 11.996 = 131.96
(21 * 29.99) = 629.79 + 62.979 = 692.77
(23 * 29.99) = 689.77 + 68.977 = 758.75
(23 * 29.99) = 689.77 + 68.977 = 758.75
(23 * 29.99) = 689.77 + 68.977 = 758.75
(23 * 29.99) = 689.77 + 68.977 = 758.75
(23 * 29.99) = 689.77 + 68.977 = 758.75
(23 * 29.99) = 689.77 + 68.977 = 758.75
(23 * 29.99) = 689.77 + 68.977 = 758.75
(3 * 29.99) = 89.97 + 8.997 = 98.97
(23 * 29.99) = 689.77 + 68.977 = 758.75
(22 * 29.99) = 659.78 + 65.978 = 725.76
(23 * 29.99) = 689.77 + 68.977 = 758.75
(23 * 29.99) = 689.77 + 68.977 = 758.75
(3 * 29.99) = 89.97 + 8.997 = 98.97
(3 * 29.99) = 89.97 + 8.997 = 98.97
(3 * 29.99) = 89.97 + 8.997 = 98.97

---

The updated records should now appear in this List of Invoices
New Invoice - Create Record call to generate an Invoice
Process Invoices - Hashtag List with total calculations in the Row Template
Process Invoices - Hashtag List with Create Record for Google Sheet call in the Row Template

• List Templates
• Update Record Command
• Request Variables
• Context - HTML