Last active
August 29, 2015 14:10
-
-
Save cyhsutw/ff7cabedbd7baab22a6a to your computer and use it in GitHub Desktop.
Response ID
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// (1) 得現在操作的 Form 的回應數量來當作 ID | |
var responseId = FormApp.getActiveForm().getResponses().length; | |
// (2) 取得現在操作的 From 底下儲存回應的 Spreadsheet 最後一筆紀錄的 ID | |
// 因為表單是從第二行開始,所以要減掉 1 | |
var responseId = SpreadsheetApp.openById(FormApp.getActiveForm().getDestinationId()).getLastRow() - 1; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment