Added to TW-Scripts

On Friday, March 8, 2019 at 3:13:56 PM UTC+3:30, Siniy-Kit wrote:
>
> Here is my google table +gs script in it   
> https://docs.google.com/spreadsheets/d/1LJKSexFKRh6EpWeDTvgbYNBZhhf-TmV3E7c0PvVdS-s/copy
>   
> this table generates this shop  
> http://heeg.ru/shop.html?id=1LJKSexFKRh6EpWeDTvgbYNBZhhf-TmV3E7c0PvVdS-s  
> <http://heeg.ru/shop.html?id=1LJKSexFKRh6EpWeDTvgbYNBZhhf-TmV3E7c0PvVdS-s>
>  this shop gets orders by google form to this table 
> https://docs.google.com/spreadsheets/d/1cEUxBevucIvfwj1g8ctD2C4uAIsN90M44ynLLf9aScw/
>   
> <https://docs.google.com/spreadsheets/d/1cEUxBevucIvfwj1g8ctD2C4uAIsN90M44ynLLf9aScw/>
> and to e-mail  it too + *all images are stored on google drive*
>
> people make their free shops on the copy of my table 
>
> http://heeg.ru/shop.html?id=1DD9IP_RoLnl1OQcm4Sv1wZoRXvh6T5qX-XWRDgZ_oyw
>
> http://heeg.ru/shop.html?id=1HNoM8QaUHaTW-VrEp1O09HOLxtd8AGYhnjj0NXUMzfk#Alize
>  
> <http://heeg.ru/shop.html?id=1HNoM8QaUHaTW-VrEp1O09HOLxtd8AGYhnjj0NXUMzfk&[email protected]#Alize>
> heeg.ru/shop.html?id=10w0zQ37mWcwXSmatlbD02WFZbUd6OshGyrTVQxzFKkQ
> heeg.ru/shop.html?id=1QB_jyZynuO0QmhN1h5G_IiJS3HKzh_hdxaGcQTq27l0
> heeg.ru/shop.html?id=1d3-vtkbY0MN7RYpgBWZTCxRpCDf6FGKrRLf5QvP0dG0
> heeg.ru/shop.html?id=1C2KZ8EL_N7uw8iENznfYdFEBl_BDSRWCHZKwiRp8ltE
> heeg.ru/shop.html?id=10wrJi7oexkwMqU44ihvbsI9xUfIygh8TTK2W8RBe4vE
> heeg.ru/shop.html?id=1EGIqVS5mBZ0Gwit84NLSFM3L5G9i4fc1FWgU1zWYSno#about_cms
> heeg.ru/shop.html?id=1NKHiZoESe9Q5no3C53G1yHbCccTZB-cDzewAvOogZHQ
>
>
> here is Russian  tutorial https://youtu.be/C93SfZrfDIQ  
>
> here is google table shop demo with 12000+ ITEMS  
> http://heeg.ru/shop_test29.html
> table 
> https://docs.google.com/spreadsheets/d/1b3CFfclMbQEQyJXVAz4yrqOiUS3vL_5jt-85ku0E9Ck/
>
>
> <http://heeg.ru/shop.html?id=1LJKSexFKRh6EpWeDTvgbYNBZhhf-TmV3E7c0PvVdS-s>
> среда, 20 февраля 2019 г., 12:38:37 UTC+3 пользователь CHUN LI написал:
>>
>> Hi Jeremy,
>>
>> Thanks for the guide and I will see how far I can go.
>>
>> May I ask a further question? Can a blank TW file also be created by 
>> publishing a Google web app? I guess it is about the fundamental 
>> requirements of creating a TW file vs. the limitation of GAS? 
>>
>> (I read about Web app on GAS from 
>> https://developers.google.com/apps-script/guides/web)
>>
>> So I am thinking, 
>>
>>    1. Create a Google spreadsheet on my Google drive.
>>    2. Open Script Editor from the 'Tools' tab in the Google spreadsheet.
>>    3. Add (write) all the necessary .js, .html, .css code in my TW.html 
>>    file. Please see a screenshot attached below. GAS use .html file to store 
>>    all these three types of files. 
>>    4. Use a .gs file, e.g. getData.gs, to read all the data from the 
>>    Google spreadsheet. The data can be used to create a .json tiddler, and 
>>    create tiddlers.
>>    5. Publish as a web app.
>>    6. The Google spreadsheet can be updated using a Google form. The 
>>    form can also be a tiddler and be used to edit (add) tiddlers. 
>>    7. Multiple users can work on the Google spreadsheet. Their Google 
>>    logins will be collected and used as tiddler authors.
>>
>> [image: Screen Shot 2019-02-20 at 10.12.53 PM.png]
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Thanks,
>>
>> Chun
>>
>>
>> On Wednesday, February 20, 2019 at 12:25:32 AM UTC+13, Jeremy Ruston 
>> wrote:
>>>
>>> Hi Chun
>>>
>>> As I have been using Google Apps Scripts (GAS) and knowing TiddlyWiki 
>>> for about 1 year, I am trying to find out the possibilities of (re) writing 
>>> TiddlyWiki in GAS. The HTML services in GAS allows client side javascript, 
>>> CSS and HTML (https://developers.google.com/apps-script/guides/html). 
>>> Google Sheets might be a place to store (or keep a copy of) tiddlers, or be 
>>> used to produce a data tiddler. Google also has this (
>>> https://developers.google.com/apps-script/api/quickstart/nodejs) to 
>>> make node.js commands to GAS API.  
>>>
>>>
>>> Thanks! I think you are correct, there is a fascinating opportunity to 
>>> make an adaptation of TW that is served by GAS and can save changes back to 
>>> it. It would be a nice straightforward user experience too.
>>>
>>> I think the easiest way to get started would be to create a new 
>>> syncadaptor that loads and saves tiddlers via the GAS APIs. Then one could 
>>> serve a blank TW file that includes that plugin, and at startup it would 
>>> load the required tiddlers from the server. The next step might be to bake 
>>> tiddlers into the HTML file when it is first served.
>>>
>>> I'm not sure that I will personally have time to investigate this 
>>> opportunity in the near future, but I'd be very happy to help guide other 
>>> developers who might want to take up the challenge...
>>>
>>> Best wishes
>>>
>>> Jeremy
>>>
>>>
>>>
>>>
>>>  
>>> Did I misunderstand anything? Or this sounds like a plan? Sorry if I 
>>> overlooked the Copyright of Tiddlywiki as I don't intend to do so. 
>>>
>>> Thanks!
>>>
>>> Chun 
>>>
>>> -- 
>>> 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/97145418-d172-42b5-aaff-c6b170c7d4ca%40googlegroups.com
>>>  
>>> <https://groups.google.com/d/msgid/tiddlywiki/97145418-d172-42b5-aaff-c6b170c7d4ca%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>>

-- 
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/e1856df5-7f79-4466-8c6e-9d9cf0708b5a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to