Obsolete
Status Update
No update yet.
Comments
jp...@google.com
Generated Metadata
- Summary: The developer has provided Apps Script code to create a Google Form and link it to a spreadsheet. There is no issue reported but code provided.
- Tags:
Additional resources:
https://developers.google.com/apps-script/reference/forms https://developers.google.com/workspace/forms/api/guides/apps-script-setup https://developers.google.com/apps-script/reference/forms/form-app https://developers.google.com/apps-script/guides/sheets https://developers.google.com/apps-script/reference/forms/form
You can
bl...@google.com
Automated by Blunderbuss job workspace-devrel-public-issue-tracker-blunderbuss-autoassigner for config assign for component 191640.
Description
function createGoogleForm() { var form = FormApp.create("50嵐訂單表單"); form.setDescription("請填寫您的飲料訂單");
// 新增姓名問題 form.addTextItem() .setTitle("您的姓名") .setRequired(true);
// 新增飲料選擇問題 var drinks = [ "茉莉綠茶", "阿薩姆紅茶", "四季春青茶", "黃金烏龍", "1 號（四季春珍波椰）", "波霸綠/紅", "微檸檬紅/青", "檸檬綠/青", "梅の綠", "8 冰綠", "多多綠", "冰淇淋紅茶", "柚子紅", "旺來紅", "鮮柚綠", "紅茶拿鐵", "珍珠紅茶拿鐵", "波霸紅茶拿鐵", "燕麥紅茶拿鐵", "阿華田拿鐵", "冰淇淋紅茶拿鐵", "奶茶", "奶綠", "烏龍奶", "珍珠奶茶", "珍珠奶綠", "波霸奶茶", "波霸奶綠", "燕麥奶茶", "紅茶瑪奇朵", "椰果奶茶", "椰果奶綠", "阿華田", "冰淇淋奶茶", "8 冰茶", "柚子茶", "檸檬汁", "葡萄柚汁", "金桔檸檬", "檸檬梅多多", "葡萄柚多多" ]; form.addMultipleChoiceItem() .setTitle("選擇您的飲料") .setChoiceValues(drinks) .setRequired(true);
// 新增甜度選項 var sweetness = ["正常", "少糖", "半糖", "微糖", "無糖"]; form.addMultipleChoiceItem() .setTitle("甜度選擇") .setChoiceValues(sweetness) .setRequired(true);
// 新增冰量選項 var iceLevels = ["正常", "少冰", "微冰", "去冰", "溫", "熱"]; form.addMultipleChoiceItem() .setTitle("冰量選擇") .setChoiceValues(iceLevels) .setRequired(true);
// 新增備註（可選） form.addParagraphTextItem() .setTitle("備註（可選）");
// 連結表單到試算表 var sheet = SpreadsheetApp.getActiveSpreadsheet(); var formUrl = form.getPublishedUrl(); var editUrl = form.getEditUrl();
// 在試算表 A1 儲存表單連結 sheet.getSheets()[0].getRange("A1").setValue("填寫訂單：" + formUrl); sheet.getSheets()[0].getRange("A2").setValue("編輯表單：" + editUrl); }