Displaying a table from google sheets but I dont know how to change the colour of the background to fit my app

[TIMAI2]

I don't see a table....

If you want to show it in a webviewer, then you would need to add some html/css to make the background black and the text white. You will probably need to get the data using the web component, then feed this to an html page using the webviewstring.

[Drifty1]

there is also a problem where the table only shows up when I press a textbox, not right after I press the show work button.

[Drifty1]

[Drifty1]

how do i do this?

[TIMAI2]

Can you use extensions ?

Much easier to use Tableviewer to display the downloaded query data

[Drifty1]

can you give me a link for that?

[TIMAI2]

On second thoughts, there may be a way to inject some css to the existing html using the javascript DOM. I would have to do some code finding and testing to see if this works.

Meanwhile:

[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 …

[Drifty1]

thanks please notify me if you found a way to do that

[TIMAI2]

Can you please share your spreadsheet ID for testing

[Drifty1]

i have a problem with trying to turn my data into text,

this is the image that displays the table but I don't really know how to get the data from webviewer2 to use it for TableViewer

[TIMAI2]

This should do it:

(This is a draggable block, click on it, then click again and drag onto your blocks editor)

[Drifty1]

it works now thank you so much

[Drifty1]

is there a way to center the table?

[TIMAI2]

In your app, centre the screen, then adjust the width of the webviewer.

To do it inside the webviewer would require more css...

[Drifty1]

alright thanks

[Drifty1]

there's a problem where the table wont show up after I press the show work button, but if I press the textbox and my keyboard pops up.then the table will finally show up. How to do make it show up immediately upon pressing the button

[TIMAI2]

Not seeing that issue here:

Could be that you need to uriEncode your query, using a block from the web component?

[Drifty1]

what do you mean i dont understand

these are my blocks incase it's needed.

[TIMAI2]

For centring, add this to your javascript, below the other settings for "nodes"

This will make the table fill the webviewer width. You can then decrease the width of the webviewer in the designer to suit your requirements (and set the Screen to centred)

I am not sure why you are having to click the button twice...