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: 38ad67e47e7d62528e4bb44156a843cb
delete


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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



This is the last item!

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


Total number of items 37


The totals are: Subtotal $ 3,358.88; Tax $ 336.00; OrderTotal: $ 3,694.88
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.