[REBORN !] TableView Extension Versions 3&4 (pre nb191) and 5 by @Ken

[TIMAI2]

Try this, using Tableviewer extension.
TVTemplate.aia (18.2 KB)

These should be all the blocks you need....

[Leonardo_Ucciardello]

The behavior is exactly what I was looking for. now I have to figure out how to lock the header at the top and how to select the rows (I saw that you can also select single cells). I'll work on it now. Thank you very much

In any case, the proposal for Ken to make version 5 is still valid.

1. Flag to block headers on top directly in settings
2. adapt the width of the columns to the longest string between values and headers (perhaps already included in the first one)
3. possibility of highlighting the single cell

[Kevinkun]

@Leonardo_Ucciardello

• Flag to block headers on top directly in settings
• adapt the width of the columns to the longest string between values and headers (perhaps already included in the first one)
• possibility of highlighting the single cell

all can be done by tableviewer.

[FREE] TableViewer - fully style customized to show table data

I have make another version of TableViewer, it's a package of Webviewer and Javascript and CSS. so you can set up the style as you wish, if you know some CSS knowledge. v8 UPDATE add event OnShowTable, fired after ShowTable is called. v7 UPDATE add property TransparentBackground, designer only. V6 UPDATE SetStyleSheet now can accept url to an external css file. add SetClass block, which can set class to a tag or id selector add ClearStyle block, which can clear all styles, including the …

[TIMAI2]

@Leonardo_Ucciardello

how to lock the header at the top

This is already in the blocks I provided

[Leonardo_Ucciardello]

Awesome Thank you

[ABG]

You might be better off using YAML for your table displays.

Se

Browse Google Sheets in YAML format

This tutorial is meant to show an alternative way to display wide table data in portrait mode. It uses YAML. YAML is a data serialization language that is often used for writing configuration files. Depending on whom you ask, YAML stands for yet another markup language or YAML ain't markup language (a recursive acronym), which emphasizes that YAML is for data, not documents. This tutorial is browse-oriented, and centers around a value procedure that can take a table (row of rows) with a heade…

[Leonardo_Ucciardello]

I've read it but my problem is not the data, I use MSSQL queries through PHP and it's super fast even with a huge amount of data like that of an ERP. The problem is simply the display of this data, indeed simply the formatting of the table. thanks anyway for the advice, now I know one more thing.

[Taifun]

@Leonardo_Ucciardello

I use MSSQL queries through PHP

Could you please share how to connect App Inventor with a MSSQL database? Which blocks do you use? How does your php script look like? You could use the following thread for that

How do I connect MSSql Server?

If I want to use App Inventor App connect MSSQL ,how to I do?

Thank you in advance

Taifun

[Frank-HRO]

I have a problem with the TableView v4 extension.

Is there a solution for this?

Frank

Runtime error:
java.lang.NoSuchMethodError: No static method setFontTypeface(Landroid/widget/TextView;IZZ)V in class Lcom/google/appinventor/components/runtime/util/TextViewUtil; or its super classes (declaration of 'com.google.appinventor.components.runtime.util.TextViewUtil' appears in base.apk)
Note: You will not see another error reported for 5 seconds.

[TIMAI2]

Are you attempting to change the font ?

There is no option for this, other than the built-in fonts

Is this related to your other problem with companion and emulator ?

[Frank-HRO]

This is a 2nd issue independent of Companion and Emulator.

I used this sample file, created an apk and got the runtime error.

TableView_v4.aia (24.4 KB)

[TIMAI2]

Try this

TableView_v4_revised.aia (24.4 KB)

I changed all your /n to \n to provide correct csv format.

Works fine for me, companion and compiled

[Frank-HRO]

Thank you, my mistake.

Frank

[Frank-HRO]

@TIMAI2

The apk file works if I create your aia file using http://ai2.appinventor.mit.edu.

If I use https://ai2-test.appinventor.mit.edu/ to create the file, the error message comes up:

Runtime error:
No static method setFontTypeface(Landroid/widget/TextView;IZZ)V in class Lcom/google/appinventor/components/runtime/util/TextViewUtil; or its super classes (declaration of 'com.google.appinventor.components.runtime.util.TextViewUtil' appears in /data/app/ ...

A test with Companion or USB is not possible for reasons you know (see above)

Frank

[TIMAI2]

This may be due to the new font functionality in the upcoming nb191 ? Will be a shame if it is.

It may be possible to add the same functionality to the extension if @Ken approves, or to remove the font option from the extension.

[TIMAI2]

Easier to just take it out ?

[Frank-HRO]

@TIMAI2
Since I use the TableView extension in several programs, this is very time-consuming.
In addition, I have not yet found an extension that corresponds to TableView in terms of scope.

@KEN
Would it be possible for you to adapt the extension?
That would be very very nice of you.

With the new nb191, the error message now occurs constantly.
Future newer versions of my programs will no longer run.

Greeting Frank

[Ken]

I can't make any promises, but I am looking into it.

[Kevinkun]

Hi @Frank-HRO Maybe you want to use another extension to show a table,if you know some basic CSS.

[FREE] TableViewer - fully style customized to show table data

I have make another version of TableViewer, it's a package of Webviewer and Javascript and CSS. so you can set up the style as you wish, if you know some CSS knowledge. v8 UPDATE add event OnShowTable, fired after ShowTable is called. v7 UPDATE add property TransparentBackground, designer only. V6 UPDATE SetStyleSheet now can accept url to an external css file. add SetClass block, which can set class to a tag or id selector add ClearStyle block, which can clear all styles, including the …

[Frank-HRO]

Since the new nb191 version, the created apk version no longer works either.
Error message see above.
Using the extension TableViewer does not bring this error.
Since I have many scripts with the TableView extension, the conversion is very time-consuming.

I hope @Ken finds the time to fix the bug.

Frank