morts81

I’ve got a google sheet that I’d like to use as an example, it’s published to the web, etc and the url is https://docs.google.com/spreadsheets/d/1eBQWxTv2y980ks2lA6pzXP95JLYAvsy2jgjFCtocBEM

I found a stackoverflow query that had some code (https://stackoverflow.com/questions/13699589/display-the-content-of-a-google-sheet-cell-in-a-web-page) here, which had the following code which I can’t seem to retrieve anything with. I was hoping to start by just retrieving some data and then work on making it dynamic with dropdown menus, etc.

<script type=”text/javascript”>
function doGet() {
var spreadsheet = SpreadsheetApp.openById(“1eBQWxTv2y980ks2lA6pzXP95JLYAvsy2jgjFCtocBEM”); // replace with your sheet id
var html = spreadsheet.getRange(“A1”).getValue(); // My html is in cell A1
return HtmlService.createHtmlOutput(html);
}
</script>

Thanks very much, so simple.

Hi

The example table above is very basic. In actual fact I would likely have a table of maybe 1000 rows, and when a selection is made, there could be anywhere from 1 to 17 rows matching that criteria.

I was hoping to be able to limit selections to 1 and not allow anymore selections. And have only 1 selection load on page load. I guess more for aesthetics than anything.

Cheers
Morts81

Excellent, thankyou

I’ll post a question on on the wpdarko site and mark this resolved, thanks

Image upload doesn’t seem to have worked. Here is the dropbox link:

https://www.dropbox.com/s/hl98oeqgh6zwwpu/Screen%20Shot%202017-02-21%20at%209.07.28%20am.png?dl=0

That’s perfect, thankyou for the quick response.

You are a champion kind sir.

Thanks for the help and the prompt response.

Thanks so much for this, it’s certainly helped to bring the header size down.

The menu bar below however still seems to be limited by the search bar, or similar. Ideally I’d like to have this half the height (with text smaller if necessary) and then all the pull down menu’s would also be shorter.

Any ideas how to close the loop?

I think I just fixed it

.tablepress th,
.tablepress td {
padding-bottom: 1px;
}

.tablepress th,
.tablepress td {
padding-top: 1px;
}

Sorry, I think it might be this

.tablepress th,
.tablepress td {
padding: 1px;
}

Is it possible to get rid of vertical padding but not horizontal?

I just decided to try and go through my Plugin Option CSS and it seems like this might be causing the issue:

.tablepress th,
.tablepress td {
white-space: nowrap;
}

The reason we added this was because of the wrapping issue we also has in this question. Maybe there is an alternative to that solution which will not affect the table width?

Hi Tobias

Finally got around to trying this and it unfortunately doesn’t work.

Any other ideas?

That doesn’t seem to fix the issue. The tables still don’t show full width unfortunately. Any other ideas?

Thanks Tobias

The row height doubling is fixed now, excellent feedback.

When I try upload the new beta version of TablePress though I get the following:

Installing Plugin from uploaded file: tablepress-dev.zip
Unpacking the package…

Plugin install failed.