cjoh / sheetsee-tool-lending

A fork-and-go repo for creating a tool lending library website.

Hi!

A Tool Lending Library Site

A webiste and spreadsheet set up to make lending tools to friends or neighbors easier.

Currently while I'm still developing/desinging the layout, I'm using sheetsee-cache, which enables me to cache the data so that I don't have to visit google every refresh and can develop offline. When I'm happy with it, I'll delete a couple files and add 3 lines to the index.html and taadaaa it will become the normal sheetsee.js client-side fork-n-go-able version.

So to set it up now, clone this repo, cd into the folder, npm install and then npm sever.js.

When I turn it over, the fork-n-go process goes like this (italicized for now to emphasize that I haven't switched it over yet):

Fork -n- Go!

In a bit I'll do some more refining (and documentation) - but here's a fun fact:

This repo only has a gh-pages branch, which means as soon as you fork it, you have a hosted and live version of it yourself!

Next, create a spreadsheet with the same column headers as the original.

Click on the index.html file, click edit and change line (TBD). Replace the existing spreadsheet URL key with your spreadsheet's key. You'll find that by clicking (in Google Spreadsheets) File > Publish to the Web > Start Publishing, it will then display the key in a window.

Commit those changes and LIKE WOAH you now have a version of this website hooked to a spreadsheet that you can distrubute however you'd like.

But How?

A Google Spreadsheet holds all the data and it is connected to this website using the goodies in sheetsee.js. Everytime you visit the website, you'll have the most up to date data that has been entered into the spreadsheet.