Hi! I found an interesting idea to use Google spreadsheets like data base. 
I create empty TW5 Shop on my site and write little script. This script 
read id parameter from URL and get all data from my spreadsheets if they 
are public and shared.

It mean, that everybody can open my spreadsheet, make copy of it to their 
google drive, modify and "render" it by new id on my site. So we 
have something like free an very simple hosting for everybody on one static 
page :)

Current demos

http://novye-podarki.ru/frame.html?id=1GzZFzmgF-vBrRYOyz5VqjJC8QAQcOHnFBa1PEW9NhcU
on start loads data from
      
https://docs.google.com/spreadsheets/d/1GzZFzmgF-vBrRYOyz5VqjJC8QAQcOHnFBa1PEW9NhcU/

and the same page, but different id
http://novye-podarki.ru/frame.html?id=1Oaeue_pQWn01EY5f2ghiTgkLsq5Rm7xbFr89_R801JQ
data from
       
https://docs.google.com/spreadsheets/d/1Oaeue_pQWn01EY5f2ghiTgkLsq5Rm7xbFr89_R801JQ/
 


and other  variant first spreadsheet on different templates 
http://novye-podarki.ru/black.html?id=1GzZFzmgF-vBrRYOyz5VqjJC8QAQcOHnFBa1PEW9NhcU
http://novye-podarki.ru/grey.html?id=1GzZFzmgF-vBrRYOyz5VqjJC8QAQcOHnFBa1PEW9NhcU

without id you will see empty TW5 Shop
this "hosting" has ban system. It checks g-mail of spreadsheet, and not 
render it, if it is in ban list.

in spreadsheet you can add your own colons and sheets, all of them will 
be read and converted to tiddlers with fields.
But I rename some fields names in tables
id=title
name=caption
_canonical_uri=url

the names of other fields will be same as the colons headers. All tiddlers 
from "images" sheet  will have type="image/jpeg"

All changes in spreadsheet are show on site immediately after page refresh 
F5

So you can make your own spreadsheet and test it on my site. 
External images we can share from google photos.






-- 
You received this message because you are subscribed to the Google Groups 
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/0d7ac5f2-03f2-4a15-8a64-34607324a6c7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to