線上書籍

增加欄位

1. 在「餐點」右邊增加「單價」
2. 糖、冰 [冰] 右邊增加「小計」

印出傳入變數e

1. console.log(e); => 去執行填表單並送出=>在編輯器的執行項目觀看變數

Logging output too large. Truncating output. { toString: [Function], authMode: { toString: [Function: toString], name: [Function: toString], toJSON: [Function: toString], ordinal: [Function: ordinal], compareTo: [Function: compareTo], NONE: { toString: [Function: toString], name: [Function: toString], toJSON: [Function: toString], ordinal: [Function: ordinal], compareTo: [Function: compareTo], NONE: [Circular], CUSTOM_FUNCTION: [Object], LIMITED: [Object], FULL: [Circular] }, CUSTOM_FUNCTION: { toString: [Function: toString], name: [Function: toString], toJSON: [Function: toString], ordinal: [Function: ordinal], compareTo: [Function: compareTo], NONE: [Object], CUSTOM_FUNCTION: [Circular], LIMITED: [Object], FULL: [Circular] }, LIMITED: { toString: [Function: toString], name: [Function: toString], toJSON: [Function: toString], ordinal: [Function: ordinal], compareTo: [Function: compareTo], NONE: [Object], CUSTOM_FUNCTION: [Object], LIMITED: [Circular], FULL: [Circular] }, FULL: [Circular] }, namedValues: { '時間戳記': [ '2024/5/23 下午 5:44:03' ], '糖、冰 [糖]': [ '5分' ], '糖、冰 [冰]': [ '5分' ], '是否升級為套餐？（附飲料甜點，加 25 元）': [ '是' ], '姓名': [ '123' ], '餐點': [ '照燒雞腿飯 $130元' ] }, range: { toString: [Function], setComment: [Function], getComment: [Function], getFilter: [Function], setNumberFormat: [Function], getNumberFormat: [Function], clear: [Function], getValue: [Function], isBlank: [Function], merge: [Function], check: [Function], setValue: [Function], offset: [Function], sort: [Function], copyTo: [Function], setValues: [Function], trimWhitespace: [Function], createDataSourceTable: [Function], setTextRotation: [Function], getA1Notation: [Function], setFontFamilies: [Function], setFontLine: [Function], setFontLines: [Function], setFontSizes: [Function], setFontStyle: [Function], setFontStyles: [Function], setFontWeight: [Function], setFontWeights: [Function], setHorizontalAlignments: [Function], setNumberFormats: [Function], setVerticalAlignments: [Function], copyValuesToRange: [Function], copyFormatToRange: [Function], getFontColor: [Function], getFontColorObject: [Function], getFontColors: [Function], getFontColorObjects: [Function], getFontLine: [Function], getFontLines: [Function], getFontSizes: [Function], getFontStyle: [Function], getFontStyles: [Function], getFontWeights: [Function], getHorizontalAlignment: [Function], getHorizontalAlignments: [Function], getVerticalAlignments: [Function], isStartColumnBounded: [Function], isStartRowBounded: [Function], isEndColumnBounded: [Function], isEndRowBounded: [Function], autoFillToNeighbor: [Function], setShowHyperlink: [Function], getTextRotation: [Function], getTextRotations: [Function], setTextRotations: [Function], setVerticalText: [Function], setTextDirections: [Function], getTextDirections: [Function], splitTextToColumns: [Function], applyRowBanding: [Function], applyColumnBanding: [Function], setWrapStrategy: [Function], setWrapStrategies: [Function], getWrapStrategy: [Function], getWrapStrategies: [Function], createPivotTable: [Function], createDataSourcePivotTable: [Function], shiftRowGroupDepth: [Function], shiftColumnGroupDepth: [Function], expandGroups: [Function], collapseGroups: [Function], getRichTextValue: [Function], getRichTextValues: [Function], setRichTextValue: [Function], setRichTextValues: [Function], getTextStyles: [Function], setTextStyles: [Function], insertCheckboxes: [Function], removeCheckboxes: [Function], activateAsCurrentCell: [Function], deleteCells: [Function], getEndColumn: [Function], getNextDataCell: [Function], getDataRegion: [Function], getFormulaR1C1: [Function], getFormulasR1C1: [Function], getDataSourceFormula: [Function], getNumberFormats: [Function], getBackgroundColors: [Function], insertCells: [Function], setFormulas: [Function], setFormulaR1C1: [Function], setFormulasR1C1: [Function], setBackgroundColors: [Function], getDisplayValue: [Function], getDisplayValues: [Function], mergeAcross: [Function], mergeVertically: [Function], isPartOfMerge: [Function], setBackgroundObject: [Function], setBackgrounds: [Function], getBackgroundObject: [Function], getBackgrounds: [Function], getBackgroundObjects: [Function], setBackgroundRGB: [Function], setComments: [Function], setFontColor: [Function], setFontColorObject: [Function], setFontColors: [Function], setBackground: [Function], clearComment: [Function], getNumRows: [Function], getFontFamilies: [Function], getFormulas: [Function], activate: [Function], uncheck: [Function], getEndRow: [Function], breakApart: [Function], getBorders: [Function], getSheet: [Function], setBorder: [Function], setWrap: [Function], setWraps: [Function], getGridId: [Function], getWrap: [Function], getWraps: [Function], randomize: [Function], autoFill: [Function], isChecked: [Function], getBorder: [Function], getTextDirection: [Function], setTextDirection: [Function], getRowIndex: [Function], getColumnIndex: [Function], getTextStyle: [Function], getFontWeight: [Function], getBackground: [Function], getNumColumns: [Function], getBackgroundColor: [Function], setBackgroundColor: [Function], getVerticalAlignment: [Function], getFontFamily: [Function], setFontFamily: [Function], setTextStyle: [Function], getComments: [Function], getCell: [Function], getRow: [Function], getWidth: [Function], clearFormat: [Function], moveTo: [Function], clearContent: [Function], createFilter: [Function], protect: [Function], getMergedRanges: [Function], setBackgroundObjects: [Function], setFontColorObjects: [Function], getDataValidation: [Function], getDataValidations: [Function], setDataValidation: [Function], setDataValidations: [Function], clearDataValidations: [Function], setFontSize: [Function], getHeight: [Function], getLastRow: [Function], getFontSize: [Function], getDataSourceUrl: [Function], getDataTable: [Function], getBandings: [Function], createTextFinder: [Function], addDeveloperMetadata: [Function], getDeveloperMetadata: [Function], getLastColumn: [Function], getDataSourcePivotTables: [Function], getDataSourceTables: [Function], getDataSourceFormulas: [Function], createDeveloperMetadataFinder: [Function], setHorizontalAlignment: [Function], setVerticalAlignment: [Function], canEdit: [Function], setNotes: [Function], getNotes: [Function], getFormula: [Function], setFormula: [Function], getColumn: [Function], getNote: [Function], clearNote: [Function], setNote: [Function], removeDuplicates: [Function], getValues: [Function], columnEnd: 7, columnStart: 1, rowEnd: 3, rowStart: 3 }, source: { toString: [Function], isReadable: [Function], isWritable: [Function], getName: [Function], getKey: [Function], setName: [Function], getId: [Function], copy: [Function], getOwner: [Function], rename: [Function], getUrl: [Function], getSheets: [Function], addMenu: [Function], removeMenu: [Function], msgBox: [Function], inputBox: [Function], toast: [Functi

2. 請看到「namedValues」
3. 我們也要利用 head
4. console.log(e.namedValues);
   console.log(head);
5. 2024年5月23日 下午5:49:47 偵錯 { '餐點': [ '日式豬排飯 $120 元' ], '時間戳記': [ '2024/5/23 下午 5:49:45' ], '姓名': [ 'qqq' ], '糖、冰 [糖]': [ '7分' ], '糖、冰 [冰]': [ '7分' ], '是否升級為套餐？（附飲料甜點，加 25 元）': [ '是' ] } 2024年5月23日 下午5:49:47 偵錯 [ '時間戳記', '姓名', '餐點', '單價', '是否升級為套餐？（附飲料甜點，加 25 元）', '糖、冰 [糖]', '糖、冰 [冰]', '小計' ]

    

增加程式碼：在 let head 與 let row 之間 //------------------------------------- 傳入的值 let namedValues = e.namedValues; //------------------------------------- 欄號 let priceIndex = head.indexOf('單價') + 1; //單價欄號 let subtotalIndex = head.indexOf('小計') + 1; //小計欄號 //------------------------------------- 取得餐點、是否升級 let meal = namedValues['餐點'][0]; // 餐點 let upgrade = namedValues['是否升級為套餐？（附飲料甜點，加 25 元）'][0]; // 是否升級為套餐？ //-------------------------------------在這裡進行單價和小計的計算（根據您的需求） let price = extractNumberFromString(meal); // 如果升級為套餐，則加 25 元 let subtotal = (upgrade === '是') ? price + 25 : price; //------------------------------------- 寫入單價和小計 ws.getRange(rowIndex, priceIndex).setValue(price); // 單價 ws.getRange(rowIndex, subtotalIndex).setValue(subtotal); // 小計 將餐點的單價分離函式 function extractNumberFromString(str) { // 使用正则表达式匹配字符串中的数字 var matches = str.match(/\d+/); if (matches && matches.length > 0) { var numberValue = parseInt(matches[0]); // 将匹配的数字字符串转换为整数 return numberValue; } else { // Logger.log('未找到数字'); return 0; } }