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: 19 | Each: $ 29.99
Subtotal: $ 569.81 | Tax: $ 56.98 | Total: $ 626.79
ID: e6ac3747fc64a1f7bf4aca282718f346
delete


Item: 2 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 27e297a01d8b26effbb83addbe626dbe
delete


Item: 3 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 54163ec42a843f8432befcf31d2873ea
delete


Item: 4 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 676e8e536730518178f3a76f33498cee
delete


Item: 5 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 52aed8896a63f881a6f93194b97556b6
delete


Item: 6 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 57f4dba08df544475085cbb568d07c9e
delete


Item: 7 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 66745b78bddf580d047323222296b09c
delete


Item: 8 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 5a2692c19e59c06bb7bac8bb81c40221
delete


Item: 9 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 0315be386552c761294c7be5e94fc2e3
delete


Item: 10 Name: | Note:
Qty: 22 | Each: $ 29.99
Subtotal: $ 659.78 | Tax: $ 65.98 | Total: $ 725.76
ID: 83c5db9a22b51c90a6eefd2b90882fdb
delete


Item: 11 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 3eca6d45c16d22d16d7a66a1040d156f
delete


Item: 12 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 47c9066ebb60d8318dedec4f5f864958
delete


Item: 13 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 26cad0dc8b11cf54bc35fb6fc9e29853
delete


Item: 14 Name: | Note:
Qty: 22 | Each: $ 29.99
Subtotal: $ 659.78 | Tax: $ 65.98 | Total: $ 725.76
ID: b97064778ba4d331f00040cd8e4ff3ee
delete


Item: 15 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: c4812b246bb0cb0c72b1190be45fbfed
delete


Item: 16 Name: | Note:
Qty: 22 | Each: $ 29.99
Subtotal: $ 659.78 | Tax: $ 65.98 | Total: $ 725.76
ID: c63f646874951aff091db2767494969c
delete


Item: 17 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: fe3652c913f85faa3b6c272d0b1e5243
delete


Item: 18 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: dd617650a8ffb5e17e3b4e88d9595855
delete


Item: 19 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: eff36a87e8a9ec8aad96d95c71e92e47
delete


Item: 20 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 9d14e5810b00e0694a4d2f2f567aeefb
delete


Item: 21 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 18bac8f091b9ec7bb26b09395f2a6092
delete


Item: 22 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 0c63212e12e4c6158f9b902330d7c9b0
delete


Item: 23 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: cf0b5f679d7689462af53959d19f11c4
delete


Item: 24 Name: | Note:
Qty: 22 | Each: $ 29.99
Subtotal: $ 659.78 | Tax: $ 65.98 | Total: $ 725.76
ID: 29090e3cda505e486cdd2e37cf8c7f77
delete


Item: 25 Name: | Note:
Qty: 24 | Each: $ 29.99
Subtotal: $ 719.76 | Tax: $ 71.98 | Total: $ 791.74
ID: 35e1906b2e543af0f9e1ebf473429384
delete


Item: 26 Name: | Note:
Qty: 22 | Each: $ 29.99
Subtotal: $ 659.78 | Tax: $ 65.98 | Total: $ 725.76
ID: 054ee57c0746080272a84293a13b2f22
delete


Item: 27 Name: | Note:
Qty: 23 | Each: $ 29.99
Subtotal: $ 689.77 | Tax: $ 68.98 | Total: $ 758.75
ID: edd3ae2b06f46e36ff3d16820e94d1e2
delete


Item: 28 Name: | Note:
Qty: 22 | Each: $ 29.99
Subtotal: $ 659.78 | Tax: $ 65.98 | Total: $ 725.76
ID: dab512194cee9f436dba8b241afb834e
delete


Item: 29 Name: | Note:
Qty: 22 | Each: $ 29.99
Subtotal: $ 659.78 | Tax: $ 65.98 | Total: $ 725.76
ID: 420ff58aef0ce0a60d335d81f48acc5b
delete


Item: 30 Name: | Note:
Qty: 22 | Each: $ 29.99
Subtotal: $ 659.78 | Tax: $ 65.98 | Total: $ 725.76
ID: f0565023ef577879cd768d132bb56f57
delete


Item: 31 Name: | Note:
Qty: 22 | Each: $ 29.99
Subtotal: $ 659.78 | Tax: $ 65.98 | Total: $ 725.76
ID: b2780162d6792abfbbadecaefdc520cf
delete


Item: 32 Name: | Note:
Qty: 24 | Each: $ 29.99
Subtotal: $ 719.76 | Tax: $ 71.98 | Total: $ 791.74
ID: 709381046d9c479e28ecf8d38e8fc7f0
delete


Item: 33 Name: | Note:
Qty: 22 | Each: $ 29.99
Subtotal: $ 659.78 | Tax: $ 65.98 | Total: $ 725.76
ID: 84324306dafd5af2d5c1cfbd65faa534
delete


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


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


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


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


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


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


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


Item: 41 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 70319d8b96a4db97849e0dad7f600959
delete


Item: 42 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 5ea26ffa62e2bd5132f36c808df8877e
delete


Item: 43 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: 1faf4ccaf3130ed5fce34e66b1ca080f
delete


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


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


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


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


Item: 48 Name: | Note:
Qty: 21 | Each: $ 29.99
Subtotal: $ 629.79 | Tax: $ 62.98 | Total: $ 692.77
ID: f9a4b95b797f611a1d39b019c6d7afe2
delete


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


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


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


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


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


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



This is the last item!

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


Total number of items 55


The totals are: Subtotal $ 25,401.53; Tax $ 2,540.26; OrderTotal: $ 27,941.79
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.