Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><a href="https://docs.google.com/templates" rel="nofollow">Google Docs Templates</a> should work quite nicely for this. They will prefill with both editable text and whatever scripts you wish to be associated with the document. Just hit the <code>Submit a template</code> button in the upper right corner of the page and select the document you're looking to share.</p> <p><strong>EDIT</strong> to answer question from comments:</p> <p>Believe it or not, the script will be installed along with the document! If you need the script to run the first time the user opens the sheet, use <code>onInstall()</code>. For an example of using the Drive Templates Gallery to install scripts that go along with Drive files (spreadsheet in this case), check out <a href="http://www.attendtime.com" rel="nofollow">attendtime.com</a>. In fact, Google actually recommends doing this in their <a href="https://developers.google.com/apps-script/publishing_gallery?hl=en" rel="nofollow">documentation</a>:</p> <blockquote> <p>If your script depends upon a spreadsheet being formatted in a particular way or covers a very specific use case, then submitting a spreadsheet template that includes the script could be a better option. The Google Apps Script team has submitted some examples of spreadsheet templates that contain scripts.</p> </blockquote> <p>They even have some examples of using the gallery for distributing scripts that go along with documents/spreadsheets <a href="https://developers.google.com/apps-script/templates?csw=1" rel="nofollow">here</a>!</p>
    singulars
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload