using index.js and formatting cell entries

[auwsom]

Hello Chris, first thanks, this is awesome!

It took me a while to figure out how to set up. I know python and some html, but not much js. I searched for a long time to figure out I just needed a index.js file. I'm using on GitHub Pages. Maybe you could add that info for noobs like me. I also made a question and answer on Stack Overflow about js and GSheets in general to help people.

What's the best way to access a cell's content to format? I have url links in one column and thumbnails in another, that aren't coming through hyperlinked, and would like to display the thumbnails as images. I could loop though cells, but that seems slow. Is the SQL format command what would do this? From the docs it looks like it only does date, time, number and boolean. My last option is to injest from GSheet via JSON, and write all my own js, but would like to avoid that, unless that is the only real way to go.
EDIT: okay, rftm, I think I get the syntax now, sorry got excited ;).

Thanks again, after finally getting your library to work, I can now get this project working on display format! That was a big first step!

Oh yeah, also real quick, I haven't got 'order by' column heading working yet, column letter works, am I missing something on how the Google API reads the first row as column headers?