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

[Tariq_Mehmood]

Yes Boss
Here is data from responseContent

2022-07-01,500.00,0.00,0.00,500.00
2023-05-09,500.00,0.00,555.00,-55.00
2023-05-10,-55.00,0.00,666.00,-721.00
2023-05-11,-721.00,0.00,76.00,-797.00
2023-05-15,-797.00,0.00,454.00,-1251.00
2023-05-16,-1251.00,0.00,123.00,-1374.00
2023-05-18,-1374.00,0.00,34.00,-1408.00
2023-05-25,-1408.00,0.00,25.00,-1433.00
2023-05-27,-1433.00,0.00,855.00,-2288.00
2023-05-27,-1433.00,855.00,0.00,-578.00
2023-05-28,-1433.00,0.00,10000.00,-11433.00
2023-05-29,-11433.00,567.00,0.00,-10866.00

and this is aia
t_tableViewer.aia (27.3 KB)

It will be great kindness.

Regards

[TIMAI2]

Should be as simple as this....

(note, I have had to add all the line returns because the text block removes them all when pasting the data, you should not have to do this if you work directly with your responseContent)

Start from here, then modify as your require.

[TIMAI2]

Ah, spotted your problem, you do not need to use a vertical scrolling arrangement, it won't work. A vertical arrangement will suffice, the extension will take care of scrolling for you.

Just working on your aia.

[TIMAI2]

Try this

t_tableViewer_revised.aia (26.8 KB)

[Tariq_Mehmood]

Thanks Boss
It works fine now.
Good Luck

[Tariq_Mehmood]

@TIMAI2

Try this

t_tableViewer_revised.aia (26.8 KB)

Sir is it possible to add summary row at the bottom of the table like this

I want to sum Purchase and Sold columns only

Please

[Kevinkun]

Add a row at end of your data

[Tariq_Mehmood]

Sir where should I add row?

In mysql query
OR
in MIT APP blocks

Regards

[Kevinkun]

in ai2 blocks. You need to caculate the sum of the data and add list item ["Total","",1422,11033,""] to end of your data list .

[TIMAI2]

Here you are:

t_tableViewer_revisedAgain.aia (27.8 KB)

(I did the blocks like this to fully show what was happening, should be easily possible to improve the block construction to get the totals)

[Tariq_Mehmood]

Sir TIMAI2, you are really great teacher and problem solver.
You have fulfilled everything.
I salute you.
May you live long.
Regards

[TIMAI2]

@Tariq_Mehmood

May you live long.

and prosper

[Tariq_Mehmood]

@TIMAI2

@Tariq_Mehmood

May you live long.

and prosper

Respected Sir,

I have applied following formats to table

1- Text Alignment = Right
2- Current row highlight
3- Current cell highlight

Now I want to apply comma format like this

11433
to
11,433

Only on numeric columns including summary row.

Here is aia
t_tableViewer_ver2.aia (29.4 KB)

Please help

[TIMAI2]

You need to manipulate your list data using text/maths blocks. This has nothing to do with the Tableviewer extension.

That said, you may need another extension ro do this correctly:

NFormat

[Alexandre_Gorine]

I was trying to set the border color after TableViewer1.ClearStyle using this block

but the boder color is always white. I was trying also

with the same negative result.
Could you please tell where is my error?
p.s.Thank you for an excelent extension!

[TIMAI2]

Try like this:

table {width:100%;border-collapse:collapse;} 
th {border:2px solid red;padding:5px;text-align:center;} 
td {border:2px solid red;padding:5px;text-align:center;}

[Alexandre_Gorine]

@TIMAI2

td {border:2px solid red;padding:5px;text-align:center;}

Thank YOU VERY MUCH! It works!!!

[Tariq_Mehmood]

Sir I have these blocks

and here is aia
my_table_data_picker.aia (27.0 KB)

I want to display selected row data into above textboxes as follows

Please help

[TIMAI2]

Look at the examples, these will show you how to do this, after collecting the row values, select each from the list and assign to each textbox .

Not sure why you are using the runjs blocks?

[Tariq_Mehmood]

Sir I used runjs for formatting.
The examples tells that only current cell value can be stored in variable but I need to display 3 cells values in 3 textboxes.

Regards