List of Invoices
Hashtag List with Row Numbers, Update Record calls, Set To Total Of commands, and Last Row Conditionals
Processing this Hashtag Markup:Header for List of Invoices
Item: 1
Name: | Note:
Qty: 4 | Each: $ 29.99
Subtotal: $ 119.96 | Tax: $ 12.00 | Total: $ 131.96
ID: 7879a9ea1c3f9e11074b3dd8a6cae7c5
delete
Item: 2
Name: | Note:
Qty: 4 | Each: $ 29.99
Subtotal: $ 119.96 | Tax: $ 12.00 | Total: $ 131.96
ID: 89fc3005ba7a9440778889589d35e026
delete
Item: 3
Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 75ec40903014003af6bea62147d3c1c7
delete
Item: 4
Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 4100a52a68c597b0cc4e80d2daab8ed0
delete
Item: 5
Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 9c46e5e078418ab1a8906868024edc8a
delete
Item: 6
Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 949441a978f28a6bda724c8022814a95
delete
Item: 7
Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: c43e02161e3ae6530ce993e8d53c44c6
delete
Item: 8
Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 227339821bc7a55293c998232d2ef26f
delete
Item: 9
Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 6e000ebf350a6560e43da8655949450e
delete
Item: 10
Name: | Note:
Qty: 5 | Each: $ 29.99
Subtotal: $ 149.95 | Tax: $ 15.00 | Total: $ 164.95
ID: 9daf28c14f3520ba1758004e868ce4e6
delete
Item: 11
Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 20f42ab97abfcbdee5b92b5f52d3640e
delete
Item: 12
Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: b853d7a36a114049af516c02cc1c92f5
delete
Item: 13
Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: d5532c089ac658c818163714e6865f58
delete
Item: 14
Name: | Note:
Qty: 5 | Each: $ 29.99
Subtotal: $ 149.95 | Tax: $ 15.00 | Total: $ 164.95
ID: 2dfcdaf76dad33ed541896eb93468479
delete
Item: 15
Name: | Note:
Qty: 4 | Each: $ 29.99
Subtotal: $ 119.96 | Tax: $ 12.00 | Total: $ 131.96
ID: c3c734abd8e22b87f1425eb8ad971dbf
delete
Item: 16
Name: | Note:
Qty: 5 | Each: $ 29.99
Subtotal: $ 149.95 | Tax: $ 15.00 | Total: $ 164.95
ID: 7d24cb4b91d6309d8d655b2fd4ccd7b1
delete
Item: 17
Name: | Note:
Qty: 5 | Each: $ 29.99
Subtotal: $ 149.95 | Tax: $ 15.00 | Total: $ 164.95
ID: 2fc697cb33ec423243b4b4b7397aeb9e
delete
Item: 18
Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 42ca0e059d57de6033306291a6b8874e
delete
This is the last item!
Item: 19
Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: c9236379dfdea8d1b6496d942b1d8a3b
delete
Total number of items 19
The totals are: Subtotal $ 2,039.32; Tax $ 204.00; OrderTotal: $ 2,243.32
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 math expression calculations in the Row Template
Process Invoices - Hashtag List with Create Record for Google Sheet call in the Row Template
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.
