http://www.zoliblog.com/2008/04/28/spreadsheet-macros-and-pivot-tables-google-says-no-editgrid-says-no-zoho-just-does-it/
It is so happened that I have both accounts. A University
one - that let me create scripts and publish them and use them and also a
public one that does not allow not only to edit scripts but also to use already
prepared scripts.
So generally what happened.
Using my University account - I create spreadsheet document. Put there a
button. Link the button to a script that shows some data from the spreadsheet.
Save the document. Allow an access to the document to users from University
domain.
As a results the users have an access to the spreadsheet. Are able to press the
button and to see the resulting msgbox with some data from the spreadsheet.
Also I allowed an access to the same document to my own account that is a
public one (that by the way is also a public googledocs account).
The access works well. The public user can open a document but scripts are
disabled there.
So the permitted public user sees the image of the button but unable to call
the script.
Postulate:
Based on unknown reasons Google does not allow for public user to create and
edit scripts at Google docs.
Question Google team:
If you allow us (University's users) to create and edit gogledocs' scripts why
not to allow for public users at least to use already written scripts.
In my case
In order to put online a simple questioner, flash card kind of trainer - I have
to by a domain name - pay for account - have MySQL set - learn JavaScript -
Upload text files with Questions-Answers pairs - establish some kind of
registering system for my students-just to allow them to play question-answer
game.
In Google docs all these is already in place - and I only need to write script
that ask from one column and answer from another.
Conclusion:
If Googledocs team will allow public users to use googledocs with scripts
written by customers from Universities domains. Not to edit these scripts but
just to use them. Just make these scripts Enabled for USE. This would be a
great idea.
We won’t need to use MS Excel anymore
EditGrid and Zoho will just envy.
|