Skip to content

Instantly share code, notes, and snippets.

@shrwnsan
Forked from thomxc/InsertDate.gs
Last active August 11, 2018 15:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save shrwnsan/8d5126477e509b627b2d50107bd0e2ba to your computer and use it in GitHub Desktop.
Save shrwnsan/8d5126477e509b627b2d50107bd0e2ba to your computer and use it in GitHub Desktop.
Google Docs Script Macro: Insert Timestamp (default to HKT/Beijing timezone)
/**
* 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 Timestamp', '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(), "HKT", "yyyy-MM-dd'T'HH:mm:ss'Z'"); // GMT, "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.');
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment