Read / Write a Job CheckpointLong jobs hit the ~6-minute wall mid-batch. A checkpoint in Script Properties — { key, cursor, updatedAt } — lets the next timed trigger…
Try Lock Or SkipTime-driven triggers and overlapping edits collide. withScriptLock waits then throws if it can't acquire — great when failure must be loud…
withScriptLock HelperStandalone projects and library code don't get a Document Lock. When the critical section is the script project itself — watermark updates…
withUserLock HelperDocument locks serialize everyone on a spreadsheet. User locks only serialize the same user's overlapping runs — handy for personal quotas…
withDocumentLock HelperWhen a time-driven trigger and a manual run can overlap — or two editors kick the same sync — you need a lock. This helper wraps LockService…
