simple inventory management system using Google Apps Script
Here is a source code for a simple inventory management system using Google Apps Script: function checkInventory() { var sheet = SpreadsheetApp.getActiveSheet(); var data = sheet.getDataRange().getValues(); var message = "Inventory:\n"; for (var i = 1; i < data.length; i++) { var item = data[i][0]; var quantity = data[i][1]; message += item + ": " + quantity + "\n"; } Browser.msgBox(message); } function updateInventory(item, amount) { var sheet = SpreadsheetApp.getActiveSheet(); var data = sheet.getDataRange().getValues(); for (var i = 1; i < data.length; i++) { if (data[i][0] == item) { var newQuantity = parseInt(data[i][1]) + amount; sheet.getRange(i+1, 2).setValue(newQuantity); break; } } } function submitForm(e) { var i...
Comments
Post a Comment