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

Extensions
653

This is the output from Doit

Do It Result: ([office, pen, 09/10/2024, 08/10/2025, cs_20241021193736.jpg, , ] [office, pensil, 09/10/2024, 08/10/2025, , , ] [office, rubber, 09/10/2024, 08/10/2026, cs_20241021202511.jpg, cs_20241021202415.jpg, ])

As result of this query

SELECT * from records

I'm using SimpleSquilite.run sql block from SimpleSquilite extention

the query result is considered a list (I checked with is a list?) block

If I print query(1) item and print in text field I read:

[office, pen, 09/10/2024, 08/10/2025, cs_20241021193736.jpg, , ]

but this is not a list nor I can decode to list from json format

EDIT:
ShowListsAsJason. I'm using the default setting, check box NOT ticked

654

The default is actually checked. Check it, this will get rid of the rounded brackets and use square brackets, which is where one of your issues is arising.

Have you added the listfixer block ?

image
image1149×534 58.7 KB

1 Like
655

Ok...getting somewhere

I might have fumbled with this setting and forgot. checked now and got rid of the round backets

Using this block, the actual output of the query seams more proper:

Do It Result: [[office, pen, 09/10/2024, 08/10/2025, cs_20241021193736.jpg, , ], [office, pensil, 09/10/2024, 08/10/2025, , , ], [office, rubber, 09/10/2024, 08/10/2026, cs_20241021202511.jpg, cs_20241021202415.jpg, ]]
---

Now I work on it. All the questions have been discussed and I put my head around and see what I can manage to do.

Most of the information received come from long experience of you guys. really appreciate your time and support

656

and is actually available in documentation of the topics or guides for the extensions you are using...(which is why it is provided, for you to read and use, in advance of using the extensions)

1 Like
657

Hi Kevin

Following the click event I can change the color of the selected cell. Unfortunately when I select another cell I cannot change the color of the previous one.
Please, give me a suggestion?

659

you need a global variable to remember last selected cell, and set its color again.

660

Thank you so much Kevin.

Other questions:

  1. Is it possible to fix the header and scroll only the lines?
  2. How can I manage the height of the table by indicating the number of rows?
661

I suggest you read through this entire topic, most of the configuration options are covered.

1 Like
662

Ok. Thanks

663

Is it possible to use the scroll to function and highlight the line by changing color?

Thanks

664

yes possible. And as said by @TIMAI2 , read the whole post.

665

Good afternoon, Sir @Kevinkun . Have a nice day ahead!

I just want to ask if this is possible using you TableViewer extension:

image
image1113×803 63.1 KB

There is a sub total row.

666

Possible.
just wrap the sub total data with
< b> and < /b>

667

where can I put the in here:

image
image788×704 45.6 KB

668

is this sub total data already in your responsecontent? if yes, find the row number and set its css. there are a lot of examples above for this.

669

In tableviewer extension how can I set the width of only the first column in my table?
Thank you

670

Please read the topic from the beginning the answer is there.

But something like:

tr:nth-child(1) { width:15%; }
1 Like
671

Hi
TIMAAI2

Before asking I searched, unfortunately I couldn't find anything.
Be patient, I had already tried using the function as per the attached image but it doesn't work.

blocks(5)

672

image

image

673

I'm sorry but it doesn't work!!!