GASäžçŽè¬åº§ 第1ååè¬ã¡ã¢ïŒvarã»ã¹ã³ãŒãã»é¢æ°ã®çè§£ãæ·±ãŸã£ã話
GASäžçŽè¬åº§ 第1åãã¹ã³ãŒããšé¢æ°ããåè¬ããŠ
ãvarããã£ããã«ã倿°ã®âå± å Žæâãçè§£ããã
ãã³ããç ã®äžçŽããã°ã©ãã³ã°è¬åº§ãGASã³ãŒã¹ã第1åããä»åã¯ãã¹ããšããŠåå ããªããåè¬ããŸããã
第1åã®ããŒãã¯ãã¹ã³ãŒããšé¢æ°ãã
æ£çŽã«èšããšãåçŽã®ãšãã¯ã³ãŒããåãã°ããã§ç²Ÿäžæ¯ã§ããã
ã§ãäžçŽã«å
¥ããšãããªããã®å€æ°ã䜿ããã®ããããªãå¥ã®å Žæã§ã¯äœ¿ããªãã®ããããªãåãååãªã®ã«çµæãéãã®ãããšãã£ããã³ãŒãã®è£åŽã«ããã«ãŒã«ãçè§£ããããšã倧äºã«ãªã£ãŠããŸãã
ä»åã®è¬çŸ©ã§ç¹ã«å°è±¡ã«æ®ã£ãã®ã¯ãvarãéããŠã¹ã³ãŒãã®çè§£ãæ·±ãŸã£ãããšã§ãã
ã¹ã³ãŒããšã¯ã倿°ã䜿ããç¯å²ã®ããš
ãŸããã¹ã³ãŒããšã¯äœãã
äžèšã§ãããšã倿°ã颿°ã䜿ããç¯å²ã®ããšã§ãã
GASãJavaScriptã§ã¯ã倿°ãã©ãã§å®£èšãããã«ãã£ãŠããã®å€æ°ã䜿ããç¯å²ãå€ãããŸãã
ä»åã®è¬çŸ©ã§ã¯ãäž»ã«æ¬¡ã®3ã€ã®ã¹ã³ãŒããåŠã³ãŸããã
ã°ããŒãã«ã¹ã³ãŒã
ããŒã«ã«ã¹ã³ãŒã
ãããã¯ã¹ã³ãŒã
åå¿è
ã®ãã¡ã¯ãã倿°ã¯äžåºŠäœã£ããã©ãããã§ã䜿ããããšæããã¡ã§ãã
ã§ãå®éã«ã¯ã倿°ã«ã¯ããããâå±
å ŽæâããããŸãã
ãã®âå± å Žæâãæèã§ããããã«ãªããšãã³ãŒãã®èŠãæ¹ãããªãå€ãããŸãã
ã°ããŒãã«é åã«æžããã³ãŒãã¯ãæã£ã以äžã«åœ±é¿ã倧ãã
è¬çŸ©ã®ååã§ã¯ãã°ããŒãã«é åãšããŒã«ã«é åã®éãã確èªããŸããã
ã°ããŒãã«é åãšã¯ãã©ã®é¢æ°ã«ãå ¥ã£ãŠããªãå Žæã§ãã
ããšãã°ã次ã®ãããªã³ãŒãã§ãã
var msg = 'Hello!';
function myFunction() {
console.log(`ããŒã«ã«ã§${msg}`);
}
console.log(`ã°ããŒãã«ã§${msg}`);
ãã®å Žåãmsg ã¯é¢æ°ã®å€ã§å®£èšãããŠããã®ã§ãã°ããŒãã«å€æ°ã§ãã
ãã®ããã颿°ã®äžãããåç
§ã§ããŸãã
ããã§å€§äºã ã£ãã®ã¯ãGASã§ã¯ã颿°ãå®è¡ãããšãã«ã°ããŒãã«é åã®ã³ãŒããå®è¡ããããšããç¹ã§ãã
ã€ãŸãããã颿°ã ããå®è¡ããŠããã€ããã§ãããããžã§ã¯ãå ã®ä»ã®ãã¡ã€ã«ã«ããã°ããŒãã«é åã®ã³ãŒããŸã§åãããšããããŸãã
ããã¯åå¿è ã«ãšã£ãŠãããªãèŠèœãšãããããã€ã³ãã ãšæããŸããã
ãèªåã¯ãã®é¢æ°ã ãå®è¡ããã€ãããªã®ã«ããªããå¥ã®ãã°ãåºãã
ãé¢ä¿ãªããšæã£ãŠããã³ãŒãã圱é¿ããŠããã
ããããçŸè±¡ã®åå ããã°ããŒãã«é åã«ããããšãããããã§ãã
varã¯ãããã¯ã¹ã³ãŒããæããªã
ä»åãèªåã®äžã§çè§£ãæ·±ãŸã£ãã®ã var ã§ãã
ä»ã¯ const ã let ã䜿ãã®ãåºæ¬ã§ãããå€ãã³ãŒãããµã³ãã«ã§ã¯ var ãèŠãããšããããŸãã
ãªããšãªããå€ãæžãæ¹ããããã«ã¯æã£ãŠããŸããããä»åã®è¬çŸ©ã§éããããªãæŽçãããŸããã
ãã€ã³ãã¯ãvarã¯ãããã¯ã¹ã³ãŒããæããªããšããããšã§ãã
ããšãã°ã次ã®ãããªã³ãŒãããããŸãã
function myFunction() {
{
var msgVar = 'Hello var!';
}
console.log(msgVar);
}
msgVar 㯠{} ã®äžã§å®£èšãããŠããŸãã
ã§ã var ã§å®£èšããŠããããããããã¯ã®å€ã§ã䜿ããŸãã
äžæ¹ã§ãconst ã let ã®å Žåã¯éããŸãã
function myFunction() {
{
const msg = 'Hello!';
}
console.log(msg);
}
ãã®å Žåãmsg ã¯ãããã¯ã®äžã ãã§äœ¿ãã倿°ã§ãã
ãããã¯ã®å€ã§ console.log(msg) ãšãããšãšã©ãŒã«ãªããŸãã
ããã§ãããããvar ãš let / const ã®éããè ¹èœã¡ããŸããã
var ã¯é¢æ°ã®äžã§ã¯äœ¿ããã
ã§ã {} ã®äžã ãã«éã蟌ããããšã¯ã§ããªãã
ã€ãŸããvar ã¯ããŒã«ã«ã¹ã³ãŒãã¯æã€ããã©ããããã¯ã¹ã³ãŒãã¯æããªããšããããšã§ãã
varã䜿ããªãçç±ãå°ãåãã£ã
ãããŸã§ãä»ã¯varã§ã¯ãªããconstãletã䜿ããŸãããããšèšãããããšã¯ãããŸããã
ãã ãåå¿è ã®ãã¡ã¯çç±ãããŸãåãã£ãŠããŸããã§ããã
ä»åã®è¬çŸ©ãåããŠãçç±ãå°ãèŠããŠããŸããã
var ã¯äœ¿ããç¯å²ãåºããªããããã§ãã
ãã®ãããæå³ããªãå Žæãã倿°ãåç
§ã§ããŠããŸã£ãããåãååã®å€æ°ãšã¶ã€ãã£ããããå¯èœæ§ããããŸãã
äžæ¹ã§ãconst ã let ã¯ãããã¯ã¹ã³ãŒããæã£ãŠããŸãã
å¿ èŠãªç¯å²ã ãã§å€æ°ã䜿ããããã«ã§ãããããã³ãŒãã®åœ±é¿ç¯å²ãå°ããã§ããŸãã
ããã¯ãå®åã§ã³ãŒããæžããšãã«ããªã倧äºã ãšæããŸããã
ã³ãŒããçããã¡ã¯ãå€å°ã¹ã³ãŒããåºããŠãåé¡ã«æ°ã¥ãã«ããã§ãã
ã§ãããã¡ã€ã«ãå¢ãããã颿°ãå¢ããããä»ã®äººãšäžç·ã«éçºããããããšã倿°ã®åœ±é¿ç¯å²ãåºãããšã¯ãã°ã®åå ã«ãªããŸãã
ã ãããããåºæ¬ã¯æ¬¡ã®èãæ¹ã§ããããã§ãã
constïŒå代å
¥ããªãå€ã«äœ¿ã
letïŒããšã§å€ãå€ããå¿
èŠãããå Žåã«äœ¿ã
varïŒåºæ¬çã«ã¯èªåã§ã¯äœ¿ããªã
ç¹ã«åå¿è
ã®ãã¡ã¯ããŸã const ã䜿ãã
å¿
èŠãªãšãã ã let ã䜿ãã
var ã¯å€ãã³ãŒããèªããšãã«çè§£ã§ããã°ããã
ãã®ãããã®æŽçã§ååã ãšæããŸããã
ã°ããŒãã«å€æ°ã¯äŸ¿å©ã ãã©ãããã¿ã«äœ¿ããªã
è¬çŸ©ã§ã¯ãã°ããŒãã«å€æ°ã«ã€ããŠãæ±ããŸããã
ããšãã°ã颿°ã®å€ã§æ¬¡ã®ããã«æžããšãmsg ã¯ã°ããŒãã«å€æ°ã«ãªããŸãã
let msg = 'Hello!';
function myFunction() {
msg += '!!';
console.log(msg);
}
ãã®ã³ãŒãã§ã¯ã颿°ã®äžã§ã°ããŒãã«å€æ° msg ãæžãæããŠããŸãã
ããã§ãå®åã§ã¯å°ãæãã§ãããªããªããã°ããŒãã«å€æ°ã¯ãããžã§ã¯ãå ã®ã©ãããã§ã倿Žã§ãããããã©ã®åŠçãå€ãæžãæããã®ã远ãããã«ãããªãããã§ãã
ãªããªããååå®è¡ããçµæãæ®ã£ãŠããããã«èŠããããã©ãã§å€ãå€ãã£ãã®ã远ãã«ãããªã£ããããããã§ãã
ã°ããŒãã«å€æ°ã¯ããããžã§ã¯ãå
šäœãã䜿ãããã䟿å©ã§ãã
ã§ã䟿å©ãªåé¢ã圱é¿ç¯å²ãåºãã§ãã
ä»åã®è¬çŸ©ãéããŠãã°ããŒãã«é åã«ã¯ããã¿ã«ã³ãŒããæžããªãã»ããããããšããçç±ãããåãããŸããã
颿°åãããšãã³ãŒãã®æå³ãèªã¿ããããªã
åŸåã§ã¯ã颿°ã«ã€ããŠåŠã³ãŸããã
颿°ãšã¯ãäžé£ã®åŠçããŸãšãããã®ã§ãã
ããšãã°ãçšèŸŒéé¡ãèšç®ããåŠçããã®ãŸãŸæžããšã次ã®ããã«ãªããŸãã
const taxRate = 0.1;
const price = 100;
console.log(Math.floor(price * (1 + taxRate)));
ããã§ãåããŸãã
ã§ããåŠçãå¢ããŠãããšãäœãããŠããã³ãŒããªã®ãèªã¿åãã«ãããªããŸãã
ããã§é¢æ°ã«ããŸãã
const getTaxIncluded = price => {
const taxRate = 0.1;
return Math.floor(price * (1 + taxRate));
};
console.log(getTaxIncluded(100));
ãããããšãgetTaxIncluded ãšãã颿°åãèŠãã ãã§ããçšèŸŒéé¡ãååŸããŠãããã ãªããšåãããŸãã
ä»åã®è¬çŸ©ã§å°è±¡ã«æ®ã£ãã®ã¯ã颿°åãããã¥ã¡ã³ã代ããã«ãªããšããèãæ¹ã§ãã
ãã颿°åãã€ãããšãã³ã¡ã³ãããªããŠãåŠçã®æå³ãäŒããããããªããŸãã
åŒæ°ãšæ»ãå€ã¯ã颿°ãšã®ãããšã
颿°ã§ã¯ãåŒæ°ãšæ»ãå€ã倧äºã§ãã
åŒæ°ã¯ã颿°ã«æž¡ãå€ã
æ»ãå€ã¯ã颿°ããè¿ã£ãŠããå€ã§ãã
function hello(name) {
return 'Hello! ' + name;
}
const message = hello('Taro');
console.log(message);
ãã®å Žåã'Taro' ãåŒæ°ã§ãã
ãããŠã'Hello! Taro' ãæ»ãå€ã§ãã
颿°ããåŠçã®ç®±ããšèãããšåãããããã§ãã
ç®±ã«ææãå
¥ããã
äžã§åŠçãããã
çµæãè¿ã£ãŠããã
ãã®ã€ã¡ãŒãžãæã€ãšã颿°ã®çè§£ããããããªããŸããã
åŒæ°ã®æ°ãåããªããŠãããšã©ãŒã«ãªããªãããšããã
ä»åãå°å³ã«å€§äºã ãšæã£ãã®ããåŒæ°ã®æ°ã®è©±ã§ãã
JavaScriptã§ã¯ã颿°ã«æž¡ãåŒæ°ã®æ°ãšãåãåãä»®åŒæ°ã®æ°ãåããªããŠããå¿ ããããšã©ãŒã«ã¯ãªããŸããã
const coFunction = (x, y) => {
console.log(`x: ${x}, y: ${y}`);
};
coFunction(1, 2, 3);
coFunction(1);
åŒæ°ãå€ãå Žåãäœã£ãåŒæ°ã¯äœ¿ãããŸããã
åŒæ°ãå°ãªãå Žåãè¶³ããªãä»®åŒæ°ã«ã¯ undefined ãå
¥ããŸãã
ãšã©ãŒã«ãªããªããããããæ°ã¥ãã«ããã
ããã¯å®åã§ã泚æãå¿
èŠã ãšæããŸããã
ãã®å¯ŸçãšããŠãããã©ã«ãåŒæ°ãåŠã³ãŸããã
const coFunction = (x = 'hoge', y = 'fuga') => {
console.log(`x: ${x}, y: ${y}`);
};
åŒæ°ãçç¥ããããšãã®åæå€ã決ããŠããããšã§ãundefined ã«ããæ³å®å€ã®åããæžãããŸãã
倿ž¡ããšåç §ã®ã³ããŒã¯ãå®åã§ããªãéèŠ
ä»åã®è¬çŸ©ã®äžã§ãç¹ã«éèŠã ãšæã£ãã®ããåŒæ°ãšã¡ã¢ãªã®é¢ä¿ã§ãã
æ°å€ãæååãªã©ã®ããªããã£ãåã颿°ã«æž¡ãå Žåãå€ãã³ããŒãããŸãã
function myFunction() {
const coFunction = y1 => {
y1 += 1;
};
const x1 = 10;
coFunction(x1);
console.log(x1);
}
ãã®å Žåã颿°ã®äžã§ y1 ã倿ŽããŠããå ã® x1 ã¯å€ãããŸããã
äžæ¹ã§ãé åããªããžã§ã¯ããæž¡ãå Žåã¯æ³šæãå¿ èŠã§ãã
function myFunction() {
const coFunction = y2 => {
y2[0] += 1;
};
const x2 = [10];
coFunction(x2);
console.log(x2);
}
ãã®å Žåãx2 ã®äžèº«ãå€ãããŸãã
çç±ã¯ãé åããªããžã§ã¯ãã®å Žåãå€ãã®ãã®ã®ã³ããŒã§ã¯ãªããåãããŒã¿ãåç §ããæ å ±ãæž¡ãããããã§ãã
è¬çŸ©ã§ã¯ãæ°å€ãšé åãæ¯èŒããäŸããããŸããã
function myFunction() {
const coFunction = (y1, y2) => {
y1 += 1;
y2[0] += 1;
};
const x1 = 10, x2 = [10];
coFunction(x1, x2);
console.log(`x1: ${x1}, x2: ${x2}`);
}
çµæãšããŠãx1 ã¯å€ãããªãã
ã§ããx2 ã¯å€ããã
ããã¯ãåå¿è ãã€ãŸããããããšããã ãšæããŸãã
èªåãªãã«ããšãããªããæ°å€ãæž¡ãã®ã¯ãã¡ã¢ã®ã³ããŒãæž¡ãããããªãã®ã§ãã
çžæãã³ããŒãæžãæããŠããèªåã®å
ã®ã¡ã¢ã¯å€ãããŸããã
äžæ¹ã§ãé
åãæž¡ãã®ã¯ãå
±æã¹ãã¬ããã·ãŒãã®URLãæž¡ãããããªãã®ã§ãã
çžæãäžèº«ãç·šéãããšãèªåãèŠãŠãäžèº«ãå€ãã£ãŠããŸãã
GASã§ã¯ãã¹ãã¬ããã·ãŒãããååŸããäºæ¬¡å
é
åãæ±ãããšãå€ãã§ãã
ãã®ãããé
åã颿°ã«æž¡ããŠå å·¥ãããšãã¯ãå
ããŒã¿ãæžãæããŠããã®ããæèããå¿
èŠããããŸãã
ããã¯å®åã§ããªã倧äºãªèŠç¹ã ãšæããŸããã
ä»åã®åŠã³ãäžèšã§ãŸãšãããš
ä»åã®è¬çŸ©ãéããŠãã³ãŒããæžããšãã«å€§äºãªã®ã¯ããã åããããšã ãã§ã¯ãªããšæããŸããã
ç¹ã«å€§äºãªã®ã¯ã次ã®3ã€ã§ãã
倿°ãã©ãã§å®£èšããã
ãã®å€æ°ã¯ã©ããã䜿ããã®ã
颿°ã«å€ãæž¡ãããšããå ã®å€ã«åœ±é¿ããã®ã
ãã®3ã€ãæèã§ããããã«ãªããšãã³ãŒãã®å®å šæ§ãèªã¿ããããããªãå€ãããšæããŸãã
åçŽã§ã¯ãåããïŒãã倧äºã§ããã
äžçŽã§ã¯ããããäžæ©é²ãã§ãããªãåãã®ãããã©ããŸã§åœ±é¿ããã®ãããçè§£ããŠããæ®µéãªã®ã ãšæããŸãã
ããããæèãããããš
ä»åã®åŠã³ãèžãŸããŠãä»åŸGASãæžããšãã¯æ¬¡ã®ããšãæèãããã§ãã
ãŸãã倿°ã¯ã§ããã ãçãç¯å²ã§äœ¿ãã
ã°ããŒãã«é åã«ã¯ãããã¿ã«ã³ãŒããæžããªãã
var ã¯åºæ¬çã«äœ¿ããããŸã㯠constãå¿
èŠãªãšãã ã let ã䜿ãã
ãããŠã颿°ã«é åããªããžã§ã¯ããæž¡ããšãã¯ãå ããŒã¿ã倿ŽããŠããã®ããèããã
ãã®ããããæèããã ãã§ããåŸããèŠè¿ãããšãã«åãããããã³ãŒãã«ãªãããã§ãã
ãã¹ããšããŠåå ããªããã®åè¬ã§ããããèªåèªèº«ã«ãšã£ãŠãããªãåŠã³ã®å€ãåã§ããã
ç¹ã« var ããã£ããã«ãã¹ã³ãŒãã®èãæ¹ãæŽçã§ããã®ã¯å€§ããã£ãã§ãã
次å以éã®ã¯ã©ã¹ãã©ã€ãã©ãªã®è©±ã«ãã€ãªãã£ãŠãããããªã®ã§ãä»åã®ãã¹ã³ãŒããšé¢æ°ãã¯ãã£ãã埩ç¿ããŠãããããšæããŸãã
