Google Apps Script gotcha: two form submits in the same second both read getLastRow() = 40, both write row 41, one silently overwrites the other.

sheet.appendRow(row) is atomic — the one write that cannot lose that race.

If you must setValues(), take a LockService lock first. #AppsScript

GASで複数人が同時実行するスクリプトにはLockServiceが必須です。

var lock = LockService.getScriptLock();
lock.waitLock(10000);
// 処理
lock.releaseLock();

データの競合や二重実行を防げます。

#GAS #LockService #排他制御 #自動化

#後で読む 用メモです→
GASトリガーの6分制限と並行実行の罠 LockService 実行ログでの対処法

Join AccuLock Inc. ‘s crew at the #Wyndham Global Conference May 20th-21st in #LasVegas NV! Come see what AccuLock can do for you!!

#AccuLock #OpenKey #Hotel #hotelier #entrepreneur #Lockrepair #Lockservice #ALS2 #electroniclocksmith #electroniclocks #AAHOA #CHOICE #IHG#BHG #BestWestern