🅰️Google Apps Script

🔴 主題

• Google Sheet

• app

• GAS ⟩ commands

⭐️ 重點

a script that is bound to a Google Sheet is called a container-bound script.

專有 classes (如：Sheet, Range ...) 沒有專屬的 prototype❗️

👉 參閱：

• prototype 「❓」頁面

• custom prototypes for Google Apps Script

📗 參考

• Announcing the Apps Script connector for AppSheet: Automate workflows for Google Workspace

• Ben Collins ⟩

  • Google Apps Script: A Beginner’s Guide

  • Introduction To Google Apps Script (👨🏻‍🎓 課程 )

  • API Tutorial For Beginners With Google Sheets & Apps Script

📘 手冊

• Sheet ⟩

  • getDataRange() - from A1 to the last cell with value.

  • getLastRow() - index of the last row that has content.

• Range ⟩

• Dialogs and Sidebars

• Guides ⟩

  • Libraries - script project whose functions can be reused in other scripts.

  • Extending Google Sheet

  • V8 Runtime

🖥️ 影片

• David Weiss ⟩ Apps Script ⟩

  • Spreadsheet Service
  • Maps Service

💎 資源

• Sheet Playground
• Google 雲端範本區

👥 相關

• 目前不支援 class field，但可用 (static/instance) getter/setter 代替。