How can I view what TinyDB is storing

[Rex_Williams]

Hi

I've managed to successfully create a simple app to record my weekly spending but after using it for a couple of weeks I've realised it might be useful to be able to see what I've used tinyDB to record.

Basically, my app will allow a figure to be subtracted from a running total but I've realised that I've no way to check if the last thing I spent was recorded or if I forgot to enter it.

I'd like to have a button that when pressed shows a record of figures I've subtracted from my running total.

I'm a low skilled creator so easy steps or preferable a blocks example would be appreciated if what I am asking is even possible as my web searches have proven unsuccessful on this topic.

regards

Rex

[Kumaraswamy]

Hi. This extension will help you to view and export the contents of a TinyDB namespace:

ETinyDB: Extra utilities for Tiny DB

ETinyDB as ExtraTinyDB provides some additional utilities for the TinyDB component. It offers the following features: Export Tiny DB This exports the data stored of a particular namespace or all namespace into the destination file. [ExportTinyDB] [ExportAll] Sample JSON: [ { "namespace": "TinyDB1", "length": 1, "preferences": { "count": "123" } } ] Get JSON Data Similarly you can also get JSON data directly returned. [GetJSON] [GetAllJSON] Used…

[Rex_Williams]

Thanks

I've installed the extension but I'm such a novice I can't see how to make it work. I've looked at the comments but I can't find all the block elements being used to follow the examples.

Is it possible to show me a simple block example to call the results?

Also do I need to store data in ETinyDB to recall it or will ETinyDB pull items from my existing TinyDB?

Sorry for the lack of understanding, I'm 65 years old and not very tech savy....surprised myself even making the original app!!!!

Rex

[Kumaraswamy]

@Rex_Williams

Sorry for the lack of understanding, I'm 65 years old and not very tech savy....surprised myself even making the original app!!!!

Please don't apologise, it's awesome you're active at this age. I started here when I was 12

---

@Rex_Williams

Also do I need to store data in ETinyDB to recall it or will ETinyDB pull items from my existing TinyDB?

You do not have to store data in ETinyDB. ETinyDB will pull items from your existing TinyDB.

---

@Rex_Williams

Is it possible to show me a simple block example to call the results?

It's quite simple: Use the GetJson block of ETinyDBL.

---

Here is a full app example with functionality to view and share the content of a TinyDB namespace as JSON:

Project file: ETinyDbExample.aia (33.5 KB)

[ABG]

@Rex_Williams

a simple app to record my weekly spending but after using it for a couple of weeks I've realised it might be useful to be able to see what I've used tinyDB to record.

You will need to store the expenditures like a spreadsheet, with columns for

• date
• category
• amount

You can keep the table in a single TinyDB tag, or use the year as the tag.

FAQ Section: Lists

Introductory Making Lists (Concepts) - MIT Lists Chapter from MIT AI2 Online book Translatable copy of Lists Chapter from MIT AI2 Online book How to work with Lists - imagnity MIT AI2 List Blocks Help Page How to Display a List - MIT nb191 Advanced list blocks (filter, sort, map, reduce) Tables Dynamic-editable-html-table - @TimAI2 free-tableviewer-fully-style-customized-to-show-table-data (extension) - @Kevinkun Dynamic Table Layout and Table Listpicker (HTML) - @Taifun Dynamic Tab…

[Rex_Williams]

Thank you so much.

I can't try it just yet but you've laid it out so simply I'm sure I'll now be able to make it work.

Thank you for your patience and understanding.....perhaps if I'd started at 12 it might not be as difficult........did they have PC's when I was 12 though LOL.

Rex