Skip to content

Instantly share code, notes, and snippets.

@thomxc
Created April 2, 2014 08:17
Show Gist options
  • Save thomxc/9930038 to your computer and use it in GitHub Desktop.
Save thomxc/9930038 to your computer and use it in GitHub Desktop.
Google Docs Script Macro: Insert Date
/**
* The onOpen function runs automatically when the Google Docs document is
* opened. Use it to add custom menus to Google Docs that allow the user to run
* custom scripts. For more information, please consult the following two
* resources.
*
* Extending Google Docs developer guide:
* https://developers.google.com/apps-script/guides/docs
*
* Document service reference documentation:
* https://developers.google.com/apps-script/reference/document/
*/
function onOpen() {
// Add a menu with some items, some separators, and a sub-menu.
DocumentApp.getUi().createMenu('Utilities')
.addItem('Insert Date', 'insertAtCursor')
.addToUi();
}
/**
* Inserts the sentence "Hey there!" at the current cursor location in boldface.
*/
function insertAtCursor() {
var cursor = DocumentApp.getActiveDocument().getCursor();
if (cursor) {
// Attempt to insert text at the cursor position. If insertion returns null,
// then the cursor's containing element doesn't allow text insertions.
var date = Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd"); // "yyyy-MM-dd'T'HH:mm:ss'Z'"
var element = cursor.insertText(date);
if (element) {
element.setBold(true);
} else {
DocumentApp.getUi().alert('Cannot insert text at this cursor location.');
}
} else {
DocumentApp.getUi().alert('Cannot find a cursor in the document.');
}
}
@denispeplin
Copy link

denispeplin commented Jan 28, 2017

I Google Spreadsheet it raises an error: Cannot call DocumentApp.getUi() from this context. (line 17, file "Date Macro")

@MGCodeSnips
Copy link

This works really well. Been looking for a way to output the day too. For example Monday. the formatDate does not seem to support dddd for day.

Would you be able to update the code so it outputs the weekday "name" too?

Thanks for this.

@muneebaahmad
Copy link

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment