Hi Mat This looks like real magic to me :-)
Some years ago I made tiddler templates for csv data in google sheets collected from forms, to present the data better. This example of yours is really close to be what I needed then - and my head starts hurting when I think of how this might help me and my colleagues today.. Very often we have to find our way in various spreadsheets and read several lines of comments presented in single cells... I need to think of ways to automate import from Google spreadsheets, and get updates - into TW and have a way to write back to the spreadsheet from the TW.. This seems to be quite possible with your example. Thank you for reverse engineering the fabulous web shop - it looks very promising :-) Cheers Måns ons. 10. feb. 2021 kl. 12.48 skrev Mat <[email protected]>: > I deleted previous post that contained the attached file because I have > now updated it - try out the attached file here. Now it is basically a > normal TW but it has leftover tiddlers from Siniy-Kits (incredible) shop. > > This could enable many things: community voting, teachers could make tests > and have the results in TW, a common plugin distribution system, present > stock quotes in TW, and loads and loads more. Google does the horse work, > TW just extracts the finished data and presents it. > > On Tuesday, February 9, 2021 at 8:26:02 PM UTC+1 Mark S. wrote: > >> All I see in the code he shows is making a single, empty tiddler. I'm >> missing how the data comes in. >> >> On Tuesday, February 9, 2021 at 10:36:59 AM UTC-8 Mat wrote: >> >>> @Mark , thanks for your input! I don't know how Siniy-Kits solution >>> works other than vaguely understanding what he explains >>> <https://groups.google.com/g/tiddlywiki/c/xQJ_J0AVyfM/m/G8UFicZnAQAJ>. >>> But it is worth noting that "all that is needed" is some mechanism in TW >>> that can "pull in" a JSON webpage: Here >>> <https://docs.google.com/spreadsheets/d/1QUoZosiS3emBQNM_HugaptU5qY1Ze5lBQXVd8yZit6A/edit#gid=1720443340> >>> is the regular Google sheet and here >>> <https://spreadsheets.google.com/feeds/cells/1QUoZosiS3emBQNM_HugaptU5qY1Ze5lBQXVd8yZit6A/1/public/full?alt=json>is >>> its automatically generated JSON version. >>> >>> About a "ban list"; maybe the shop blocks people who have misbehaved? >>> >>> <:-) >>> >>> >>> On Tuesday, February 9, 2021 at 6:24:04 PM UTC+1 Mark S. wrote: >>> >>>> In my experience, most programmers would rather rewrite something >>>> rather than reverse engineer an existing product. >>>> >>>> When I follow the code, I see that there is some type of call back. I'm >>>> guessing Google calls back to a function inside TW with the requested data. >>>> But, the only place I see where the results could manifest is in *function >>>> ok* -- but all that function does is check a ban list. Which is also >>>> confusing. If the data in the spreadsheet is your own, why would your email >>>> be on a ban list ?? In any event, I don't see that the data is handed off >>>> anywhere to the rest of the tiddlywiki machinery. Do you know ? >>>> >>>> Have fun! >>>> >>>> On Monday, February 8, 2021 at 8:59:37 AM UTC-8 Mat wrote: >>>> >>>>> I want to bring attention to a post I made here in the dev group >>>>> <https://github.com/Jermolene/TiddlyWiki5/discussions/5482> (because >>>>> it goes beyond direct TW matters). >>>>> >>>>> Briefly, it is possible to use the Google "Excel" spreadsheets as >>>>> tiddlers. >>>>> So your empty (or half empty) TW fetches tiddlers from the spreadsheet. >>>>> >>>>> This would open up for very useful stuff - both for individuals >>>>> (assuming they have a google account) but also for the community at large. >>>>> >>>>> For example, I think that if *anyone* puts up a public wiki with this >>>>> functionality, then *you* can make that wiki show your spreadsheet >>>>> tiddlers (by providing it with your spreadsheet-URL). This means that we >>>>> can "publish" plugins etc by piggybacking on other public wikis (if they >>>>> have this Google Drive solution installed) >>>>> >>>>> Or you can, yourself, use e.g Google Forms to make questionnaires and >>>>> have all the results appear in your own wiki. (This is foremost thanks to >>>>> Googles automated "questionnaire-to-single-spreadsheet" feature.) >>>>> >>>>> The incredible part is that fellow tiddleur *Siniy-Kit has already >>>>> created this*! But he has it baked into a bigger project. So I need >>>>> help to pick out the critical js parts and refine it. See the dev >>>>> group discussion >>>>> <https://github.com/Jermolene/TiddlyWiki5/discussions/5482> for >>>>> further details. >>>>> >>>>> <:-) >>>>> >>>> -- > 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 view this discussion on the web visit > https://groups.google.com/d/msgid/tiddlywiki/c2270d4b-1223-4b85-92d1-48885713ba64n%40googlegroups.com > <https://groups.google.com/d/msgid/tiddlywiki/c2270d4b-1223-4b85-92d1-48885713ba64n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/CAK3VnJQfybD2KV%3DtHOuuiODzmN_cNpPAtq2TaRdSvrvVwwxqNQ%40mail.gmail.com.
