将表单数据收集到 Google 表格时遇到更多麻烦

Question

我有一个运行良好的脚本，我上次尝试它时运行良好，尽管从那以后我向它添加了一些东西并使它成为一个多页表单。代码似乎收集数据，但似乎没有将其传输到谷歌表。自从上次这样工作以来，我没有更改过输入的名称。Code.gs:function doGet() {  return HtmlService      .createTemplateFromFile('jSignature')      .evaluate();}function saveImage(bytes, sign){  var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('FormResponse');  var dateObj = Date.now();  var bytes = bytes.split(",")  var blob = Utilities.newBlob(Utilities.base64Decode(bytes[1]), 'image/png');  var fileName = blob.setName("Signature "+dateObj).getName();  var sigFolder = DriveApp.getFolderById("my folder"); //replace with your folder id  var url = sigFolder.createFile(blob).getId();  Logger.log(url)  var carrier = sign.carrier;  var address = sign.address;  var dname = sign.dname;  var dnum = sign.dnum;  var date = sign.date;  var time = sign.time;  var tractortruck = sign.tractortruck;  var odom = sign.odom;  var aircompressor = sign.aircompressor;  var airlines = sign.airlines;  var BeltsandHoses = sign.BeltsandHoses;  var Body = sign.Body;  var BrakeAccessories = sign.BrakeAccessories;  var BrakesParking = sign.BrakesParking;  var BrakesService = sign.BrakesService;  var Clutch = sign.Clutch;  var CouplingDevices = sign.CouplingDevices;  var DefrosterHeater = sign.DefrosterHeater;  var DriveLine = sign.DriveLine;  var Engine = sign.Engine;  var Exhaust = sign.Exhaust;  var FifthWheel = sign.FifthWheel;  var FluidLevels = sign.FluidLevels;  var FrameandAssembly = sign.FrameandAssembly;  var FrontAxle = sign.FrontAxle;  var FuelTanks = sign.FuelTanks;  var Horn = sign.Horn;  var Lights = sign.Lights;  var Mirrors = sign.Mirrors;  var Muffler = sign.Muffler;  var OilPressure = sign.OilPressure;  var Radiator = sign.Radiator;  var RearEnd = sign.RearEnd;  var Reflectors = sign.Reflectors;  var SafetyEquipment = sign.SafetyEquipment;  var Starter = sign.Starter;  var Steering = sign.Steering;  var SuspensionSystem = sign.SuspensionSystem;  var TireChains = sign.TireChains;  var Tires = sign.Tires;}

Answer 1

您从表单中检索了 47 个值，但您的范围ss.getRange(ss.getLastRow()+1, 2, 1, 48)的宽度为 48。

这就是未将值设置到电子表格中的原因。您需要做的就是将代码修改为ss.getRange(ss.getLastRow()+1, 2, 1, 47)

此外，请记住，您在landscapeCheck();内调用了该函数function showTab(n)，但该函数并未在您的代码中的任何位置定义。