Re: [tw] Re: [TW5] Using jQuery to fetch JSON (tiddlers) directly from Google Sheets?

2016-04-29 Thread DesignWriteX SteveSchneider
Hey folks, this all looks very intriguing, and I hope to work with it in the next week or two. What it makes possible is, among other things, allowing individuals to write tiddlers from google forms, and allowing all many ifttt.com channels to write tiddlers by appending rows to google

[tw] Re: [TW5] Using jQuery to fetch JSON (tiddlers) directly from Google Sheets?

2016-04-29 Thread Jed Carty
You can parse the json object returned by the xmlhttprequest in my example. It isn't as simple but it is possible. -- 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

[tw] Re: [TW5] Using jQuery to fetch JSON (tiddlers) directly from Google Sheets?

2016-04-29 Thread Mat
Here are some bookmarks on using Google Sheets as backend db for TW. I briefly looked into this matter as I was creating the commenting system for TWaddle (which you can see there) that uses an iframe with a

[tw] Re: [TW5] Using jQuery to fetch JSON (tiddlers) directly from Google Sheets?

2016-04-29 Thread sini-Kit
Hi! I continue my experiments. I make google form with password field, this form puts its fields to first hidden table. And... I make second PUBLIC google table, which take all fields from hidden table *except password row*. So my password is hidden in goodle form (and nobody can get it) .

Re: [tw] Re: [TW5] Using jQuery to fetch JSON (tiddlers) directly from Google Sheets?

2016-04-26 Thread Jeremy Ruston
Hi Sini-Kit > Hi! Test button don't work. I try in IE and Chrome. google sheets API use > keys. So all the examples on .NET and Java (server need). But we can add > information to table without keys using google forms and connecting them to > google sheets, but we cant delete or modify old,

[tw] Re: [TW5] Using jQuery to fetch JSON (tiddlers) directly from Google Sheets?

2016-04-25 Thread Martian
Hi Jed! There is a description how to add and to update rows in Google Sheets with simple POST requests https://developers.google.com/google-apps/spreadsheets/data#add_a_list_row But before doing this some Auth process should be done, so it could be a little tricky. But this is definitely a

[tw] Re: [TW5] Using jQuery to fetch JSON (tiddlers) directly from Google Sheets?

2016-04-25 Thread sini-Kit
we can use Api in spreadsheet https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet For example if we put this code to scripts it will send e-mail with last row function sendMail() { //test_mail-название листа в таблице var sheet =

[tw] Re: [TW5] Using jQuery to fetch JSON (tiddlers) directly from Google Sheets?

2016-04-25 Thread Jed Carty
That is all the test button does right now. The interesting things I have done are more on the back end where it uses web workers so it doesn't hurt the performance of the wiki when you are loading things from slow sites. Since things are mostly hidden from normal use now I posted in the dev

[tw] Re: [TW5] Using jQuery to fetch JSON (tiddlers) directly from Google Sheets?

2016-04-24 Thread sini-Kit
Hi! Test button don't work. I try in IE and Chrome. google sheets API use keys. So all the examples on .NET and Java (server need). But we can add information to table without keys using google forms and connecting them to google sheets, but we cant delete or modify old, and BUT we can add new

[tw] Re: [TW5] Using jQuery to fetch JSON (tiddlers) directly from Google Sheets?

2016-04-24 Thread Jed Carty
Birthe and sini-Kit, Thank you both! I am terrible at keeping track of my things. I have some time today so I have been working on this a bit. I have a widget to submit data and a widget to fetch data. It doesn't do anything with the fetched data yet and it just uses a static url so it isn't

[tw] Re: [TW5] Using jQuery to fetch JSON (tiddlers) directly from Google Sheets?

2016-04-23 Thread sini-Kit
I have found an interesting bug. if we use /*list*/ and we have empty line in our table it is *not possible* to get data *under* this empty line. But with /cells/ we can see all table with empty rows. -- You received this message because you are subscribed to the Google Groups

[tw] Re: [TW5] Using jQuery to fetch JSON (tiddlers) directly from Google Sheets?

2016-04-23 Thread 'Birthe C' via TiddlyWiki
Hi Jed, I think you mentioned something here: https://groups.google.com/d/msg/tiddlywiki/_v4CYU5Hx-Q/gGP3_9fBGAAJ Birthe On Saturday, April 23, 2016 at 8:49:18 AM UTC+2, Jed Carty wrote: > > I did a bit with this for twederation. I have a widget that will submit > data to a google form and

[tw] Re: [TW5] Using jQuery to fetch JSON (tiddlers) directly from Google Sheets?

2016-04-22 Thread sini-Kit
My idea was to save all new tiddlers TW5 to spreadsheets and load them from spreadsheets when wiki start. And I want to do it without API, not to use server code and keys. I know how to save tiddler to google sheets in tw5, but i don't know how to load them in correct way:) суббота, 23

[tw] Re: [TW5] Using jQuery to fetch JSON (tiddlers) directly from Google Sheets?

2016-04-22 Thread Devin Weaver
On Sunday, April 3, 2016 at 2:44:53 PM UTC-4, Hegart Dmishiv wrote: > > Professor Schneider at *{{DesignWrite}}* has recently shared a link to this > blog post , which > suggests it is possible to access the information in a Google Sheet as