List of Invoices

This page ... TODO!! this page doesn't work anymore because update records no longer update list values.  

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: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: f3ce7a56169afa9ed2f6a00c9e576b75
delete


Item: 2 Name: | Note:
Qty: 5 | Each: $ 29.99
Subtotal: $ 149.95 | Tax: $ 15.00 | Total: $ 164.95
ID: 8a61f1bb5e13deefda4f7464a0ef9a80
delete


Item: 3 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: fb4a1cc725dc2cbb8c947f05f5337fda
delete


Item: 4 Name: | Note:
Qty: 4 | Each: $ 29.99
Subtotal: $ 119.96 | Tax: $ 12.00 | Total: $ 131.96
ID: dbd00f5330046b94741e6f04f8dd2b8a
delete


Item: 5 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: d7f7933d0e3a5208583193a6e0042785
delete


Item: 6 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 6b2fad9c3f69ab639c54a5e5ec06a4b6
delete


Item: 7 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 5cc0edd19c3c466c6e274f2754ce5c1a
delete


Item: 8 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 4d08d72e80902788fe24fac3dff02fd1
delete


Item: 9 Name: | Note:
Qty: 4 | Each: $ 29.99
Subtotal: $ 119.96 | Tax: $ 12.00 | Total: $ 131.96
ID: 5614413b50a6e779069984b6a3e2ec1a
delete


Item: 10 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 1789b2e82f230e4d33d9b7be56d34bb1
delete


Item: 11 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: c732c705df3297c2523b94aa978e2980
delete


Item: 12 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: d0f16e77e5507fba1eb025725ec41180
delete


Item: 13 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 41e368ec8f2f96523454ac7fbfef417c
delete


Item: 14 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: ddea143cf5ac146ab79e11e64addb8e4
delete


Item: 15 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 0c11948126681fad76132e64b34e0e06
delete


Item: 16 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 58c935ce6c0e6a849fd1d208d69868cc
delete


Item: 17 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: e89c052e556c5ed24f0401d0e4aab93f
delete


Item: 18 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: f06ee9dbc3b1191cf489db9059026c38
delete


Item: 19 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 71dc9f77b6fc848acfa8ce31ac4c698d
delete


Item: 20 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: efd7c7f943f559dd411d9b7f82a0a703
delete


Item: 21 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 5adc4195c93d6f7051a79db4652b4a30
delete


Item: 22 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: fd0cb7343581eb146fa026254658f88e
delete


Item: 23 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: acafcdec7f66cfa642d0625ecd9e3479
delete


Item: 24 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: b323664d9b5b483c59a5f58c0f8f5761
delete


Item: 25 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 34dfdfd6ea64d8cab86fb977128f55e6
delete


Item: 26 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: db3113f4933cc15ab3c20932f9c0b5c4
delete


Item: 27 Name: | Note:
Qty: 4 | Each: $ 29.99
Subtotal: $ 119.96 | Tax: $ 12.00 | Total: $ 131.96
ID: f20d29133b5e7b6aa34f6e68030bf478
delete


Item: 28 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: 6bc3633ce19dfc3215ded09a58ca1f75
delete



This is the last item!

Item: 29 Name: | Note:
Qty: 3 | Each: $ 29.99
Subtotal: $ 89.97 | Tax: $ 9.00 | Total: $ 98.97
ID: dc3ace0b785ea324dafca6a2ca465885
delete


Total number of items 29


The totals are: Subtotal $ 2,759.08; Tax $ 276.00; OrderTotal: $ 3,035.08
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.