Viewing and Tiny DB

jray8242 · July 9, 2020, 2:48am

I have written and AutoGas Tracker and using Tiny DB as my DB. All works great except, how do I view my DB so I can see all my entries?

Thanks for the help.

ChrisWard · July 9, 2020, 9:04am

Hello jray

How many entries are there?
How do you want to view them - as a list, or one-by-one or what?

ChrisWard · July 9, 2020, 9:48am

Here is an example:

ViewTinyDb.aia (3.5 KB)

jray8242 · July 9, 2020, 1:20pm

Chris,

Thank you for the information. It's been a while since I have worked with App Inventor and need to keep this old brain working.

I have 6 fields to work with it. I thought about using Google Sheets, but I thought what if I am in a area with the RV, that I don't have cell service, so I though Tiny DB would work and could export it to Google Sheets with another feature.

Please feel free to correct me for this old guy is still teachable.

Here is the plan.

Enter the typical Gas station fill up with around 6 items.
Have a function that can list all my fill-ups.
Be able to export it to Google Sheets when possible,

Does all this sound possible?
Is there a good tutorial on how to use Tiny DB?

Thanks again for the help.

Jim blocks

ABG · July 9, 2020, 1:48pm

You have a problem with your table structure.
You are building a tapeworm instead of a table.

Here is a draggable corrected version ...
save
(corrected to eliminate global variable reference. With TinyDB, there is no need to keep a doppleganger in RAM.)

Don't mind the errors, they are because I built this outside of your app.
They should clear after you drag this into your workspace and clear the event duplication.