publicchecklist
publicchecklist copied to clipboard
Public checklist of your progress auto syncing with Google Sheet
✅ Public Checklist
🤔 Problem
Procrastinating when try to complete some goal like:
- Complete coding course
- Go 30 days to gym
- Learn Englsih
- Lose weight
✅ Solution
Public checklist on your site where you exactly know what was done and how much left and share progress with your friends.
It's auto sync with Google Sheet so don't need to HTML update it every time.
All data is taking from Google Spreedsheet (iFrame) and update it automaticaly every 5 mins.
DEMO 1 (Coding Course): http://andreyazimov.com/freecodecamp
DEMO 2 (100 Push-ups Challenge): http://andreyazimov.com/100pushups
⬇️ Instalation
- Make a copy of a spreadsheet (File -> Make a copy). Here are soem teplates but you can make your own:
- 100 Push-ups Google Checklist (Google Spreedsheet template)
- Beta Free Code Camp Checklist (Google Spreedsheet template)
- Get an iframe link of progress bar (File -> Publish to web -> Embeded -> progress-bar (Not Entire Doc)).
2.1 Copy link. Example: "https://docs.google.com/spreadsheets/d/e/2PACX-1vQanprHEXQ66_r2rflfCrdKcfV6FMLzCoKWJ8gLaU0CJX48Ov7j8Cdow-pSyA6NKwepVJiz-xc7JHBk/pubhtml?gid=2110731770"
2.2.1 Between: "<iframe src"" AND "&". Avoid copy hole iframe link.
2.3 Paste this link to progress bar section in index.html.
-
Get an iframe link of of checklist (same as progress-bar).
-
Open this index.html and check if this works.
-
Try to change progress in basic-html-and-html5 tab. Put "DONE" in any task. Checklist tab in spreedsheet should change. Progress tab in spreedsheet bar should change. Result should be changed in index.html
🛠 Troubleshooting
- If there is an error on iframe make sure you copy correct link
- If there is a white boder of iFrame play with width and height below <iframe width=438 height=63 src="
- Ask me: twitter.com/AndreyAzimov