TinyDB with buttons

MIT App Inventor Help
151

It depends on how you want to arrange the table/spreadsheet

name,val,val,val,val,val
name,val,val,val,val,val
name,val,val,val,val,val
name,val,val,val,val,val
name,val,val,val,val,val

or
name,name,name,name,name
val,val,val,val,val
val,val,val,val,val
val,val,val,val,val
val,val,val,val,val
val,val,val,val,val

2 Likes
152

Like : Carles,TL,T2,T3,F,A,R
/n
Comas...

153

Yep - you can actually build a Table in your App with Ken's extension:

154

image
image777×579 43 KB

And in name of the file, what I have to put?

155

Right - you are building the table in a way I didn't expect :grimacing:

The Whole Chart would look like:

Player, TL,T2,T3,F,A,R\n <-- Title Row

Name,val,val,val,val,val,val\n <-- Data from TinyDb
Name,val,val,val,val,val,val\n <-- Data from TinyDb
Name,val,val,val,val,val,val\n <-- Data from TinyDb
Name,val,val,val,val,val,val\n <-- Data from TinyDb
Name,val,val,val,val,val,val\n <-- Data from TinyDb

The file (.csv) needs to initially be saved in the ASD (App Specific Folder) - go to the Tutorial and Guides forum to see how to set that.

156

A Table example

157

So in name I write "Name" and only five or the name of each player? I feel so dumb but I don't understand nothing, neither how nor where to put the table hahah

158

That's up to you - is the Table specifically most recent Match Data or is it Season-so-far Data that you want in your Table.

159

Here is an example Football League Table

LeagueTableSorted_Pts_Gd.aia (27.4 KB)

160

It is

161

I've looked the table but thats not that I want. What I want is that all the data that comes out in the test label is saved and I can download it in .csv to later make the tables in excel.

image
image962×674 86.6 KB

Can it be like this or not?
When I put this in excel, I can only see the names but not the data

162

That's because you have not retrieved the data from TinyDB_STATS nor pre-processed it (added-up all the TL, T2, T3 etc values per player.) Your output should be only from the TinyDb records, you should not 'hard code' player names.

163

Also, I see you are only exporting a Match? Before you were interested in 'Season-so-far'.

164

My bad, translator confused me. The idea is do match by match and aggrupe them in a excel

165

And how can I do that an also watch the time I pressed the button?

166

The 'test' button that prints the stats on-screen - that code is how you extract the data.

That would be much easier to do in code before sending to Excel than performing the task in Excel.

That needs a better description, I don't understand :thinking:

167

But I don't know how, and in excel yes.

Wgen I press a button, for example TL YES, in test label it puts the time that I pressed the buttons, so I want to know how pass all the data (and also the time) to the excel. Because now I can put the label test in the excel, but not in columns.

168

OK, I can take a look at it for you but not today as my wife has become unwell and I need to take her to see a doctor.

169

Don't worry first things first and it's something that doesn't rush

170

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