[test] Tutorial: Expense Report Approval

Tutorial: Expense Report Approval - Simple workflow application에서 만든 지출 품의서를 테스트합니다.

Tutorial: Expense Reports 설문지 보내기

• Expense Reports - form 설정

• form 설정 - 사용자 제한 체크 해지

• Expense Reports - form - 설문지 보내기
• https://goo.gl/forms/7rvMU3Te3R5qVx7u1

• Tutorial Expense Reports 폼 응답

• Tutorial: Expense Reports sheet 결과

Timestamp	Email Address	Amount	Description	Manager's Email Address
8/17/2016 3:41:54	khs@eojji.net	50000	test	khs@eojji.net
8/17/2016 20:33:02	backup@eojji.net	3000	테스트 ㅁㅁㅁ	a@eojji.com

Tutorial: Expense Reports - Script Trigger 설정

• 리소스 - 현재 프로젝트의 트리거

• 리소스 - 트리거 - onReportOrApprovalSubmit

• 프로젝트 속성 - 시간대 (GMT+09::00) 서울

• Manager's Email - Expense Report Approval Request

• email - Expense Report Approval Request

Tutorial Expense Report Approvals

• email - Expense Report Approval Request - 링크 클릭
• form Tutorial Expense Report Approvals 응답

• 보기 - 실행 트랜스크립트

[16-08-17 19:25:56:011 PDT] MailApp.sendEmail([a@eojji.com, Expense Report Approval Request, , {htmlBody=backup@eojji.net has requested your approval for an expense report.Amount: $3000Description: 테스트

ㅁㅁㅁReport Id: 3Please appr}]...)[0.25초]

[16-08-17 19:25:56:011 PDT] Sheet.getRange([3, 6])[0초]

[16-08-17 19:25:56:012 PDT] Range.setValue([khs@eojji.net])[0초]

[16-08-17 19:25:56:058 PDT] 실행 성공[총 실행 시간: 1.352초]

• sheet Tutorial Expense Reports State

Google 포토 앨범: https://goo.gl/photos/jWLRo6z49uYeN9Jr9