Giter Site home page Giter Site logo

jlord / sheetsee-calendar Goto Github PK

View Code? Open in Web Editor NEW
97.0 15.0 100.0 1.49 MB

Website with calendar of events from a Google Spreadsheet

Home Page: jlord.github.io/sheetsee-calendar

License: BSD 2-Clause "Simplified" License

CSS 0.47% JavaScript 99.53%

sheetsee-calendar's Introduction

Sheetsee Calendar

A fork-n-go Sheetsee.js calendar project! Made by me and @muan, we finally worked on something together! ๐ŸŽ‰

ss-cal

Sheetsee.js Calendar

Sheetsee.js is a library that makes it easy to visualze data from a Google Spreadsheet. This repository expands on that by building a calendar based on events in a spreadsheet.

Fork-n-go

This repository contains webfiles on a branch named gh-pages, which means GitHub hosts them for free at: jlord.github.io/sheetsee-calendar. When you fork the project to your account, you too can have a hosted site -- easy peasy!

Set Up

Here's how to get going with your version:

1. Create spreadsheet

Create a new spreadsheet for your data on Google Docs. It should contain these headers (case and order of columns do not mattter, spelling does):

Start Date | End Date |  Name | Location | Tickets | Contact

Dates

Your dates should be in the mm/dd/yyyy format. If your day is multiple days, use both the Start and End Date columns, if it's just one day, leave End Date blank.

2. Publish spreadsheet

In order to fetch your spreadsheet's data you'll need to click File > Publish to the Web > Start Publishing. This just means when asked for the data in the spreadsheet, Google returns it.

publish

3. Fork this repository

From this page, click the "Fork" button at the top right. Bam!

4. Add your spreadsheet key

  • From your fork's page on GitHub, click to view the index.html file.
  • When it opens, click "Edit"

You'll see code near the bottom that looks like this:

document.addEventListener('DOMContentLoaded', function() {
  var URL = "0AuOjlXjUrSbAdE1XRFJkeEJZQ1NSelhILUR0NXdBWUE"
  Tabletop.init( { key: URL, callback: generateCalendar, simpleSheet: true } )
})

The variable URL is your spreadsheet's key, which is the long set of letters and numbers in the middle of your spreadsheet's url.

  • Copy and paste your spreadsheet's key in place of the existing one.
  • Click "Commit changes" at the bottom of the page.

Ta Da!

In a few minutes you'll be able to visit your site at: yourgithubname.github.io/sheetsee-calendar.

Pro-tip You can click "Settings" on your fork's page and rename it to a more appropriate-to-you name than sheetsee-calendar :)

Styling

Included in this repository is a stylesheet for the calendar. You can keep the style as is or make it your own! Classes are like so:

css

Map

Include a Map Map Documentation
map If you want to include a map, you can do so! There is a map version on the with-map branch. Read map-doc.md for instructions.

Use cases

  1. http://calendar.codebar.io/
  2. http://findyourfitwichita.com/bike

sheetsee-calendar's People

Contributors

muan avatar paulfitz avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

sheetsee-calendar's Issues

Readme

@jlord you take this one!!!! โค๏ธ

Also I always think it'll help to have some sort of CSS guide, like, if I hate the party color theme, instead reading the DOMs to understand what's what, if we can have a chart like

image

I don't know, I have never seen anything like this so it might be stupid, what do you think?

Calendar Key?

Hi! I've been trying to set up the calendar, but the Google Calendar code I get does not resemble the one you mention. Any suggestions?

Maps

Add map based on locations from geocoder.

Remove "link" to calendar events

Hi, love the concept of the Sheetsee Calendar, well done! I was wondering how I can remove the link for each event... really just want the events on the calendar without linking to a new page or opening a new window... thank you for your consideration!
Piccante.

where is the key

image

Hi I cannot find a key in the docs publishing page, can you kindly point it out?

New CSS style for different column of events?

Hi jlord, wondering if it's possible to modify the code so that events entered in a different column in the google sheet would appear in the calendar as an event with a different CSS class, for example, appearing as a different color?

Thanks!

Review columns

Discussions with @alysonla made me realized that it doesn't make sense to call the tickets column tickets since it's really a url column. What do you think? Also are we using Contact anywhere?

Events of the past

How should we handle these?

  • should they dim?
  • should they show on the map?

Is this too much?

placement in carousel

ok so i've altered the css quite extensively, a little of the js too.

but now i am wanting to show this element in a carousel......any ideas on this pls ladies?

clipular

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.