@Mat - How do/did you specify tiddlername as a value to a taget cell/row in a google spreadsheet?

[Måns]

Hi Mat

I almost managed to copy your message button* into my own wiki (and my own google form/spreadsheet of course...) - except I haven't managed to make it work pr. tiddler name yet.

Will you please give me a hint? (or a simple step by step tutorial ;.))

Cheers Måns Mårtensson

*) http://twaddle.tiddlyspot.com

[Mat]

Hi Måns!

First; I think justingale.com is where I found a lot of the critical info for this.

(BTW, In the process of building the contact form for TWaddle, I also found a few googledocs-for-teachers applications for this that might be of value for you as a teacher: here are some: link1, link2, link3 )

Ok, if your question needs the steps before the "justingale" info;

I assume you've found the tiddler $:/_TWaddle/Buttons/Comment . This is part of the viewtoolbar (i.e tagged $:/tags/ViewToolbar ). This is premise so that the title can be sent along to the googledoc.

The iframe is surrounded by a varswidget that takes the current tiddler title;

<$vars tid={{!!title}}>
<iframe src=<<googtid>> scrolling="no" frameborder="1px" overflow="hidden" width="550px" height="500px" >Loading iframe...</iframe>
</$vars>

...and the <<googtid>> macro, uses this "tid" as an argument into a cell in the spreadsheet:

\define googtid()
https://docs.google.com/forms/d/1wEJjx36te-VgjYfPutu0L71rO6kvIW1oC5abA9enMXQ/viewform?entry.2087188739=$(tid)$&entry.507569536?embedded=true
\end

Just to make sure theres no misunderstanding: In the resulting spreadsheet you get a new row for each posting people make, also if it is regarding the same tiddler. This is preferable, and it is merely a matter of sorting by name in the "tiddler title" column in the spreadsheet to get all comments regarding a specific tiddler.

The particular url syntax is, I assume, part of Googles API. The justingale link should lead you to an explanation for this.

Hope this is of help. Tell me how it works out.

<:-)

[Danielo Rodríguez]

Sorry for being so direct, but, what are you talking about?

It's some kind of commenting system based on Google spreadsheet?

Regards

[Mat]

On Sunday, September 27, 2015 at 5:10:41 PM UTC+2, Danielo Rodríguez wrote:

Sorry for being so direct, but, what are you talking about?

It's some kind of commenting system based on Google spreadsheet?

Hehe, no reason to excuse yourself. Yes, Måns is asking about my commenting system on TWaddle, i.e the "talk bubble" you see in each tiddler. It is a popup that shows an iframe with a clipped out text field from a Google Form. When the visitor comments and clicks Send and I get the comment and (automatically) the title of the concerned tiddler into a Google Sheet. Måns question was how the tiddler title was sent along.

I intend to make a proper writeup how to set this up.

<:-)

[Zaphod Beeblebrox]

Hiya, Mat :)

Just wondering if you ever had time to write up a detailed walk-through on how to set up this amazing (to me, anyway :P ) 'feature' so us unlearned neophytes could add it to our TW's?

I notice you said that a premise was it being part of the ViewToolbar - Hopefully it can be implemented outside of that, as I don't currently use it.

--Zaphod