app / scripts /ShiftFormGenerator.gs
m1m02530125's picture
Claude Sonnet 4.6
feat: GASใƒ•ใ‚ฉใƒผใƒ ๅฏพๅฟœใƒปCSVใƒ‘ใƒผใ‚ตใƒผใ‚’ๆ–ฐๆ—งใƒ•ใ‚ฉใƒผใƒžใƒƒใƒˆ่‡ชๅ‹•ๅˆคๅˆฅใซๆ›ดๆ–ฐ
4a4580d
Raw History Blame Contribute Delete
10.3 kB
/**
* ============================================================
* ๅ‡บๅ‹คๅธŒๆœ›ใƒ•ใ‚ฉใƒผใƒ  ่‡ชๅ‹•็”Ÿๆˆใ‚นใ‚ฏใƒชใƒ—ใƒˆ (Google Apps Script)
* ============================================================
*
* ใ€ไฝฟใ„ๆ–นใ€‘
* 1. Google ใ‚นใƒ—ใƒฌใƒƒใƒ‰ใ‚ทใƒผใƒˆใ‚’ๆ–ฐ่ฆไฝœๆˆ
* 2. ๆ‹กๅผตๆฉŸ่ƒฝ > Apps Script ใงใ“ใฎใ‚ณใƒผใƒ‰ใ‚’่ฒผใ‚Šไป˜ใ‘
* 3. CONFIG ใ‚’็ทจ้›†๏ผˆๆœŸ้–“ใƒปใ‚นใ‚ฟใƒƒใƒ•ๅใƒปใ‚ทใƒ•ใƒˆใƒ‘ใ‚ฟใƒผใƒณ๏ผ‰
* 4. createShiftForm() ใ‚’ๅฎŸ่กŒ โ†’ ่ช่จผใ‚’่จฑๅฏ
* 5. ใƒญใ‚ฐใซ่กจ็คบใ•ใ‚ŒใŸใ€Œ้…ๅธƒURLใ€ใ‚’ใ‚นใ‚ฟใƒƒใƒ•ใซๅ…ฑๆœ‰
*
* ใ€ใƒ•ใ‚ฉใƒผใƒ ใฎๆตใ‚Œใ€‘
* Q1 : ใŠๅๅ‰๏ผˆใƒ—ใƒซใƒ€ใ‚ฆใƒณใƒปๅฟ…้ ˆ๏ผ‰
* โ†“ ๆ—ฅไป˜ใ”ใจใซ็นฐใ‚Š่ฟ”ใ—๏ผˆๆ—ฅๆ•ฐๅˆ†ใฎใ‚ปใ‚ฏใ‚ทใƒงใƒณ๏ผ‰
* Q2n: Xๆ—ฅ๏ผˆๆ›œ๏ผ‰ใฏๅ‡บๅ‹คใงใใพใ™ใ‹๏ผŸ๏ผˆใƒฉใ‚ธใ‚ชใƒปไปปๆ„๏ผ‰
* โ”œโ”€ ๆœ้ฃŸใฎใฟ โ†’ ๆœ้ฃŸใ‚ทใƒ•ใƒˆ้ธๆŠžใ‚ปใ‚ฏใ‚ทใƒงใƒณใธ
* โ”œโ”€ ใƒ‡ใ‚ฃใƒŠใƒผใฎใฟ โ†’ ใƒ‡ใ‚ฃใƒŠใƒผใ‚ทใƒ•ใƒˆ้ธๆŠžใ‚ปใ‚ฏใ‚ทใƒงใƒณใธ
* โ”œโ”€ ใƒ€ใƒ–ใƒซ(ไธกๆ–น) โ†’ ๆฌกใฎๆ—ฅใธ๏ผˆใƒ€ใƒ–ใƒซใ‚ทใƒ•ใƒˆ็ขบๅฎšใƒปๆ™‚้–“ๆŒ‡ๅฎšใชใ—๏ผ‰
* โ””โ”€ ไผ‘ใฟ โ†’ ๆฌกใฎๆ—ฅใธ๏ผˆใ‚นใ‚ญใƒƒใƒ—๏ผ‰
* Q3n: ๆœ้ฃŸ / ใƒ‡ใ‚ฃใƒŠใƒผ ใฎๅธŒๆœ›ใ‚ทใƒ•ใƒˆใ‚’ใƒ—ใƒซใƒ€ใ‚ฆใƒณใง้ธๆŠž
* โ†“
* Q4 : ๅ‚™่€ƒๆฌ„๏ผˆ่จ˜่ฟฐๅผใƒปไปปๆ„๏ผ‰
*
* ใ€CSV ใ‚คใƒณใƒใƒผใƒˆๆ™‚ใฎๆณจๆ„ใ€‘
* ๅ›ž็ญ”ๅŽ้›†ๅพŒใ€ใ‚นใƒ—ใƒฌใƒƒใƒ‰ใ‚ทใƒผใƒˆใฎ
* ใ€Œใƒ•ใ‚กใ‚คใƒซ > ใƒ€ใ‚ฆใƒณใƒญใƒผใƒ‰ > CSVใ€ใงใ‚จใ‚ฏใ‚นใƒใƒผใƒˆใ—ใ€
* ใ‚ทใƒ•ใƒˆ็ฎก็†ใ‚ขใƒ—ใƒชใฎใ€ŒGoogle Forms CSV ใ‚’ใ‚คใƒณใƒใƒผใƒˆใ€ใ‹ใ‚‰่ชญใฟ่พผใ‚“ใงใใ ใ•ใ„ใ€‚
* ============================================================
*/
// ============================================================
// โ˜… ใ“ใ“ใ‚’ๆฏŽๆœˆ็ทจ้›†ใ—ใฆใใ ใ•ใ„
// ============================================================
const CONFIG = {
PERIOD_START : '2025-04-01', // ใ‚ทใƒ•ใƒˆๆœŸ้–“้–‹ๅง‹ (YYYY-MM-DD)
PERIOD_END : '2025-04-14', // ใ‚ทใƒ•ใƒˆๆœŸ้–“็ต‚ไบ† (YYYY-MM-DD)
FORM_TITLE : '4ๆœˆ ๅ‡บๅ‹คๅธŒๆœ›ใƒ•ใ‚ฉใƒผใƒ ',
FORM_DESC : [
'ใ€ๅ›ž็ญ”ๆœŸ้™ใ€‘โ—ฏๆœˆโ—ฏๆ—ฅ๏ผˆโ—ฏ๏ผ‰23:59 ใพใงใซๅ›ž็ญ”ใ—ใฆใใ ใ•ใ„ใ€‚',
'',
'ใ€ๆณจๆ„ไบ‹้ …ใ€‘',
'ใƒปใŠๅๅ‰ใฏใƒชใ‚นใƒˆใ‹ใ‚‰ๆญฃ็ขบใซ้ธใ‚“ใงใใ ใ•ใ„',
'ใƒปๆ—ฅไป˜ใ”ใจใซๅ‡บๅ‹คใฎๅฏๅฆใจๅธŒๆœ›ใ‚ทใƒ•ใƒˆๆ™‚้–“ใ‚’ๅ…ฅๅŠ›ใ—ใพใ™',
'ใƒปใƒ€ใƒ–ใƒซใฏๆœ้ฃŸใƒปใƒ‡ใ‚ฃใƒŠใƒผไธกๆ–นใƒ•ใƒซๅ‡บๅ‹ค๏ผˆๆ™‚้–“ๅธฏใฏ็ขบๅฎš๏ผ‰',
'ใƒปใƒชใ‚นใƒˆใซใชใ„ๆ™‚้–“ๅธฏใฏใ€Œใใฎไป–ใ€ใ‚’้ธๆŠžใ—ใฆๅ‚™่€ƒๆฌ„ใซ่จ˜ๅ…ฅ',
].join('\n'),
// โ”€โ”€ ็™ป้Œฒใ‚นใ‚ฟใƒƒใƒ•ๅ๏ผˆใ‚ขใƒ—ใƒชใฎ็™ป้ŒฒๅใจๅฎŒๅ…จไธ€่‡ดใ•ใ›ใ‚‹ใ“ใจ๏ผ‰โ”€โ”€
EMPLOYEES: [
'็”ฐไธญ ๅคช้ƒŽ',
'ๅฑฑ็”ฐ ่Šฑๅญ',
'ไฝ่—ค ๆฌก้ƒŽ',
'้ˆดๆœจ ็พŽๅ’ฒ',
'ไผŠ่—ค ๅฅๅคช',
],
// โ”€โ”€ ๆœ้ฃŸใ‚ทใƒ•ใƒˆใฎ้ธๆŠž่‚ข๏ผˆใ‚ขใƒ—ใƒชใฎใ€Œใƒ‘ใ‚ฟใƒผใƒณใƒฉใƒ™ใƒซใ€ใจไธ€่‡ดใ•ใ›ใ‚‹ใ“ใจ๏ผ‰โ”€โ”€
BREAKFAST_PATTERNS: [
'ๆœ้ฃŸ็Ÿญ็•ช (6:00ใ€œ10:00)',
'ๆœ้ฃŸ (6:30ใ€œ11:30)',
'ๆœ้ฃŸใƒญใƒณใ‚ฐ (5:45ใ€œ14:45)',
'ๅˆๅ‰ๅŠๆ—ฅ (6:30ใ€œ15:30)',
'ใใฎไป–๏ผˆๅ‚™่€ƒๆฌ„ใซๆ™‚ๅˆปใ‚’่จ˜ๅ…ฅ๏ผ‰',
],
// โ”€โ”€ ใƒ‡ใ‚ฃใƒŠใƒผใ‚ทใƒ•ใƒˆใฎ้ธๆŠž่‚ข โ”€โ”€
DINNER_PATTERNS: [
'้€šใ—ๆ—ฉ็•ช (13:00ใ€œ22:30)',
'้€šใ—้…็•ช (14:00ใ€œ23:00)',
'ใƒ‡ใ‚ฃใƒŠใƒผ (17:00ใ€œ22:30)',
'ใƒ‡ใ‚ฃใƒŠใƒผ (17:30ใ€œ23:00)',
'ใƒ‡ใ‚ฃใƒŠใƒผ (18:00ใ€œ23:00)',
'ใƒ‡ใ‚ฃใƒŠใƒผๅ‰ๅŠ (17:00ใ€œ21:00)',
'ใƒ‡ใ‚ฃใƒŠใƒผๅ‰ๅŠ (17:30ใ€œ21:30)',
'ใƒ‡ใ‚ฃใƒŠใƒผ็Ÿญ็•ช (18:00ใ€œ22:00)',
'ใใฎไป–๏ผˆๅ‚™่€ƒๆฌ„ใซๆ™‚ๅˆปใ‚’่จ˜ๅ…ฅ๏ผ‰',
],
};
// ============================================================
// ใƒ˜ใƒซใƒ‘ใƒผ
// ============================================================
const _DOW_JA = ['ๆ—ฅ', 'ๆœˆ', '็ซ', 'ๆฐด', 'ๆœจ', '้‡‘', 'ๅœŸ'];
/** YYYY-MM-DD โ†’ Date ใ‚ชใƒ–ใ‚ธใ‚งใ‚ฏใƒˆใฎ้…ๅˆ—๏ผˆใ‚ฟใ‚คใƒ ใ‚พใƒผใƒณใšใ‚Œใ‚’้˜ฒใใŸใ‚ใƒญใƒผใ‚ซใƒซ่งฃ้‡ˆ๏ผ‰ */
function _getDates(startStr, endStr) {
const [sy, sm, sd] = startStr.split('-').map(Number);
const [ey, em, ed] = endStr.split('-').map(Number);
const dates = [];
let d = new Date(sy, sm - 1, sd);
const end = new Date(ey, em - 1, ed);
while (d <= end) {
dates.push(new Date(d));
d.setDate(d.getDate() + 1);
}
return dates;
}
/** Date โ†’ ใ€Œ4ๆœˆ1ๆ—ฅ๏ผˆๆœˆ๏ผ‰ใ€ๅฝขๅผ */
function _label(d) {
return `${d.getMonth() + 1}ๆœˆ${d.getDate()}ๆ—ฅ๏ผˆ${_DOW_JA[d.getDay()]}๏ผ‰`;
}
// ============================================================
// ใƒกใ‚คใƒณ: ใƒ•ใ‚ฉใƒผใƒ ใ‚’็”Ÿๆˆ
// ============================================================
function createShiftForm() {
const dates = _getDates(CONFIG.PERIOD_START, CONFIG.PERIOD_END);
const form = FormApp.create(CONFIG.FORM_TITLE);
form.setDescription(CONFIG.FORM_DESC);
form.setCollectEmail(false);
form.setAllowResponseEdits(true); // ๅ›ž็ญ”ๅพŒใฎ็ทจ้›†ใ‚’่จฑๅฏ
// โ”€โ”€ Q1: ใŠๅๅ‰๏ผˆใƒ—ใƒซใƒ€ใ‚ฆใƒณใƒปๅฟ…้ ˆ๏ผ‰โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€
form.addListItem()
.setTitle('ใŠๅๅ‰')
.setHelpText('ใƒชใ‚นใƒˆใ‹ใ‚‰่‡ชๅˆ†ใฎๅๅ‰ใ‚’้ธๆŠžใ—ใฆใใ ใ•ใ„ใ€‚')
.setRequired(true)
.setChoiceValues(CONFIG.EMPLOYEES);
// โ”€โ”€ ๅ„ๆ—ฅใฎใƒšใƒผใ‚ธใ‚’้ †็•ชใซไฝœๆˆ โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€
// ใƒซใƒผใƒ†ใ‚ฃใƒณใ‚ฐ่จญๅฎšใฎใŸใ‚ใซใƒšใƒผใ‚ธๅ‚็…งใƒป่ณชๅ•ๅ‚็…งใ‚’ไฟๆŒใ™ใ‚‹
const availPages = []; // ๅ‡บๅ‹คๅฏๅฆใƒšใƒผใ‚ธ๏ผˆๅ„ๆ—ฅ1ใค๏ผ‰
const bPages = []; // ๆœ้ฃŸใ‚ทใƒ•ใƒˆ้ธๆŠžใƒšใƒผใ‚ธ๏ผˆๅ„ๆ—ฅ1ใค๏ผ‰
const dPages = []; // ใƒ‡ใ‚ฃใƒŠใƒผใ‚ทใƒ•ใƒˆ้ธๆŠžใƒšใƒผใ‚ธ๏ผˆๅ„ๆ—ฅ1ใค๏ผ‰
const availItems = []; // ๅ‡บๅ‹คๅฏๅฆใƒฉใ‚ธใ‚ชใฎ่ณชๅ•ใ‚ขใ‚คใƒ†ใƒ 
for (let i = 0; i < dates.length; i++) {
const dl = _label(dates[i]);
// โ”€โ”€ ๅ‡บๅ‹คๅฏๅฆใ‚ปใ‚ฏใ‚ทใƒงใƒณ โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€
availPages.push(
form.addPageBreakItem().setTitle(`${dl} ใฎๅ‡บๅ‹คๅธŒๆœ›`)
);
availItems.push(
form.addMultipleChoiceItem()
.setTitle(`${dl} ใฏๅ‡บๅ‹คใงใใพใ™ใ‹๏ผŸ`)
.setRequired(false) // โ‘ฃ ๆœชๅ›ž็ญ” = ใ‚นใ‚ญใƒƒใƒ—
);
// โ”€โ”€ ๆœ้ฃŸใ‚ทใƒ•ใƒˆ้ธๆŠžใ‚ปใ‚ฏใ‚ทใƒงใƒณ โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€
bPages.push(
form.addPageBreakItem().setTitle(`${dl} ๆœ้ฃŸ โ”€ ๅธŒๆœ›ใ‚ทใƒ•ใƒˆ`)
);
form.addListItem()
.setTitle(`${dl} ๆœ้ฃŸใฎๅธŒๆœ›ใ‚ทใƒ•ใƒˆใ‚’้ธใ‚“ใงใใ ใ•ใ„`)
.setHelpText('ใƒชใ‚นใƒˆใซใชใ„ๅ ดๅˆใฏใ€Œใใฎไป–ใ€ใ‚’้ธๆŠžใ—ใ€ๆœ€ๅพŒใฎๅ‚™่€ƒๆฌ„ใซๆ™‚ๅˆปใ‚’่จ˜ๅ…ฅใ—ใฆใใ ใ•ใ„ใ€‚')
.setRequired(false)
.setChoiceValues(CONFIG.BREAKFAST_PATTERNS);
// โ”€โ”€ ใƒ‡ใ‚ฃใƒŠใƒผใ‚ทใƒ•ใƒˆ้ธๆŠžใ‚ปใ‚ฏใ‚ทใƒงใƒณ โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€
dPages.push(
form.addPageBreakItem().setTitle(`${dl} ใƒ‡ใ‚ฃใƒŠใƒผ โ”€ ๅธŒๆœ›ใ‚ทใƒ•ใƒˆ`)
);
form.addListItem()
.setTitle(`${dl} ใƒ‡ใ‚ฃใƒŠใƒผใฎๅธŒๆœ›ใ‚ทใƒ•ใƒˆใ‚’้ธใ‚“ใงใใ ใ•ใ„`)
.setHelpText('ใƒชใ‚นใƒˆใซใชใ„ๅ ดๅˆใฏใ€Œใใฎไป–ใ€ใ‚’้ธๆŠžใ—ใ€ๆœ€ๅพŒใฎๅ‚™่€ƒๆฌ„ใซๆ™‚ๅˆปใ‚’่จ˜ๅ…ฅใ—ใฆใใ ใ•ใ„ใ€‚')
.setRequired(false)
.setChoiceValues(CONFIG.DINNER_PATTERNS);
}
// โ”€โ”€ ๅ‚™่€ƒใ‚ปใ‚ฏใ‚ทใƒงใƒณ๏ผˆๆœ€็ต‚ใƒšใƒผใ‚ธ๏ผ‰โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€
const finalPage = form.addPageBreakItem().setTitle('ๅ‚™่€ƒ');
form.addParagraphTextItem()
.setTitle('ใใฎไป–ใ€ใ‚ทใƒ•ใƒˆใซ้–ขใ™ใ‚‹้€ฃ็ตกไบ‹้ …ใŒใ‚ใ‚Œใฐ่จ˜ๅ…ฅใ—ใฆใใ ใ•ใ„')
.setHelpText('ใ€Œใใฎไป–ใ€ใ‚’้ธใ‚“ใ ๆ—ฅใฎๆ™‚ๅˆปใ€้…ๅˆปใƒปๆ—ฉ้€€ใฎๅฏ่ƒฝๆ€งใชใฉ\nไพ‹: 4/3 ๆœ้ฃŸ 8:00ใ€œ12:00ใ€4/10 18:00ไปฅ้™ใฏๆ—ฉ้€€ๅธŒๆœ›')
.setRequired(false);
// โ”€โ”€ ๆกไปถๅˆ†ๅฒ๏ผˆใƒšใƒผใ‚ธใƒซใƒผใƒ†ใ‚ฃใƒณใ‚ฐ๏ผ‰ใฎ่จญๅฎš โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€
for (let i = 0; i < dates.length; i++) {
// ๆฌกใซ้€ฒใ‚€ในใใƒšใƒผใ‚ธ๏ผˆๆœ€็ต‚ๆ—ฅใชใ‚‰ๅ‚™่€ƒใƒšใƒผใ‚ธ๏ผ‰
const nextPage = (i + 1 < dates.length) ? availPages[i + 1] : finalPage;
// ๆœ้ฃŸใƒปใƒ‡ใ‚ฃใƒŠใƒผใƒšใƒผใ‚ธใฎ็ต‚ไบ†ๅพŒใฏๆฌกใฎๆ—ฅ๏ผˆใพใŸใฏๅ‚™่€ƒใƒšใƒผใ‚ธ๏ผ‰ใธ
bPages[i].setGoToPage(nextPage);
dPages[i].setGoToPage(nextPage);
// ๅ‡บๅ‹คๅฏๅฆใฎ้ธๆŠž่‚ขใ”ใจใฎใƒซใƒผใƒ†ใ‚ฃใƒณใ‚ฐ
const aq = availItems[i];
aq.setChoices([
aq.createChoice(
'ๆœ้ฃŸใฎใฟ',
FormApp.PageNavigationType.GO_TO_PAGE,
bPages[i] // ๆœ้ฃŸใ‚ทใƒ•ใƒˆ้ธๆŠžใธ
),
aq.createChoice(
'ใƒ‡ใ‚ฃใƒŠใƒผใฎใฟ',
FormApp.PageNavigationType.GO_TO_PAGE,
dPages[i] // ใƒ‡ใ‚ฃใƒŠใƒผใ‚ทใƒ•ใƒˆ้ธๆŠžใธ
),
aq.createChoice(
'ใƒ€ใƒ–ใƒซ๏ผˆๆœ้ฃŸ๏ผ‹ใƒ‡ใ‚ฃใƒŠใƒผไธกๆ–น๏ผ‰',
FormApp.PageNavigationType.GO_TO_PAGE,
nextPage // ๆฌกใฎๆ—ฅใธ๏ผˆใƒ€ใƒ–ใƒซใ‚ทใƒ•ใƒˆ็ขบๅฎš๏ผ‰
),
aq.createChoice(
'ไผ‘ใฟ',
FormApp.PageNavigationType.GO_TO_PAGE,
nextPage // ๆฌกใฎๆ—ฅใธ๏ผˆใ‚นใ‚ญใƒƒใƒ—๏ผ‰
),
]);
}
// โ”€โ”€ ใƒญใ‚ฐๅ‡บๅŠ› โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€โ”€
const editUrl = form.getEditUrl();
const pubUrl = form.getPublishedUrl();
const shortUrl = form.shortenFormUrl(pubUrl);
Logger.log('โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”');
Logger.log(`โœ… ็”ŸๆˆๅฎŒไบ†: ${CONFIG.FORM_TITLE}`);
Logger.log(`๐Ÿ“‹ ็ทจ้›†URL (็ฎก็†่€…): ${editUrl}`);
Logger.log(`๐Ÿ”— ้…ๅธƒURL (ใ‚นใ‚ฟใƒƒใƒ•): ${shortUrl}`);
Logger.log('โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”โ”');
// ใ‚นใƒ—ใƒฌใƒƒใƒ‰ใ‚ทใƒผใƒˆใŒ็ดไป˜ใ„ใฆใ„ใ‚‹ๅ ดๅˆใฏAๅˆ—ใซURLใ‚’่จ˜้Œฒ
try {
SpreadsheetApp.getActiveSpreadsheet()
.getActiveSheet()
.getRange('A1:B3')
.setValues([
['็”Ÿๆˆๆ—ฅๆ™‚', new Date().toLocaleString('ja-JP')],
['็ทจ้›†URL๏ผˆ็ฎก็†่€…๏ผ‰', editUrl],
['้…ๅธƒURL๏ผˆใ‚นใ‚ฟใƒƒใƒ•๏ผ‰', shortUrl],
]);
} catch (e) { /* ใ‚นใ‚ฟใƒณใƒ‰ใ‚ขใƒญใƒณใ‚นใ‚ฏใƒชใƒ—ใƒˆใฎๅ ดๅˆใฏ็„ก่ฆ– */ }
return shortUrl;
}