Retrieving volunteer records by SQL with Google Apps Script in Google Spreadsheet

Recently, I am working for an NGO supporting those severe handicapped. This article documents how I retrieve target entries programmatically.

A) Introduction
B) Function QUERY() and SQL
C) Macros and Google Apps Script
 C1) Interface Setup
 C2) Button to Search
D) Closing

本文亦附有繁體中文（香港）版本。
The traditional Chinese version (zh-HK) of this article is also available.

使用Google Apps Script 及SQL在試算表中提取指定義工的所有時數記錄

A) Introduction

History of volunteering supply insights for my organisation. To make the volunteer record more manageable to staff, different worksheets keep records from distinct departments. The event organizer will append the attendance after each successful hosting. Renewed every year, volunteers also have a well-designed booklet to keep track of how many hours they devoted.

Each department log sheet follows the same structure as the simplified example…