Create a simple data entry form with Apps script

Create a simple data entry form with Apps script

Google sheet 프로그래밍 책을 참조하여 단순한 Data 입력 폼을 만들어 봤습니다.

Project code: https://goo.gl/mT6THg

Code Example 7.2 Sheet에서 Data Entry 메뉴 선택 후 Show Form 클릭

Data 입력 폼에서 입력한 data는 sheet에 적용됩니다.

참조:

Google Sheets Programming With Google Apps Script (2015 Revision Complete)

All the example code in this book is available for download as a single file at https://github.com/Rotifer/GoogleSpreadsheetProgramming_2015

Code Example 7.2

• Html file:

https://github.com/Rotifer/GoogleSpreadsheetProgramming_2015/blob/master/ch07.html

• Apps Script file:

/**
* Create a simple data entry form that collects
* two text values and writes them to the active sheet.
* See also "index.html" in code example ch07.html

https://github.com/Rotifer/GoogleSpreadsheetProgramming_2015/blob/master/ch07.gs