this is the google script. the app is writing to a few fields, one of them is pie count and one of them is address. The app writes to the correct fields but the script doesn’t seem to run.
function onEdit(x) {
addOrder(x)
}
function addOrder(x){
var row = x.range.getRow();
var col = x.range.getColumn();
var price1 = 8.99
var price2 = 10.99
var editDate = new Date();
var orderNumber = row - 1;
var streetAddress = x.source.getSheetByName(“Orders”).getRange(row, 15).getValue();
var city = x.source.getSheetByName(“Orders”).getRange(row, 16).getValue();
var state = x.source.getSheetByName(“Orders”).getRange(row, 17).getValue();
var zip = x.source.getSheetByName(“Orders”).getRange(row, 18).getValue();
var commaSpace = ", ";
var deliveryAddress = streetAddress + commaSpace + city + commaSpace + state + commaSpace + zip
var pie1Count = x.source.getActiveSheet().getRange(row, 7).getValue();
var pie2Count = x.source.getActiveSheet().getRange(row, 8).getValue();
var pie3Count = x.source.getActiveSheet().getRange(row, 9).getValue();
var pie4Count = x.source.getActiveSheet().getRange(row, 10).getValue();
var customerName = x.source.getActiveSheet().getRange(row, 12).getValue();
var customerPhone = x.source.getActiveSheet().getRange(row, 13).getValue();
var totalPieCount = pie1Count + pie2Count + pie3Count + pie4Count;
var subtotal = pie1Count * price1 + pie2Count * price1 + pie3Count * price1 + pie4Count * price2;
if(row > 1 && x.source.getActiveSheet().getName() == “Orders”) {
if(x.source.getActiveSheet().getRange(row, 1).getValue() == “”) {
x.source.getActiveSheet().getRange(row, 1).setValue(orderNumber);
x.source.getActiveSheet().getRange(row, 2).setValue(editDate);
x.source.getActiveSheet().getRange(row, 4).setValue(editDate);
x.source.getSheetByName(“Pie Makers”).getRange(row, 1).setValue(orderNumber);
}
x.source.getSheetByName(“Orders”).getRange(row, 4).setValue(editDate);
x.source.getSheetByName(“Orders”).getRange(row, 5).setValue(totalPieCount);
x.source.getSheetByName(“Orders”).getRange(row, 6).setValue(subtotal);
x.source.getSheetByName(“Orders”).getRange(row, 14).setValue(deliveryAddress);
x.source.getSheetByName(“Pie Makers”).getRange(row, 2).setValue(editDate);
x.source.getSheetByName(“Pie Makers”).getRange(row, 3).setValue(totalPieCount);
x.source.getSheetByName(“Pie Makers”).getRange(row, 5).setValue(customerName);
x.source.getSheetByName(“Pie Makers”).getRange(row, 6).setValue(customerPhone);
x.source.getSheetByName(“Pie Makers”).getRange(row, 7).setValue(pie1Count);
x.source.getSheetByName(“Pie Makers”).getRange(row, 8).setValue(pie2Count);
x.source.getSheetByName(“Pie Makers”).getRange(row, 9).setValue(pie3Count);
x.source.getSheetByName(“Pie Makers”).getRange(row, 10).setValue(pie4Count);
}
if(row > 1 && x.source.getSheetByName(“Orders”).getRange(row, 3) == “TRUE”){
x.source.getSheetByName(“Pie Makers”).getRange(row, 13).setValue(“TRUE”);
}
}