{"id":1161,"date":"2016-02-24T17:49:08","date_gmt":"2016-02-24T09:49:08","guid":{"rendered":"http:\/\/potterdreams.com\/clay\/?page_id=1161"},"modified":"2016-02-24T17:49:08","modified_gmt":"2016-02-24T09:49:08","slug":"google-script","status":"publish","type":"page","link":"https:\/\/potterdreams.com\/clay\/interest\/programmings\/google-script\/","title":{"rendered":"Google Script"},"content":{"rendered":"<p>Script Editor<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Script Editor<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":103,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-1161","page","type-page","status-publish","hentry"],"jetpack-related-posts":[{"id":1165,"url":"https:\/\/potterdreams.com\/clay\/interest\/programmings\/google-script\/how-to-write-to-a-column-cell\/","url_meta":{"origin":1161,"position":0},"title":"How to Write to A Cell of Last Row","author":"clay","date":"February 24, 2016","format":false,"excerpt":"function fillCols() { var lastRow = SpreadsheetApp.getActiveSpreadsheet().getLastRow(); SpreadsheetApp.getActiveSheet().getRange('V'+lastRow).setValue('English'); }","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1163,"url":"https:\/\/potterdreams.com\/clay\/interest\/programmings\/google-script\/how-to-add-command-button\/","url_meta":{"origin":1161,"position":1},"title":"How to Add Command Button","author":"clay","date":"February 24, 2016","format":false,"excerpt":"\/** * Adds a custom menu to the active spreadsheet, containing a single menu item * for invoking the readRows() function specified above. * The onOpen() function, when defined, is automatically invoked whenever the * spreadsheet is opened. * For more information on using the Spreadsheet API, see * https:\/\/developers.google.com\/apps-script\/service_spreadsheet\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages\/1161","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/comments?post=1161"}],"version-history":[{"count":0,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages\/1161\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages\/103"}],"wp:attachment":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/media?parent=1161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}