Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff08Google Sheets\uff09\u3067\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u9069\u5207\u306b\u7ba1\u7406\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u306e\u8ffd\u8de1\u6027\u3068\u4fe1\u983c\u6027\u304c\u5927\u5e45\u306b\u5411\u4e0a\u3057\u307e\u3059\u3002\u672c\u8a18\u4e8b\u3067\u306f\u3001NOW\u95a2\u6570\u3084\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc\u3092\u4f7f\u3063\u305f\u624b\u52d5\u5165\u529b\u65b9\u6cd5\u304b\u3089\u3001Google Apps Script\uff08GAS\uff09\u306b\u3088\u308b\u5b8c\u5168\u81ea\u52d5\u5316\u3001\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u3084\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306e\u8003\u616e\u4e8b\u9805\u307e\u3067\u3001\u5b9f\u52d9\u3067\u5373\u5ea7\u306b\u6d3b\u7528\u3067\u304d\u308b\u5305\u62ec\u7684\u306a\u30c6\u30af\u30cb\u30c3\u30af\u3092\u8a73\u3057\u304f\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n
\u6b63\u78ba\u306a\u6642\u523b\u8a18\u9332\u306b\u3088\u308a\u3001\u696d\u52d9\u30d7\u30ed\u30bb\u30b9\u306e\u53ef\u8996\u5316\u3068\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u7ba1\u7406\u3092\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002<\/p>\n
\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u306e\u624b\u52d5\u5165\u529b\u306b\u306f\u3001\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc\u3084\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u304c\u3042\u308a\u3001\u7528\u9014\u306b\u5fdc\u3058\u3066\u6700\u9069\u306a\u624b\u6cd5\u3092\u9078\u629e\u3067\u304d\u307e\u3059\u3002<\/b><\/span> \u9759\u7684\u306a\u6642\u523b\u8a18\u9332\u304c\u5fc5\u8981\u306a\u5834\u5408\u306f\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc\u3001\u52d5\u7684\u306a\u66f4\u65b0\u304c\u5fc5\u8981\u306a\u5834\u5408\u306f\u95a2\u6570\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n \u624b\u52d5\u3067\u306e\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u5165\u529b\u306f\u3001\u6700\u3082\u30b7\u30f3\u30d7\u30eb\u3067\u78ba\u5b9f\u306a\u65b9\u6cd5\u3067\u3059\u3002\u7279\u306b\u3001\u30c7\u30fc\u30bf\u5165\u529b\u6642\u70b9\u306e\u6b63\u78ba\u306a\u6642\u523b\u3092\u8a18\u9332\u3057\u305f\u3044\u5834\u5408\u3084\u3001\u5f8c\u304b\u3089\u6642\u523b\u304c\u5909\u66f4\u3055\u308c\u306a\u3044\u3053\u3068\u3092\u4fdd\u8a3c\u3057\u305f\u3044\u5834\u5408\u306b\u9069\u3057\u3066\u3044\u307e\u3059\u3002\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc\u3092\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u7d20\u65e9\u304f\u6b63\u78ba\u306a\u6642\u523b\u5165\u529b\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n \u3053\u308c\u3089\u306e\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u3067\u5165\u529b\u3055\u308c\u305f\u5024\u306f\u9759\u7684\u306a\u30c6\u30ad\u30b9\u30c8\u3068\u3057\u3066\u4fdd\u5b58\u3055\u308c\u3001\u30b7\u30fc\u30c8\u3092\u518d\u8a08\u7b97\u3057\u3066\u3082\u5909\u66f4\u3055\u308c\u307e\u305b\u3093\u3002<\/b><\/span>\u3053\u306e\u7279\u6027\u306b\u3088\u308a\u3001\u30c7\u30fc\u30bf\u306e\u4f5c\u6210\u6642\u523b\u3084\u66f4\u65b0\u6642\u523b\u3092\u78ba\u5b9f\u306b\u8a18\u9332\u3067\u304d\u307e\u3059\u3002<\/p>\n NOW( )\u95a2\u6570\u306f\u73fe\u5728\u306e\u65e5\u6642\u3092\u3001TODAY( )\u95a2\u6570\u306f\u73fe\u5728\u306e\u65e5\u4ed8\u3092\u8fd4\u3057\u307e\u3059\u304c\u3001\u30b7\u30fc\u30c8\u304c\u518d\u8a08\u7b97\u3055\u308c\u308b\u305f\u3073\u306b\u5024\u304c\u66f4\u65b0\u3055\u308c\u308b\u70b9\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002<\/b><\/span> \u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u8868\u793a\u306b\u306f\u9069\u3057\u3066\u3044\u307e\u3059\u304c\u3001\u8a18\u9332\u7528\u9014\u306b\u306f\u5de5\u592b\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n \u57fa\u672c\u7684\u306a\u4f7f\u7528\u65b9\u6cd5\uff1a<\/strong><\/p>\n =NOW( )\u00a0 \u00a0\/\/ \u73fe\u5728\u306e\u65e5\u6642\u3092\u8868\u793a\uff08\u4f8b\uff1a2024\/11\/15 14:30:25\uff09<\/p>\n =TODAY( )\u00a0 \u00a0 \/\/ \u73fe\u5728\u306e\u65e5\u4ed8\u306e\u307f\u8868\u793a\uff08\u4f8b\uff1a2024\/11\/15\uff09<\/p>\n \u9759\u7684\u306a\u5024\u306b\u5909\u63db\u3059\u308b\u65b9\u6cd5\uff1a<\/strong><\/p>\n \u6642\u523b\u306e\u307f\u3092\u62bd\u51fa\u3059\u308b\u5834\u5408\uff1a<\/strong><\/p>\n =NOW()-TODAY()\u00a0 \u00a0 \/\/ \u6642\u523b\u90e8\u5206\u306e\u307f\u62bd\u51fa<\/p>\n =TEXT(NOW(),”HH:mm:ss”)\u00a0 \u00a0 \/\/ \u6642\u523b\u3092\u6587\u5b57\u5217\u3068\u3057\u3066\u8868\u793a<\/p>\n \u72ec\u81ea\u306e\u8981\u4ef6\u306b\u5408\u308f\u305b\u305f\u30ab\u30b9\u30bf\u30e0\u95a2\u6570\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u67d4\u8edf\u306a\u6642\u523b\u8a18\u9332\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/b><\/span><\/p>\n \u66dc\u65e5\u3092\u542b\u3080\u8a73\u7d30\u8868\u793a\uff1a<\/strong><\/p>\n =TEXT(NOW(),”yyyy\u5e74MM\u6708dd\u65e5(ddd) HH:mm:ss”)<\/p>\n \u6761\u4ef6\u4ed8\u304d\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\uff08\u53cd\u5fa9\u8a08\u7b97\u3092\u5229\u7528\uff09\uff1a<\/p>\n =IF(A2<>””, IF(B2=””, NOW(), B2), “”)<\/p>\n \u4f7f\u7528\u524d\u306b \u30d5\u30a1\u30a4\u30eb \u2192 \u8a2d\u5b9a \u2192 \u8a08\u7b97 \u3067 \u300c\u53cd\u5fa9\u8a08\u7b97\u3092\u6709\u52b9\u306b\u3059\u308b\u300d\u3092\u30aa\u30f3\u3001\u6700\u5927\u53cd\u5fa9\u56de\u6570\uff1d1 \u7b49\u306b\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n \u305d\u3046\u3059\u308b\u3068\u3001A2 \u306b\u5024\u304c\u5165\u3063\u305f\u77ac\u9593\u306b NOW() \u304c\u4e00\u5ea6\u3060\u3051\u5165\u308a\u3001\u305d\u306e\u5f8c\u306f B2 \u304c\u81ea\u5206\u81ea\u8eab\u306e\u5024\u3092\u4fdd\u6301\u3057\u3066\u6642\u523b\u304c\u56fa\u5b9a\u3055\u308c\u307e\u3059\u3002<\/p>\n \u203b \u53cd\u5fa9\u8a08\u7b97\u3092\u4f7f\u3044\u305f\u304f\u306a\u3044\u5834\u5408\u306f Apps Script \u306e onEdit(e) \u3067\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u8a18\u9332\u3059\u308b\u65b9\u6cd5\u304c\u5b89\u5168\u3067\u3059\u3002<\/p>\n \u5b9a\u578b\u7684\u306a\u6642\u523b\u5165\u529b\u304c\u591a\u3044\u5834\u5408\u306f\u3001\u30c7\u30fc\u30bf\u691c\u8a3c\u6a5f\u80fd\u3092\u4f7f\u7528\u3057\u3066\u9078\u629e\u5f0f\u306b\u3059\u308b\u3053\u3068\u3067\u3001\u5165\u529b\u30df\u30b9\u3092\u9632\u3052\u307e\u3059\u3002<\/b><\/span><\/p>\n GAS\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u7279\u5b9a\u306e\u30a4\u30d9\u30f3\u30c8\uff08\u7de8\u96c6\u3001\u30d5\u30a9\u30fc\u30e0\u9001\u4fe1\u7b49\uff09\u306b\u9023\u52d5\u3057\u3066\u81ea\u52d5\u7684\u306b\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u8a18\u9332\u3067\u304d\u307e\u3059\u3002<\/b><\/span> \u5b8c\u5168\u81ea\u52d5\u5316\u306b\u3088\u308a\u3001\u4eba\u70ba\u7684\u30df\u30b9\u3092\u6392\u9664\u3057\u3001\u4e00\u8cab\u6027\u306e\u3042\u308b\u6642\u523b\u8a18\u9332\u3092\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002<\/p>\n \u30b9\u30af\u30ea\u30d7\u30c8\u306b\u3088\u308b\u81ea\u52d5\u5316\u306f\u3001\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u51e6\u7406\u3084\u8907\u96d1\u306a\u6761\u4ef6\u3067\u306e\u6642\u523b\u8a18\u9332\u306b\u7279\u306b\u6709\u52b9\u3067\u3059\u3002\u30c8\u30ea\u30ac\u30fc\u6a5f\u80fd\u3068\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u300124\u6642\u9593365\u65e5\u7a3c\u50cd\u3059\u308b\u81ea\u52d5\u8a18\u9332\u30b7\u30b9\u30c6\u30e0\u3092\u69cb\u7bc9\u3067\u304d\u307e\u3059\u3002<\/p>\n \u8907\u6570\u30bb\u30eb\u5bfe\u5fdc\u30fb\u521d\u56de\u56fa\u5b9a\u30fb\u8868\u793a\u5f62\u5f0f\u6307\u5b9a\u306e\u5b89\u5168\u7248\uff08A\u5217\u7de8\u96c6\u2192B\u5217\u306b\u8a18\u9332\uff09<\/strong><\/p>\n function onEdit(e) {<\/p>\n \/\/ \u30ac\u30fc\u30c9\uff1a\u30a4\u30d9\u30f3\u30c8\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u7121\u3044\uff0f\u8907\u6570\u30bb\u30eb\u4ee5\u5916\u306e\u30b1\u30fc\u30b9\u3082\u60f3\u5b9a<\/p>\n if (!e || !e.range) return;<\/p>\n const sheet = e.range.getSheet( );\u00a0 \/\/ \u2190 e.range\u306b\u7d10\u3065\u304f\u30b7\u30fc\u30c8\u3092\u53d6\u5f97<\/p>\n const row = e.range.getRow( );<\/p>\n const col = e.range.getColumn( );<\/p>\n const h = e.range.getNumRows( );<\/p>\n const w = e.range.getNumColumns( );<\/p>\n \/\/ \u5bfe\u8c61\u30b7\u30fc\u30c8\u540d\u3067\u7d5e\u308b\u5834\u5408\uff08\u4efb\u610f\uff09<\/p>\n \/\/ if (sheet.getName() !== ‘\u5165\u529b’) return;<\/p>\n \/\/ \u5bfe\u8c61\uff1aA\u5217\u306e\u307f\u3001\u30d8\u30c3\u30c0\u30fc(1\u884c\u76ee)\u306f\u9664\u5916<\/p>\n if (col !== 1 || row === 1) return;<\/p>\n \/\/ \u7de8\u96c6\u3055\u308c\u305f\u5024\uff08\u8907\u6570\u30bb\u30eb\u5bfe\u5fdc\uff09<\/p>\n const editedValues = e.range.getValues();<\/p>\n \/\/ \u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u66f8\u304d\u8fbc\u3080\u5217\uff08B\u5217\uff09<\/p>\n const tsRange = sheet.getRange(row, 2, h, 1);<\/p>\n const tsValues = tsRange.getValues();<\/p>\n const now = new Date();<\/p>\n for (let i = 0; i < h; i++) {<\/p>\n \/\/ 1\u5217\u8cbc\u308a\u4ed8\u3051\u60f3\u5b9a\uff08A\u5217\u306e\u307f\uff09\u3002A\u5217\u306e\u5024\u3092\u53d6\u308a\u51fa\u3059<\/p>\n const v = editedValues[i][0];<\/p>\n if (v !== “”) {<\/p>\n \/\/ \u521d\u56de\u56fa\u5b9a\uff1aB\u5217\u304c\u7a7a\u306e\u3068\u304d\u3060\u3051\u66f8\u304d\u8fbc\u3080\uff08\u4e0a\u66f8\u304d\u3057\u306a\u3044\uff09<\/p>\n if (tsValues[i][0] === “”) tsValues[i][0] = now;<\/p>\n } else {<\/p>\n \/\/ A\u5217\u3092\u7a7a\u306b\u623b\u3057\u305f\u3089B\u5217\u3082\u30af\u30ea\u30a2\uff08\u904b\u7528\u306b\u5fdc\u3058\u3066\u524a\u9664\uff09<\/p>\n tsValues[i][0] = “”; }}<\/p>\n tsRange.setValues(tsValues);<\/p>\n \/\/ \u8868\u793a\u5f62\u5f0f\u3092\u660e\u793a\uff08\u4e26\u3079\u66ff\u3048\u30fb\u96c6\u8a08\u306b\u6709\u5229\uff1a\u5024\u306f\u6570\u5024\u578b\u306e\u307e\u307e\uff09<\/p>\n tsRange.setNumberFormat(“yyyy\/MM\/dd HH:mm:ss”);}<\/p>\n Google\u30d5\u30a9\u30fc\u30e0\u9023\u643a\u306e\u300c\u56de\u7b54\u300d\u30b7\u30fc\u30c8\u306f\u65e2\u5b9a\u3067\u300c\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u300d\u5217\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u5225\u30b7\u30fc\u30c8\u3078\u8ee2\u8a18<\/strong>\u3059\u308b\u904b\u7528\u306a\u3069\u3067\u72ec\u81ea\u306b\u8a18\u9332\u3057\u305f\u3044\u5834\u5408\u306e\u4f8b\u3067\u3059\u3002<\/p>\n function onFormSubmit(e) {<\/p>\n if (!e || !e.range) return;<\/p>\n const sheet = e.range.getSheet();<\/p>\n const row = e.range.getRow();<\/p>\n const tsCell = sheet.getRange(row, 2); \/\/ \u4f8b\uff1aB\u5217\u306b\u8a18\u9332<\/p>\n tsCell.setValue(new Date()).setNumberFormat(“yyyy\/MM\/dd HH:mm:ss”);}<\/p>\n \u8907\u6570\u30b7\u30fc\u30c8\u5bfe\u5fdc onEdit\uff1a\u8907\u6570\u30bb\u30eb\u5bfe\u5fdc\u30fb\u521d\u56de\u56fa\u5b9a\u30fb\u8868\u793a\u5f62\u5f0f\u6307\u5b9a<\/strong><\/p>\n function onEdit(e) {<\/p>\n if (!e || !e.range) return;<\/p>\n \/\/ \u5bfe\u8c61\u30b7\u30fc\u30c8<\/p>\n const targetSheets = [‘\u58f2\u4e0a\u30c7\u30fc\u30bf’, ‘\u5728\u5eab\u7ba1\u7406’, ‘\u9867\u5ba2\u60c5\u5831’];<\/p>\n const sheet = e.range.getSheet();<\/p>\n if (!targetSheets.includes(sheet.getName())) return;<\/p>\n const row = e.range.getRow();<\/p>\n const col = e.range.getColumn();<\/p>\n const h \u00a0 = e.range.getNumRows();<\/p>\n const w \u00a0 = e.range.getNumColumns();<\/p>\n \/\/ \u5bfe\u8c61\u7bc4\u56f2\uff1aA\u301cE\u5217\u30012\u884c\u76ee\u4ee5\u964d<\/p>\n const startCol = 1, endCol = 5;<\/p>\n if (row <= 1 || col < startCol || (col + w – 1) > endCol) return;<\/p>\n const tsCol \u00a0 = 6; \/\/ F\u5217<\/p>\n const userCol = 7; \/\/ G\u5217<\/p>\n \/\/ \u7de8\u96c6\u3055\u308c\u305f\u5024\uff08\u8907\u6570\u884c\u5bfe\u5fdc\u3001A\u301cE\u306e\u3046\u3061\u5c11\u306a\u304f\u3068\u30821\u30bb\u30eb\u306b\u5024\u304c\u3042\u308c\u3070\u8a18\u9332\uff09<\/p>\n const edited = e.range.getValues();<\/p>\n \/\/ \u65e2\u5b58\u306e\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u307e\u3068\u3081\u3066\u53d6\u5f97\uff08\u521d\u56de\u56fa\u5b9a\u306e\u305f\u3081\uff09<\/p>\n const tsRange\u00a0 = sheet.getRange(row, tsCol, h, 1);<\/p>\n const tsValues = tsRange.getValues();<\/p>\n \/\/ \u7de8\u96c6\u8005\uff08\u203b\u53d6\u5f97\u3067\u304d\u306a\u3044\u5834\u5408\u304c\u3042\u308b\uff1a\u4e0b\u8a18\u6ce8\u610f\u53c2\u7167\uff09<\/p>\n const editorEmail =<\/p>\n Session.getActiveUser().getEmail() || ”; \/\/ Workspace \u5916\u3067\u306f\u7a7a\u306b\u306a\u308b\u3053\u3068\u304c\u591a\u3044<\/p>\n const userRange\u00a0 = sheet.getRange(row, userCol, h, 1);<\/p>\n const userValues = userRange.getValues();<\/p>\n const now = new Date();<\/p>\n for (let i = 0; i < h; i++) {<\/p>\n \/\/ \u884c\u5185\u306b\u975e\u7a7a\u306e\u7de8\u96c6\u304c\u3042\u308c\u3070 true\uff08w>1 \u306e\u8cbc\u308a\u4ed8\u3051\u306b\u3082\u5bfe\u5fdc\uff09<\/p>\n const hasValue = edited[i].some(v => v !== “”);<\/p>\n if (hasValue) {<\/p>\n \/\/ \u521d\u56de\u56fa\u5b9a\uff1a\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u304c\u7a7a\u306e\u3068\u304d\u306e\u307f\u66f8\u304d\u8fbc\u3080<\/p>\n if (tsValues[i][0] === “”) tsValues[i][0] = now;<\/p>\n \/\/ \u7de8\u96c6\u8005\u306f\u5e38\u306b\u4e0a\u66f8\u304d or \u521d\u56de\u306e\u307f\u7b49\u3001\u8981\u4ef6\u306b\u5fdc\u3058\u3066\u5207\u66ff<\/p>\n userValues[i][0] = editorEmail || userValues[i][0]; \/\/ \u53d6\u5f97\u3067\u304d\u305f\u5834\u5408\u306e\u307f\u66f4\u65b0<\/p>\n } else {<\/p>\n \/\/ \u3059\u3079\u3066\u7a7a\u3067\u4e0a\u66f8\u304d\u3057\u305f\u5834\u5408\u306f\u30af\u30ea\u30a2\uff08\u904b\u7528\u306b\u5408\u308f\u305b\u3066\u7121\u52b9\u5316\u53ef\uff09<\/p>\n tsValues[i][0] \u00a0 = “”;<\/p>\n userValues[i][0] = “”;}<\/p>\n tsRange.setValues(tsValues).setNumberFormat(“yyyy\/MM\/dd HH:mm:ss”);<\/p>\n userRange.setValues(userValues);}<\/p>\n \u5b9f\u904b\u7528\u3067\u7de8\u96c6\u8005\u306e\u30e1\u30fc\u30eb\u3092\u78ba\u5b9f\u306b\u53d6\u5f97\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u578b\u30c8\u30ea\u30ac\u30fc\uff08\u30b9\u30af\u30ea\u30d7\u30c8\u30a8\u30c7\u30a3\u30bf \u2192 \u30c8\u30ea\u30ac\u30fc\uff09\u3067 onEdit \u3092\u8a2d\u5b9a\u3057\u3001Google Workspace \u74b0\u5883\u3067\u306e\u904b\u7528\u3092\u63a8\u5968\u3057\u307e\u3059\u3002\u305d\u308c\u3067\u3082\u30dd\u30ea\u30b7\u30fc\u306b\u3088\u308a\u7a7a\u306b\u306a\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\u78ba\u5b9f\u6027\u304c\u8981\u308b\u5834\u5408\u306f\u3001\u7de8\u96c6\u7528\u30d5\u30a9\u30fc\u30e0\u7d4c\u7531\u306b\u3059\u308b\u3001\u307e\u305f\u306fApps Script Web \u30a2\u30d7\u30ea\u3092\u4ecb\u3057\u305f\u66f8\u304d\u8fbc\u307f\u3067\u7f72\u540d\u4ed8\u304d\u30ea\u30af\u30a8\u30b9\u30c8\u306b\u3059\u308b\u7b49\u306e\u8a2d\u8a08\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n \u30d5\u30a9\u30fc\u30e0\u9001\u4fe1 onFormSubmit\uff1a\u30b7\u30fc\u30c8\u3092\u30a4\u30d9\u30f3\u30c8\u304b\u3089\u53d6\u5f97\u30fb\u57fa\u6e96\u5217\u3092\u56fa\u5b9a<\/strong><\/p>\n function onFormSubmit(e) {<\/p>\n if (!e || !e.range) return;<\/p>\n const sheet = e.range.getSheet();<\/p>\n const row \u00a0 = e.range.getRow();<\/p>\n const tz = Session.getScriptTimeZone(); \/\/ \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30bf\u30a4\u30e0\u30be\u30fc\u30f3<\/p>\n const now = new Date();<\/p>\n const formatted = Utilities.formatDate(now, tz, “yyyy\/MM\/dd HH:mm:ss”);<\/p>\n \/\/ \u8ffd\u8a18\u958b\u59cb\u4f4d\u7f6e\u3092\u5148\u306b\u56fa\u5b9a\uff08\u9010\u6b21 getLastColumn() \u3092\u547c\u3070\u306a\u3044\uff09<\/p>\n const baseCol = sheet.getLastColumn() + 1;<\/p>\n \/\/ \u8ffd\u52a0\u9805\u76ee\uff08\u4f8b\uff09<\/p>\n const emailFromForm = (e.namedValues && e.namedValues[‘Email’])<\/p>\n ? String(e.namedValues[‘Email’][0] || ”)\u00a0: ”;<\/p>\n \/\/ \u307e\u3068\u3081\u3066\u66f8\u304d\u8fbc\u307f<\/p>\n const values = [[<\/p>\n formatted, \/\/ \u8ffd\u52a0\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\uff08\u6587\u5b57\u5217\u8868\u793a\uff09<\/p>\n tz,\u00a0\/\/ \u30bf\u30a4\u30e0\u30be\u30fc\u30f3<\/p>\n emailFromForm, \u00a0 \/\/ \u30d5\u30a9\u30fc\u30e0\u306eEmail\u9805\u76ee\uff08\u540d\u79f0\u306f\u5b9f\u30b7\u30fc\u30c8\u306b\u5408\u308f\u305b\u3066\uff09<\/p>\n “PR-” + Utilities.formatDate(now, tz, “yyyyMMdd-HHmmss”)\u00a0 \/\/ \u51e6\u7406\u756a\u53f7]];<\/p>\n sheet.getRange(row, baseCol, 1, values[0].length).setValues(values);<\/p>\n \/\/ \u8ffd\u52a0\u3057\u305f\u6700\u521d\u306e\u5217\u3060\u3051\u6570\u5024\u578b\u3067\u6301\u3061\u305f\u3044\u5834\u5408\u306f setValue(new Date()) + setNumberFormat \u3092\u4f7f\u7528<\/p>\n \/\/ sheet.getRange(row, baseCol).setValue(now).setNumberFormat(“yyyy\/MM\/dd HH:mm:ss”);}<\/p>\n Google \u30d5\u30a9\u30fc\u30e0\u306e\u56de\u7b54\u30b7\u30fc\u30c8\u306b\u306f\u65e2\u5b9a\u3067\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u5217<\/strong>\u304c\u3042\u308b\u305f\u3081\u3001\u4e0a\u8a18\u306f\u8ffd\u52a0\u60c5\u5831<\/strong>\u304c\u5fc5\u8981\u306a\u5834\u5408\u306e\u4f8b\u3067\u3059\u3002 \u6642\u9593\u4e3b\u5c0e\u30c8\u30ea\u30ac\u30fc\u3092\u4f7f\u7528\u3057\u305f\u5b9a\u671f\u5b9f\u884c\uff1a<\/strong><\/p>\n javascript<\/p>\n function setupTimeDrivenTriggers() {<\/p>\n \/\/ 1\u6642\u9593\u304a\u304d\uff0f\u6bce\u664200\u5206\u8fd1\u8fba\u3067\u5b9f\u884c\uff08\u5b8c\u5168\u306a\u4fdd\u8a3c\u3067\u306f\u306a\u3044\uff09<\/p>\n ScriptApp.newTrigger(‘hourlyTimestamp’)<\/p>\n .timeBased()<\/p>\n .everyHours(1)<\/p>\n .nearMinute(0)<\/p>\n .create();<\/p>\n \/\/ \u4f8b\uff1a\u6bce\u65e5 00:00 \u306b\u5b9f\u884c\uff08\u78ba\u5b9a\u6642\u523b\u304c\u5fc5\u8981\u306a\u3089\u3053\u3061\u3089\uff09<\/p>\n ScriptApp.newTrigger(‘hourlyTimestampDaily’)<\/p>\n .timeBased()<\/p>\n .atHour(0)<\/p>\n .everyDays(1)<\/p>\n .create();}<\/p>\n function hourlyTimestamp() {<\/p>\n const ss = SpreadsheetApp.getActiveSpreadsheet();<\/p>\n const sheet = ss.getSheetByName(‘\u30ed\u30b0’);<\/p>\n if (!sheet) return; \/\/ \u30b7\u30fc\u30c8\u304c\u7121\u3051\u308c\u3070\u7d42\u4e86<\/p>\n const now = new Date();<\/p>\n const tz\u00a0 = Session.getScriptTimeZone();<\/p>\n \/\/ \u6b32\u3057\u3044\u6307\u6a19\u306b\u5408\u308f\u305b\u3066\u53d6\u5f97\uff08\u4f8b\uff1a\u6a29\u9650\u30e6\u30fc\u30b6\u30fc\u6570\uff09<\/p>\n const editors = ss.getEditors().length;<\/p>\n const viewers = ss.getViewers().length; \/\/ \u73fe\u5728\u306e\u95b2\u89a7\u8005\u6570\u3067\u306f\u306a\u3044\u70b9\u306b\u6ce8\u610f<\/p>\n \/\/ \u30d5\u30a1\u30a4\u30eb\u30b5\u30a4\u30ba\u306e\u4f8b\uff1aAdvanced Drive\uff08\u30b5\u30fc\u30d3\u30b9\u300cDrive\u300d\u3092\u6709\u52b9\u5316\uff09\u3067 quotaBytesUsed \u3092\u53d6\u5f97<\/p>\n \/\/ const file = Drive.Files.get(ss.getId());<\/p>\n \/\/ const bytes = Number(file.quotaBytesUsed || 0);<\/p>\n \/\/ \u4ee3\u66ff\uff1a\u884c\u6570\u00d7\u5217\u6570\u306a\u3069\u306e\u904b\u7528\u30e1\u30c8\u30ea\u30af\u30b9\u3092\u8a18\u9332<\/p>\n const usedRows = sheet.getLastRow();<\/p>\n const usedCols = sheet.getLastColumn();<\/p>\n const values = [[<\/p>\n now,<\/p>\n ‘\u30b7\u30b9\u30c6\u30e0\u81ea\u52d5\u8a18\u9332’,<\/p>\n viewers, \/\/ \u95b2\u89a7\u6a29\u9650\u30e6\u30fc\u30b6\u30fc\u6570<\/p>\n editors, \/\/ \u7de8\u96c6\u6a29\u9650\u30e6\u30fc\u30b6\u30fc\u6570<\/p>\n usedRows,<\/p>\n usedCols<\/p>\n \/\/ bytes \/\/ \u4f7f\u3046\u306a\u3089 Advanced Drive \u3092\u6709\u52b9\u5316\u3057\u3066\u4e0a\u8a18\u30b3\u30e1\u30f3\u30c8\u89e3\u9664]];<\/p>\n const targetRange = sheet.getRange(sheet.getLastRow() + 1, 1, 1, values[0].length);<\/p>\n targetRange.setValues(values);<\/p>\n \/\/ 1\u5217\u76ee\u306e\u65e5\u6642\u3060\u3051\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u56fa\u5b9a<\/p>\n sheet.getRange(targetRange.getRow(), 1).setNumberFormat(“yyyy\/MM\/dd HH:mm:ss”);}<\/p>\n \/\/ \u53e4\u3044\u30ed\u30b0\u306e\u81ea\u52d5\u524a\u9664\uff0830\u65e5\u4ee5\u4e0a\u524d\uff09<\/p>\n cleanOldLogs(sheet, 30);}<\/p>\n function cleanOldLogs(sheet, daysToKeep) {<\/p>\n const lastRow = sheet.getLastRow();<\/p>\n if (lastRow < 2) return; \/\/ \u30c7\u30fc\u30bf\u7121\u3057<\/p>\n const rng = sheet.getRange(2, 1, lastRow – 1, 1); \/\/ 1\u5217\u76ee\u306b\u65e5\u6642\u304c\u5165\u3063\u3066\u3044\u308b\u60f3\u5b9a<\/p>\n const vals = rng.getValues();<\/p>\n const cutoff = new Date(Date.now() – daysToKeep * 24 * 60 * 60 * 1000);<\/p>\n \/\/ \u6b8b\u3059\u884c\u3092\u30d5\u30a3\u30eb\u30bf\u3057\u3066\u4e00\u62ec\u3067\u66f8\u304d\u623b\u3059\u65b9\u5f0f\uff08\u9ad8\u901f\uff09<\/p>\n const keep = vals<\/p>\n .map((r, idx) => ({ row: idx + 2, value: r[0] instanceof Date ? r[0] : new Date(r[0]) }))<\/p>\n .filter(o => !(o.value < cutoff))<\/p>\n .map(o => sheet.getRange(o.row, 1, 1, sheet.getLastColumn()).getValues()[0]);<\/p>\n \/\/ \u65e2\u5b58\u30c7\u30fc\u30bf\u3092\u307e\u3068\u3081\u3066\u30af\u30ea\u30a2 \u2192 \u6b8b\u3059\u30c7\u30fc\u30bf\u3092\u518d\u66f8\u304d\u8fbc\u307f<\/p>\n if (lastRow > 1) sheet.getRange(2, 1, lastRow – 1, sheet.getLastColumn()).clearContent();<\/p>\n if (keep.length) sheet.getRange(2, 1, keep.length, keep[0].length).setValues(keep);}<\/p>\n \u203b \u884c\u6570\u304c\u975e\u5e38\u306b\u591a\u3044\u5834\u5408\u306f\u3001\u30d5\u30a3\u30eb\u30bf\u30d3\u30e5\u30fc\uff0b\u524a\u9664\u3084\u5225\u30b7\u30fc\u30c8\u3078\u30b3\u30d4\u30fc\u65b9\u5f0f\u304c\u3055\u3089\u306b\u9ad8\u901f\u3067\u3059\u3002<\/p>\n \u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u306e\u6b63\u78ba\u6027\u3068\u4e00\u8cab\u6027\u3092\u4fdd\u3064\u305f\u3081\u306b\u306f\u3001\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u8a2d\u5b9a\u3001\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306e\u7d71\u4e00\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3078\u306e\u5f71\u97ff\u3092\u8003\u616e\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/b><\/span> \u3053\u308c\u3089\u306e\u8981\u7d20\u3092\u9069\u5207\u306b\u7ba1\u7406\u3059\u308b\u3053\u3068\u3067\u3001\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u6642\u523b\u8a18\u9332\u30b7\u30b9\u30c6\u30e0\u3092\u69cb\u7bc9\u3067\u304d\u307e\u3059\u3002<\/p>\n \u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u306f\u3001\u30c7\u30fc\u30bf\u306e\u76e3\u67fb\u8a3c\u8de1\u3084\u30c8\u30ec\u30fc\u30b5\u30d3\u30ea\u30c6\u30a3\u306e\u57fa\u76e4\u3068\u306a\u308b\u305f\u3081\u3001\u305d\u306e\u7cbe\u5ea6\u3068\u6574\u5408\u6027\u306f\u6975\u3081\u3066\u91cd\u8981\u3067\u3059\u3002\u7279\u306b\u3001\u8907\u6570\u306e\u5730\u57df\u3084\u30b7\u30b9\u30c6\u30e0\u3068\u9023\u643a\u3059\u308b\u5834\u5408\u306f\u3001\u6a19\u6e96\u5316\u3055\u308c\u305f\u6642\u523b\u7ba1\u7406\u304c\u4e0d\u53ef\u6b20\u3067\u3059\u3002<\/p>\n \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3068\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u3092\u6b63\u78ba\u306b\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001\u6642\u523b\u306e\u305a\u308c\u3092\u9632\u3052\u307e\u3059\u3002<\/b><\/span> \u56fd\u969b\u7684\u306a\u30c1\u30fc\u30e0\u3067\u4f5c\u696d\u3059\u308b\u5834\u5408\u306f\u3001UTC\u57fa\u6e96\u3067\u306e\u7ba1\u7406\u3082\u691c\u8a0e\u3059\u3079\u304d\u3067\u3059\u3002<\/p>\n \u8868\u793a\u6642\u306b\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u3092\u9069\u7528\u3059\u308b\uff08\u63a8\u5968\uff09<\/strong><\/p>\n \/\/ \u4efb\u610fTZ\u3067\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3057\u3066\u8868\u793a\u7528\u6587\u5b57\u5217\u3092\u5f97\u308b<\/p>\n function formatInTZ(dt, tz, pattern) {<\/p>\n return Utilities.formatDate(dt, tz, pattern || “yyyy\/MM\/dd HH:mm:ss”);}<\/p>\n \/\/ \u4f7f\u3044\u65b9\u4f8b<\/p>\n function showTimes() {<\/p>\n const now = new Date();\u00a0 \/\/ UTC\u30d9\u30fc\u30b9\u306e\u77ac\u9593<\/p>\n const tokyo = formatInTZ(now, “Asia\/Tokyo”);<\/p>\n const utc \u00a0 = formatInTZ(now, “UTC”);<\/p>\n const ny\u00a0 \u00a0 = formatInTZ(now, “America\/New_York”);<\/p>\n const la\u00a0 \u00a0 = formatInTZ(now, “America\/Los_Angeles”);<\/p>\n SpreadsheetApp.getActiveSheet().appendRow([“Tokyo”, tokyo, “UTC”, utc, “New York”, ny, “Los Angeles”, la]);}<\/p>\n \u65b9\u91dd<\/strong>\uff1a\u30c7\u30fc\u30bf\u3068\u3057\u3066\u306f UTC \u306e Date \u3092\u4fdd\u5b58\u3057\u3001\u8868\u793a\u3084\u66f8\u304d\u51fa\u3057\u6642\u306b Utilities.formatDate \u3067\u6240\u671bTZ\u3078\u6574\u5f62<\/strong>\u3057\u307e\u3059\u3002<\/p>\n function displayMultipleTimezones() {<\/p>\n const sheet = SpreadsheetApp.getActiveSheet();<\/p>\n const now = new Date();<\/p>\n const pat = “yyyy\/MM\/dd HH:mm:ss z”; \/\/ z\u3067TZ\u7565\u79f0\u3092\u81ea\u52d5\u4ed8\u4e0e\uff08EST\/EDT\u7b49\uff09<\/p>\n sheet.appendRow([<\/p>\n ‘Tokyo (Asia\/Tokyo)’, Utilities.formatDate(now, ‘Asia\/Tokyo’, pat),<\/p>\n ‘UTC’,\u00a0 \u00a0Utilities.formatDate(now, ‘UTC’, pat),<\/p>\n ‘New York’,\u00a0 Utilities.formatDate(now, ‘America\/New_York’, pat),<\/p>\n ‘Los Angeles’, Utilities.formatDate(now, ‘America\/Los_Angeles’, pat)]);}<\/p>\n \u30e9\u30d9\u30eb\u306f \u5730\u57df\u540d or IANA TZ\u540d \u3067\u8868\u8a18\u3057\u3001\u7565\u79f0\u306f z \u3067\u81ea\u52d5\u51fa\u529b\u3059\u308b\u3068 DST \u3092\u542b\u3081\u6b63\u78ba\u3067\u3059\u3002<\/p>\n \u4e00\u8cab\u6027\u306e\u3042\u308b\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306b\u3088\u308a\u3001\u30c7\u30fc\u30bf\u306e\u6bd4\u8f03\u3084\u5206\u6790\u304c\u5bb9\u6613\u306b\u306a\u308a\u307e\u3059\u3002<\/b><\/span><\/p>\n \u30ab\u30b9\u30bf\u30e0\u8868\u793a\u5f62\u5f0f\u306e\u8a2d\u5b9a\uff1a<\/strong><\/p>\n javascript<\/p>\n function formatTimestamp(date, pattern) {<\/p>\n var patterns = {<\/p>\n ‘iso’: “yyyy-MM-dd’T’HH:mm:ss’Z'”,<\/p>\n ‘japanese’: “yyyy\/MM\/dd HH:mm:ss”,<\/p>\n ‘filename’: “yyyyMMdd_HHmmss”,<\/p>\n ‘readable’: “yyyy\u5e74MM\u6708dd\u65e5(E) HH\u6642mm\u5206ss\u79d2”};<\/p>\n return Utilities.formatDate(<\/p>\n date,<\/p>\n Session.getScriptTimeZone(),<\/p>\n patterns[pattern] || pattern);}<\/p>\n \u5927\u91cf\u306e\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u51e6\u7406\u306b\u304a\u3044\u3066\u8003\u616e\u3059\u3079\u304d\u70b9<\/strong><\/p>\n \u907f\u3051\u308b\u3079\u304d\u30d1\u30bf\u30fc\u30f3\uff1a<\/strong><\/p>\n javascript<\/p>\n \/\/ \u500b\u5225\u306b\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u8a2d\u5b9a\uff08\u975e\u52b9\u7387\uff09<\/p>\n for (var i = 0; i < 1000; i++) {<\/p>\n sheet.getRange(i + 1, 1).setValue(new Date());}<\/p>\n \u63a8\u5968\u30d1\u30bf\u30fc\u30f3\uff1a<\/strong><\/p>\n javascript<\/p>\n \/\/ \u30d0\u30c3\u30c1\u51e6\u7406\u3067\u4e00\u62ec\u8a2d\u5b9a\uff08\u52b9\u7387\u7684\uff09<\/p>\n var timestamps = [];<\/p>\n var now = new Date();<\/p>\n for (var i = 0; i < 1000; i++) {<\/p>\n timestamps.push([now]);}<\/p>\n sheet.getRange(1, 1, timestamps.length, 1).setValues(timestamps);<\/p>\n \u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u306e\u6539\u3056\u3093\u9632\u6b62\u3068\u76e3\u67fb\u8a3c\u8de1\u306e\u78ba\u4fdd\uff1a<\/strong><\/p>\n javascript<\/p>\n function createAuditLog(action, details) {<\/p>\n var auditSheet = SpreadsheetApp.getActiveSpreadsheet()<\/p>\n .getSheetByName(‘\u76e3\u67fb\u30ed\u30b0’) || createAuditSheet();<\/p>\n var logEntry = [<\/p>\n new Date(),\u00a0 \/\/ \u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7<\/p>\n Session.getActiveUser().getEmail(),\u00a0 \/\/ \u30e6\u30fc\u30b6\u30fc<\/p>\n action,\u00a0 \u00a0\/\/ \u30a2\u30af\u30b7\u30e7\u30f3<\/p>\n details,\u00a0 \u00a0\/\/ \u8a73\u7d30<\/p>\n Utilities.computeDigest(\u00a0 \u00a0\/\/ \u30cf\u30c3\u30b7\u30e5\u5024<\/p>\n Utilities.DigestAlgorithm.SHA_256,<\/p>\n JSON.stringify([new Date(), action, details]),<\/p>\n Utilities.Charset.UTF_8\u00a0)];<\/p>\n auditSheet.appendRow(logEntry);<\/p>\n \/\/ \u30b7\u30fc\u30c8\u4fdd\u8b77\uff08\u8aad\u307f\u53d6\u308a\u5c02\u7528\uff09<\/p>\n var protection = auditSheet.protect();<\/p>\n protection.setDescription(‘\u76e3\u67fb\u30ed\u30b0\u4fdd\u8b77’);<\/p>\n protection.removeEditors(protection.getEditors());}<\/p>\n Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306b\u304a\u3051\u308b\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u306e\u9069\u5207\u306a\u5b9f\u88c5\u306f\u3001\u30c7\u30fc\u30bf\u306e\u4fe1\u983c\u6027\u5411\u4e0a\u3068\u696d\u52d9\u30d7\u30ed\u30bb\u30b9\u306e\u53ef\u8996\u5316\u306b\u4e0d\u53ef\u6b20\u306a\u8981\u7d20\u3067\u3059\u3002\u624b\u52d5\u5165\u529b\u3067\u306f\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc\u3068NOW\u95a2\u6570\u3092\u4f7f\u3044\u5206\u3051\u3001Google Apps Script\u306b\u3088\u308b\u81ea\u52d5\u5316\u3067\u306f\u3001onEdit\u95a2\u6570\u3084\u30c8\u30ea\u30ac\u30fc\u6a5f\u80fd\u3092\u6d3b\u7528\u3057\u3066\u5b8c\u5168\u81ea\u52d5\u5316\u3092\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002<\/p>\n \u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u306e\u9069\u5207\u306a\u8a2d\u5b9a\u3001\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306e\u7d71\u4e00\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u6700\u9069\u5316\u3068\u3044\u3063\u305f\u8003\u616e\u4e8b\u9805\u3092\u62bc\u3055\u3048\u308b\u3053\u3068\u3067\u3001\u30b9\u30b1\u30fc\u30e9\u30d6\u30eb\u3067\u4fe1\u983c\u6027\u306e\u9ad8\u3044\u6642\u523b\u8a18\u9332\u30b7\u30b9\u30c6\u30e0\u3092\u69cb\u7bc9\u3067\u304d\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u6280\u8853\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u76e3\u67fb\u5bfe\u5fdc\u53ef\u80fd\u306a\u5805\u7262\u306a\u30c7\u30fc\u30bf\u7ba1\u7406\u57fa\u76e4\u3092\u78ba\u7acb\u3057\u3001\u696d\u52d9\u306e\u52b9\u7387\u5316\u3068\u54c1\u8cea\u5411\u4e0a\u3092\u540c\u6642\u306b\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":" Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\uff08Google Sheets\uff09\u3067\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u9069\u5207\u306b\u7ba1\u7406\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u306e\u8ffd\u8de1\u6027\u3068\u4fe1\u983c\u6027\u304c\u5927\u5e45\u306b\u5411\u4e0a\u3057\u307e\u3059\u3002\u672c\u8a18\u4e8b\u3067\u306f\u3001NOW\u95a2\u6570\u3084\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc\u3092\u4f7f\u3063\u305f\u624b\u52d5\u5165\u529b\u65b9\u6cd5\u304b\u3089\u3001Google […]<\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[51],"tags":[],"class_list":["post-21079","post","type-post","status-publish","format-standard","hentry","category-excel"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/posts\/21079","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/comments?post=21079"}],"version-history":[{"count":7,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/posts\/21079\/revisions"}],"predecessor-version":[{"id":21356,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/posts\/21079\/revisions\/21356"}],"wp:attachment":[{"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/media?parent=21079"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/categories?post=21079"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/tags?post=21079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u30ad\u30fc\u306b\u3088\u308b\u5373\u5ea7\u306e\u6642\u523b\u5165\u529b<\/h3>\n
\n
\n
NOW\u95a2\u6570\u3068TODAY\u95a2\u6570\u306e\u6d3b\u7528\u3068\u5236\u9650<\/h3>\n
\n
\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u3067\u306e\u67d4\u8edf\u306a\u6642\u523b\u8a18\u9332<\/h3>\n
\n
\n=TEXT(NOW(),”yyyy\/MM\/dd HH:mm:ss”)&” JST” \u3092\u4f7f\u7528\u3002<\/li>\n
\nUtilities.formatDate(new Date(), “Asia\/Tokyo”, “yyyy\/MM\/dd HH:mm:ss”)
\n\u306e\u3088\u3046\u306b \u660e\u793a\u7684\u306b “Asia\/Tokyo” <\/strong>\u3092\u6307\u5b9a\u3057\u3066\u66f8\u304d\u8fbc\u307f\u307e\u3059\u3002<\/li>\n<\/ul>\n<\/div>\n\u30c7\u30fc\u30bf\u691c\u8a3c\u3068\u30c9\u30ed\u30c3\u30d7\u30c0\u30a6\u30f3\u306b\u3088\u308b\u6642\u523b\u9078\u629e<\/h3>\n
\n
\n
\n=ARRAYFORMULA(TEXT(SEQUENCE(96,1,0,1\/96),”HH:mm”))<\/li>\n
\n=ARRAYFORMULA(TEXT(TIME(9,0,0)+SEQUENCE(36,1,0,1\/96),”HH:mm”))<\/li>\n<\/ul>\n<\/div>\nGoogle Apps Script\u3067\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u81ea\u52d5\u5316\u3059\u308b\u65b9\u6cd5\u306f\uff1f<\/h2>\n
onEdit\u95a2\u6570\u306b\u3088\u308b\u7de8\u96c6\u6642\u306e\u81ea\u52d5\u8a18\u9332<\/h3>\n
\n
\u30d5\u30a9\u30fc\u30e0\u9001\u4fe1\u6642\u306b\u8a18\u9332\u3057\u305f\u3044\u5834\u5408\uff08onFormSubmit\uff09<\/h4>\n
\u8907\u6570\u30b7\u30fc\u30c8\u5bfe\u5fdc\u306e\u9ad8\u5ea6\u306a\u5b9f\u88c5<\/h3>\n
\u7de8\u96c6\u8005\u30e1\u30fc\u30eb\u306e\u6ce8\u610f<\/h4>\n
\u30d5\u30a9\u30fc\u30e0\u9001\u4fe1\u6642\u306e\u81ea\u52d5\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7<\/h3>\n
\u88dc\u8db3<\/strong><\/h4>\n
\ne.namedValues \u306e\u30ad\u30fc\u306f\u8cea\u554f\u6587\u305d\u306e\u3082\u306e<\/strong>\u3067\u3059\u3002\u30b9\u30da\u30eb\u3084\u5168\u89d2\u534a\u89d2\u306e\u9055\u3044\u306b\u6ce8\u610f\u3057\u3001\u5909\u66f4\u304c\u3042\u308a\u5f97\u308b\u8cea\u554f\u6587\u3092\u30ad\u30fc\u306b\u3059\u308b\u5834\u5408\u306f\u9805\u76eeID\u7ba1\u7406<\/strong>\u3084\u898b\u51fa\u3057\u884c\u306e\u30de\u30c3\u30d4\u30f3\u30b0<\/strong>\u3092\u691c\u8a0e\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\u30d0\u30c3\u30c1\u51e6\u7406\u306b\u3088\u308b\u5b9a\u671f\u7684\u306a\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u66f4\u65b0<\/h3>\n
\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u3092\u8a18\u9332\u3059\u308b\u969b\u306e\u6ce8\u610f\u70b9\u306f\uff1f<\/h2>\n
\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u306e\u8a2d\u5b9a\u3068\u5909\u63db\u51e6\u7406<\/h3>\n
\n
\n
\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306e\u7d71\u4e00\u3068\u8868\u793a\u5f62\u5f0f\u306e\u6700\u9069\u5316<\/h3>\n
\n
\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3068\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u306e\u6700\u9069\u5316<\/h3>\n
\u30c7\u30fc\u30bf\u306e\u6574\u5408\u6027\u3068\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u6226\u7565<\/h3>\n
\u5b9f\u8df5\u7684\u306a\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u6d3b\u7528\u3067\u30c7\u30fc\u30bf\u7ba1\u7406\u3092\u52b9\u7387\u5316<\/h2>\n