Expense_Report_Form
Google Apps Script による経費精算申請フォーム
AI Summary
Expense Report Form
GAS library to create expense report forms linked to spreadsheets for univ lab use.
Target Users
Beginner GAS developers building expense report forms with multi-items, tax calc for lab mgmt.
Problems Solved
Creating GAS expense forms with multi-items, tax calc, custom applies to spreadsheets is tedious.
Script ID
- In GAS Editor: Click "Libraries +" → Paste into "Script ID" field → Click "Look up"
- "Expense_Report_Form" will appear in the search results
- Select the latest version (highest number) from "Version" dropdown
- Click "Add"
Tags
Main Features
1
Easy Integration
Add script ID to GAS project for instant customizable form deploy with detailed guide.
2
Multi-Category Setup
addApplyTo/addCategory flexibly adds applies-to (teams) and categories with auto sheet creation.
3
Auto Tax Calc
Tax-in/out toggle auto-calcs; correction for store-specific tax ensures accurate logging.
Examples
Main Functions
| Function | Description |
|---|---|
| ExpenseReportForm.setTitle | Sets form title |
| ExpenseReportForm.addApplyTo | Adds apply-to sheet |
| ExpenseReportForm.addCategory | Adds category to apply-to |
Examples
Form Initialization
/**
* フォーム初期化設定
* ・タイトル設定: ExpenseReportForm.setTitle("経費精算申請フォーム")
* ・申請先追加: ExpenseReportForm.addApplyTo("運營")
* ・カテゴリ追加: ExpenseReportForm.addCategory("運營", "理大祭")
*/
function initializeData () {
ExpenseReportForm.setTitle("経費精算申請フォーム");
ExpenseReportForm.addApplyTo("運營");
ExpenseReportForm.addCategory("運營", "理大祭");
ExpenseReportForm.addCategory("運營", "燕コン");
return ExpenseReportForm.syncData();
}Form Execution & Submit
/**
* フォーム実行・データ追加
* ・データ同期: initializeData()で設定同期
* ・データ追加: ExpenseReportForm.addData(records)
* ・Webアプリ実行: ExpenseReportForm.execute()
*/
function doGet () {
initializeData();
return ExpenseReportForm.execute();
}
function submit (records) {
initializeData();
return ExpenseReportForm.addData(records);
}Default Values Setup
/**
* デフォルト値設定
* ・申請者デフォルト: ExpenseReportForm.setDefaultName("-")
* ・購入場所デフォルト: ExpenseReportForm.setDefaultRetailer("-")
* ・目的デフォルト: ExpenseReportForm.setDefaultPurpose("-")
*/
function setDefaults() {
// ExpenseReportForm.setDefaultName("-");
// ExpenseReportForm.setDefaultRetailer("-");
// ExpenseReportForm.setDefaultPurpose("-");
return ExpenseReportForm.syncData();
}