TinyDB with buttons

[Carles_Martinez_Berm]

@ChrisWard

The Mrs is much better

I'm glad to hear that

@ChrisWard

Do all your T1, T2 etc buttons work, storing the data in TinyDB_STATS?

Yes, all the buttons work

@ChrisWard

Post your latest aia file for me to add an example output. I'll take a look tonight or some time tomorrow.

RB_Virtual (1).aia (125.2 KB)
Thanks for looking it, I'm so grateful with you.

[Carles_Martinez_Berm]

@Spicy_Topics

As an alternate, you can connect app with gsheet and do the rest if possible

How can I connect it?

[ChrisWard]

--- deleted ---

[Spicy_Topics]

@Carles_Martinez_Berm

can I connect it?

You can read here (script method ) METRIC RAT AI2 - Google Sheets for AppInventor (extension method) 🟩 [FREE] Google Sheets for AppInventor (replicant) using Google Apps Script for mor info

Credit to @TIMAI2

[ChrisWard]

.... it might be built-in to the next App Inventor release.

[Carles_Martinez_Berm]

Okay, I'll try do the tables in excel with what I have

[ChrisWard]

I'm looking at your Project file - had to modify the buttons to be able to read their labels on my phone, in landscape mode

[ChrisWard]

Something else you could work on is how to add a new player to the Squad. Typing the player's name in is easy but you need code to import the player's photograph. You also need to be able to delete a player from the Squad.

Imported photographs might need resizing. They will also need their own TinyDB and they should be encoded as Base64 text to save them in TinyDB, decoded back to an image when loaded from TinyDB.

Note, if a new player is added to the Squad during the Season, he/she cannot take the number (index) of an existing player. So perhaps there should be two or three holding places in the Player Manager table to allow for that.

[ChrisWard]

If you are going to use Excel, You do not need the ASD folder or the Shared function. The CSV file can be saved straight to the Documents Folder.

Are you using Excel on your phone or your PC? If on your PC, you could save the CSV file to your Google Drive. Alternatively, as per Spicy_Topics' suggestion, you could upload the CSV to a Google Sheet and work online. Final alternative is to display the data as a Table in the App.

[Carles_Martinez_Berm]

@ChrisWard

If on your PC, you could save the CSV file to your Google Drive. Alternatively, as per Spicy_Topics' suggestion, you could upload the CSV to a Google Sheet and work online

Yeah I'm doing that

[Carles_Martinez_Berm]

@ChrisWard

Something else you could work on is how to add a new player to the Squad. Typing the player's name in is easy but you need code to import the player's photograph. You also need to be able to delete a player from the Squad.

Imported photographs might need resizing. They will also need their own TinyDB and they should be encoded as Base64 text to save them in TinyDB, decoded back to an image when loaded from TinyDB.

Note, if a new player is added to the Squad during the Season, he/she cannot take the number (index) of an existing player. So perhaps there should be two or three holding places in the Player Manager table to allow for that.

I think that only adding the name and it appearing on the label test will be enough

[Carles_Martinez_Berm]

What about this Chris?

[ChrisWard]

You can't use it

....but we can do this:

[Carles_Martinez_Berm]

I have to create new variables?

[ChrisWard]

leave it to me

[Carles_Martinez_Berm]

Thanks Chris

[ChrisWard]

Hi Carles

Well, still a lot to do, as mentioned before. The attached 'RB_Virtual3.aia'

1. Collates Season-so-far Player Match Data
2. Saves the data as a CSV Table file in the Android shared directory 'Documents'
3. Displays the data in-App

To fully test, you must build an APK. I have tested CSV files in the Google Sheets App and in a Spreadsheet App, both on my phone. More can be done in the App, for example a Table sort. You'll need something similar again for the time statistics, that needs some thinking about first!

RB_Virtual3.aia (151.8 KB)

[Carles_Martinez_Berm]

Hi Chris,
The only thing that lack in the table it's the time to do the real analysis of data.
Still many thanks.

[ChrisWard]

@Carles_Martinez_Berm

The only thing that lack in the table it's the time to do the real analysis of data.

Indeed, but firstly the recording of the times needs to be right - then we need an insight as to how the recorded times are to be presented in stats for meaningful analysis.

[Carles_Martinez_Berm]

@ChrisWard

Indeed, but firstly the recording of the times needs to be right - then we need an insight as to how the recorded times are to be presented in stats for meaningful analysis.

I think if I upload the table and the data without being at the table because I have time I could do everything