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

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

转载作者：行者123 更新时间：2023-11-30 13:50:49

我有一个脚本，在我最后一次尝试时运行良好，尽管从那以后我向它添加了一些东西并使它成为一个多页表单。该代码似乎收集了数据，但似乎并未将其传输到谷歌表格。自上次运行以来，我没有更改输入的名称。

代码.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;
  var Transmission = sign.Transmission;
  var TripRecorder = sign.TripRecorder;
  var WheelsandRims = sign.WheelsandRims;
  var Windows = sign.Windows;
  var WindshieldWipers = sign.WindshieldWipers;
  var Other = sign.Other;
  var imageCell = ss.getRange(ss.getLastRow()+1, 2, 1, 48).setValues([[carrier, address, dname, dnum, date, time, tractortruck, odom, aircompressor, airlines, BeltsandHoses, Body, BrakeAccessories, BrakesParking, BrakesService, Clutch, CouplingDevices, DefrosterHeater, DriveLine, Engine, Exhaust, FifthWheel, FluidLevels, FrameandAssembly, FrontAxle, FuelTanks, Horn, Lights, Mirrors, Muffler, OilPressure, Radiator, RearEnd, Reflectors, SafetyEquipment, Starter, Steering, SuspensionSystem, TireChains, Tires, Transmission, TripRecorder, WheelsandRims, Windows, WindshieldWipers, Other,url]]);
}

HTML:

<!DOCTYPE html>
<html>
<head><meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable:no"/></head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script src="https://cdn.rawgit.com/willowsystems/jSignature/master/libs/jSignature.min.js"></script>
<style>
input[type=submit]:disabled {
    background-color: Salmon;
    }
/* Mark input boxes that gets an error on validation: */
input.invalid {
  border: 2px solid #ff0000;
  box-shadow:0 0 15px 0px #ff0000 inset;
}

.tab {
  height: 0;
  overflow: hidden;
}
.step {
  height: 30px;
  width: 30px;
  margin: 0 2px;
  background-color: #bbbbbb;
  border: none;  
  border-radius: 50%;
  display: inline-block;
  opacity: 0.5;
}

.step.active {
  opacity: 1;
}
.step.finish {
  background-color: IndianRed;
}
table {
    width: 100%;
    border-collapse: collapse;
    table-layout: auto;
    touch-action: manipulation;
    }
td, th {
    font-size: 40px;
    border: 2px solid GhostWhite;
    }
th {
    text-align: left;
    }
td {
    text-align: center;
    }
.controls-panel {
    float: right;
    }
.clear-button {
    width: 150px;
  height: 40px;
  font-size: 25px;
  display: block;
  margin-left: auto;
    }
    input[type=submit] {
  width: 100%;
  background-color: DarkRed;
  color: white;
  padding: 14px 20px;
  margin: 8px 0;
  border: none;
  border-radius: 4px;
  cursor: pointer;
  font-size: 1em;
}
.modal {
  width: 100%;
  border: 2px solid #ccc;
  border-radius: 4px;
  background-color: GhostWhite;
  color: Black;
  }
  .signature-panel {
  padding: 0 20px 0 20px;
  }
p {
    font-size: 2em;
    }

h3 {
border: 6px dashed Red;
}

@media screen and (orientation:landscape){   
h3 {
height: 0;
overflow: hidden;
border: none;
}
}

</style>
<body>

<form id="regForm" action="/action_page.php">
  <center><h1>DRIVER VEHICLE INSPECTION REPORT</h1>
  <h5>AS  BY THE D.O.T. FEDERAL MOTOR CARRIER SAFETY REGULATIONS</h5></center><br>
   <div class="tab tab1">
  <p>Carrier:<br><br>
  <input type="text" name="carrier" value="My Company"></p>
  Location:
  <table id= "Address">
  <tr>
  <td>PDX</td>
  <td>EUG</td>
  <td>SEA</td>
  <td>SFO</td>
  </tr>
  <tr>
  <td><input type="radio" id="PDX" oninput="this.className = '';EUG.className = '';SEA.className = '';SFO.className = ''" name="Address" value="PDX"></td>

  <td><input type="radio" id="EUG" oninput="this.className = '';PDX.className = '';SEA.className = '';SFO.className = ''" name="Address" value="EUG"></td>

  <td><input type="radio" id="SEA" oninput="this.className = '';EUG.className = '';PDX.className = '';SFO.className = ''" name="Address" value="SEA"></td>

  <td><input type="radio" id="SFO" oninput="this.className = '';EUG.className = '';SEA.className = '';PDX.className = ''" name="Address" value="SFO"></td>
  </tr>
  </table>
  </div>
  <div class="tab tab2">
  Driver Performing Inspection:
<p><input type="text" oninput="this.className = ''" name="drivername" placeholder="Your full name"></p>
Driver's Employee Number:
<p><input type="number" oninput="this.className = ''" name="drivernumber" placeholder="Your employee number"></p>
Date Performed:
<p><input type="date" id="date" oninput="this.className = ''" name="date"></p>
Time Performed:
<p><input type="time" id="time" oninput="this.className = ''" name="time" value="now"></p>
  </div>
  <div class="tab tab3">
  Tractor/Truck Number:
<p><input type="number" oninput="this.className = ''" name="tractortrucknum" ></p>
Odometer Reading:
<p><input type="number" oninput="this.className = ''" name="odometer" ></p>
  </div>
  <div class="tab tab4">
  <table id="Inspection" width="100%">
  <tr><th></th>
  <td><small>Satisfactory</small></td>
  <td><small>Unsatisfactory</small></td></tr>
  <tr><th><label for="Air Compressor">Air Compressor</label></th>
  <td><input type="radio" id="aircompressor" name="AirCompressor" oninput="this.className='';aircompressor2.className=''" value="sat" ></td>
  <td><input type="radio" id="aircompressor2" name="AirCompressor" oninput="this.className='';aircompressor.className=''" value="unsat" ></td></tr>
  <tr><th><label for="Air Lines">Air Lines</label></th>
  <td><input type="radio" id="airlines" name="AirLines" oninput="this.className='';airlines2.className=''" value="sat" ></td>
  <td><input type="radio" id="airlines2" name="AirLines" oninput="this.className='';airlines.className=''" value="unsat" ></td></tr>
  <tr><th><label for="Battery">Battery</label></th>
  <td><input type="radio" id="battery" name="Battery" oninput="this.className='';battery2.className=''" value="sat" ></td>
  <td><input type="radio" id="battery2" name="Battery" oninput="this.className='';battery.className=''" value="unsat" ></td></tr>
  <tr><th><label for="Belts and Hoses">Belts and Hoses</label></th>
  <td><input type="radio" id="beltsandhoses" name="BeltsandHoses" oninput="this.className='';beltsandhoses2.className=''" value="sat" ></td>
  <td><input type="radio" id="beltsandhoses2" name="BeltsandHoses" oninput="this.className='';beltsandhoses.className=''" value="unsat"></td></tr>
  <tr><th><label for="Body">Body</label></th>
  <td><input type="radio" id="body" name="Body" oninput="this.className='';body2.className=''" value="sat"></td>
  <td><input type="radio" id="body2" name="Body" oninput="this.className='';body.className=''" value="unsat"></td></tr>
  <tr><th><label for="Brake Accessories">Brake Accessories</label></th>
  <td><input type="radio" id="brakeaccessories" name="BrakeAccessories" oninput="this.className='';brakeaccessories2.className=''" value="sat"></td>
  <td><input type="radio" id="brakeaccessories2" name="BrakeAccessories" oninput="this.className='';brakeaccessories.className=''" value="unsat"></td></tr>
  <tr><th><label for="Brakes, Parking">Brakes, Parking</label></th>
  <td><input type="radio" id="brakesparking" name="BrakesParking" oninput="this.className='';brakesparking2.className=''" value="sat"></td>
  <td><input type="radio" id="brakesparking2" name="BrakesParking" oninput="this.className='';brakesparking.className=''" value="unsat"></td></tr>
  <tr><th><label for="Brakes, Service">Brakes, Service</label></th>
  <td><input type="radio" id="brakesservice" name="BrakesService" oninput="this.className='';brakesservice2.className=''" value="sat"></td>
  <td><input type="radio" id="brakesservice2" name="BrakesService" oninput="this.className='';brakesservice.className=''" value="unsat"></td></tr>
  <tr><th><label for="Clutch">Clutch</label></th>
  <td><input type="radio" id="clutch" name="Clutch" oninput="this.className='';clutch2.className=''" value="sat"></td>
  <td><input type="radio" id="clutch2" name="Clutch" oninput="this.className='';clutch.className=''" value="unsat"></td></tr>
  <tr><th><label for="Coupling Devices">Coupling Devices</label></th>
  <td><input type="radio" id="couplingdevices" name="CouplingDevices" oninput="this.className='';couplingdevices2.className=''" value="sat"></td>
  <td><input type="radio" id="couplingdevices2" name="CouplingDevices" oninput="this.className='';couplingdevices.className=''" value="unsat"></td></tr>
  <tr><th><label for="Defroster/Heater">Defroster/Heater</label></th>
  <td><input type="radio" id="defrosterheater" name="DefrosterHeater" oninput="this.className='';defrosterheater2.className=''" value="sat"></td>
  <td><input type="radio" id="defrosterheater2" name="DefrosterHeater" oninput="this.className='';defrosterheater.className=''" value="unsat"></td></tr>
  <tr><th><label for="Drive Line">Drive Line</label></th>
  <td><input type="radio" id="driveline" name="DriveLine" oninput="this.className='';driveline2.className=''" value="sat"></td>
  <td><input type="radio" id="driveline2" name="DriveLine" oninput="this.className='';driveline.className=''" value="unsat"></td></tr>
  <tr><th><label for="Engine">Engine</label></th>
  <td><input type="radio" id="engine" name="Engine" oninput="this.className='';engine2.className=''" value="sat"></td>
  <td><input type="radio" id="engine2" name="Engine" oninput="this.className='';engine.className=''" value="unsat"></td></tr>
  </table>
  </div>
  <div class="tab tab5">
  <table id="inspection2">
   <tr><th>&nbsp;</th>
  <td><small>Satisfactory</small></td>
  <td><small>Unsatisfactory</small></td></tr>
  <tr><th><label for="Exhaust">Exhaust</label></th>
  <td><input type="radio" id="exhaust" name="Exhaust" oninput="this.className='';exhaust2.className=''" value="sat"></td>
  <td><input type="radio" id="exhaust2" name="Exhaust" oninput="this.className='';exhaust.className=''" value="unsat"></td></tr>
  <tr><th><label for="Fifth Wheel">Fifth Wheel</label></th>
  <td><input type="radio" id="fifthwheel" name="FifthWheel" oninput="this.className='';fifthwheel2.className=''" value="sat"></td>
  <td><input type="radio" id="fifthwheel2" name="FifthWheel" oninput="this.className='';fifthwheel.className=''" value="unsat"></td></tr>
  <tr><th><label for="Fluid Levels">Fluid Levels</label></th>
  <td><input type="radio" id="fluidlevels" name="FluidLevels" oninput="this.className='';fluidlevels2.className=''" value="sat"></td>
  <td><input type="radio" id="fluidlevels2" name="FluidLevels" oninput="this.className='';fluidlevels.className=''" value="unsat"></td></tr>
  <tr><th><label for="Frame and Assembly">Frame and Assembly</label></th>
  <td><input type="radio" id="frameandassembly" name="FrameandAssembly" oninput="this.className='';frameandassembly2.className=''" value="sat"></td>
  <td><input type="radio" id="frameandassembly2" name="FrameandAssembly" oninput="this.className='';frameandassembly.className=''" value="unsat"></td></tr>
  <tr><th><label for="Front Axle">Front Axle</label></th>
  <td><input type="radio" id="frontaxle" name="FrontAxle" oninput="this.className='';frontaxle2.className=''" value="sat"></td>
  <td><input type="radio" id="frontaxle2" name="FrontAxle" oninput="this.className='';frontaxle.className=''" value="unsat"></td></tr>
  <tr><th><label for="Fuel Tanks">Fuel Tanks</label></th>
  <td><input type="radio" id="fueltanks" name="FuelTanks" oninput="this.className='';fueltanks2.className=''" value="sat"></td>
  <td><input type="radio" id="fueltanks2" name="FuelTanks" oninput="this.className='';fueltanks.className=''" value="unsat"></td></tr>
  <tr><th><label for="Horn">Horn</label></th>
  <td><input type="radio" id="horn" name="Horn" oninput="this.className='';horn2.className=''" value="sat"></td>
  <td><input type="radio" id="horn2" name="Horn" oninput="this.className='';horn.className=''" value="unsat"></td></tr>

  <tr><th><label for="Lights">Lights -<br>&nbsp;&nbsp;&nbsp;&nbsp;Head/Stop<br>&nbsp;&nbsp;&nbsp;&nbsp;Tail/Dash<br>&nbsp;&nbsp;&nbsp;&nbsp;Turn Indicators<br>&nbsp;&nbsp;&nbsp;&nbsp;Clearance/Marker</label></th>
  <td><input type="radio" id="lights" name="Lights" oninput="this.className='';lights2.className=''" value="sat"></td>
  <td><input type="radio" id="lights2" name="Lights" oninput="this.className='';lights.className=''" value="unsat"></td></tr>
  <tr><th><label for="Mirrors">Mirrors</label></th>
  <td><input type="radio" id="mirrors" name="Mirrors" oninput="this.className='';mirrors2.className=''" value="sat"></td>
  <td><input type="radio" id="mirrors2" name="Mirrors" oninput="this.className='';mirrors.className=''" value="unsat"></td></tr>
  <tr><th><label for="Muffler">Muffler</label></th>
  <td><input type="radio" id="muffler" name="Muffler" oninput="this.className='';muffler2.className=''" value="sat"></td>
  <td><input type="radio" id="muffler2" name="Muffler" oninput="this.className='';muffler.className=''" value="unsat"></td></tr>
  <tr><th><label for="Oil Pressure">Oil Pressure</label></th>
  <td><input type="radio" id="oilpressure" name="OilPressure" oninput="this.className='';oilpressure2.className=''" value="sat"></td>
  <td><input type="radio" id="oilpressure2" name="OilPressure" oninput="this.className='';oilpressure.className=''" value="unsat"></td></tr>
  <tr><th><label for="Radiator">Radiator</label></th>
  <td><input type="radio" id="radiator" name="Radiator" oninput="this.className='';radiator2.className=''" value="sat"></td>
  <td><input type="radio" id="radiator2" name="Radiator" oninput="this.className='';radiator.className=''" value="unsat"></td></tr>
  <tr><th><label for="Rear End">Rear End</label></th>
  <td><input type="radio" id="rearend" name="RearEnd" oninput="this.className='';rearend2.className=''" value="sat"></td>
  <td><input type="radio" id="rearend2" name="RearEnd" oninput="this.className='';rearend.className=''" value="unsat"></td></tr>
  </table>
  </div>
  <div class="tab tab6">
  <table id="inspection3">
   <tr><th>&nbsp;</th>
  <td><small>Satisfactory</small></td>
  <td><small>Unsatisfactory</small></td></tr>
  <tr><th><label for="Reflectors">Reflectors</label></th>
  <td><input type="radio" id="reflectors" name="Reflectors" oninput="this.className='';reflectors2.className=''" value="sat"></td>
  <td><input type="radio" id="reflectors2" name="Reflectors" oninput="this.className='';reflectors.className=''" value="unsat"></td></tr>
  <tr><th><label for="Safety Equipment">Safety Equipment -<br>&nbsp;&nbsp;&nbsp;&nbsp;Fire Extinguisher<br>&nbsp;&nbsp;&nbsp;&nbsp;Flags/Flares/Fusees<br>&nbsp;&nbsp;&nbsp;&nbsp;Reflective Triangles<br>&nbsp;&nbsp;&nbsp;&nbsp;Spare Bulbs and Fuses<br>&nbsp;&nbsp;&nbsp;&nbsp;Spare Seal Beam</label></th>
  <td><input type="radio" id="safetyequipment" name="SafetyEquipment" oninput="this.className='';safetyequipment2.className=''" value="sat"></td>
  <td><input type="radio" id="safetyequipment2" name="SafetyEquipment" oninput="this.className='';safetyequipment.className=''" value="unsat"></td></tr>
  <tr><th><label for="Starter">Starter</label></th>
  <td><input type="radio" id="starter" name="Starter" oninput="this.className='';starter2.className=''" value="sat"></td>
  <td><input type="radio" id="starter2" name="Starter" oninput="this.className='';starter.className=''" value="unsat"></td></tr>
  <tr><th><label for="Steering">Steering</label></th>
  <td><input type="radio" id="steering" name="Steering" oninput="this.className='';steering2.className=''" value="sat"></td>
  <td><input type="radio" id="steering2" name="Steering" oninput="this.className='';steering.className=''" value="unsat"></td></tr>
  <tr><th><label for="Suspension System">Suspension System</label></th>
  <td><input type="radio" id="suspensionsystem" name="SuspensionSystem" oninput="this.className='';suspensionsystem2.className=''" value="sat"></td>
  <td><input type="radio" id="suspensionsystem2" name="SuspensionSystem" oninput="this.className='';suspensionsystem.className=''" value="unsat"></td></tr>
  <tr><th><label for="Tire Chains">Tire Chains</label></th>
  <td><input type="radio" id="tirechains" name="TireChains" oninput="this.className='';tirechains2.className=''" value="sat"></td>
  <td><input type="radio" id="tirechains2" name="TireChains" oninput="this.className='';tirechains.className=''" value="unsat"></td></tr>
  <tr><th><label for="Tires">Tires</label></th>
  <td><input type="radio" id="tires" name="Tires" oninput="this.className='';tires2.className=''" value="sat"></td>
  <td><input type="radio" id="tires2" name="Tires" oninput="this.className='';tires.className=''" value="unsat"></td></tr>
  <tr><th><label for="Transmission">Transmission</label></th>
  <td><input type="radio" id="transmission" name="Transmission" oninput="this.className='';transmission2.className=''" value="sat"></td>
  <td><input type="radio" id="transmission2" name="Transmission" oninput="this.className='';transmission.className=''" value="unsat"></td></tr>
  <tr><th><label for="Trip Recorder">Trip Recorder</label></th>
  <td><input type="radio" id="triprecorder" name="TripRecorder" oninput="this.className='';triprecorder2.className=''" value="sat"></td>
  <td><input type="radio" id="triprecorder2" name="TripRecorder" oninput="this.className='';triprecorder.className=''" value="unsat"></td></tr>
  <tr><th><label for="Wheels and Rims">Wheels and Rims</label></th>
  <td><input type="radio" id="wheelsandrims" name="WheelsandRims" oninput="this.className='';wheelsandrims2.className=''" value="sat"></td>
  <td><input type="radio" id="wheelsandrims2" name="WheelsandRims" oninput="this.className='';wheelsandrims.className=''" value="unsat"></td></tr>
  <tr><th><label for="Windows">Windows</label></th>
  <td><input type="radio" id="windows" name="Windows" oninput="this.className='';windows2.className=''" value="sat"></td>
  <td><input type="radio" id="windows2" name="Windows" oninput="this.className='';windows.className=''" value="unsat"></td></tr>
  <tr><th><label for="Windshield Wipers">Windshield Wipers</label></th>
  <td><input type="radio" id="windshieldwipers" name="WindshieldWipers" oninput="this.className='';windshieldwipers2.className=''" value="sat"></td>
  <td><input type="radio" id="windshieldwipers2" name="WindshieldWipers" oninput="this.className='';windshieldwipers.className=''" value="unsat"></td></tr>
  <tr><th><label for="Other">Other</label></th>
  <td><input type="radio" id="other" name="Other" oninput="this.className='';other2.className=''" value="sat"></td>
  <td><input type="radio" id="other2" name="Other" oninput="this.className='';other.className=''" value="unsat"></td></tr>
  </table>
  </div>
  <div class="tab tab7">
  <h3><center>* For optimal performance, view page in landscape. *</center></h3>
  Sign in the box below:
<div class="modal">
  <div class="controls-panel">
      <input type="button" class="clear-button" value="Clear"/>
      </div>
    <div class="signature-panel">
  </div>
  <img id="rendered" src="" style="display:none">
  </div>
  <input type="submit" class="Submit" value="Submit and close" onclick="renderSignature();saveImage();" disabled/>
</div> 
<br><br>
  <div style="overflow:auto;">
    <div class="previous" style="float:left;">
      <button type="button" id="prevBtn" onclick="nextPrev(-1)">&laquo; Previous</button>
      </div>
      <div class="next" style="float:right;">
      <button type="button" id="nextBtn" onclick="nextPrev(1)">Next &raquo;</button>
    </div>
  </div>
  <!-- Circles which indicates the steps of the form: -->
  <div style="text-align:center;margin-top:40px;">
    <span class="step"></span>
    <span class="step"></span>
    <span class="step"></span>
    <span class="step"></span>
    <span class="step"></span>
    <span class="step"></span>
    <span class="step"></span>
  </div>
</form>

<script>
$('.signature-panel').jSignature();

  $('.clear-button').on('click', function(e) {
    $('.signature-panel').jSignature("reset");
  });

let date = new Date().toISOString().substr(0, 10);
document.querySelector("#date").value = date;

$(function(){     
  var d = new Date(),        
      h = d.getHours(),
      m = d.getMinutes();
  if(h < 10) h = '0' + h; 
  if(m < 10) m = '0' + m; 
  $('input[type="time"][value="now"]').each(function(){ 
    $(this).attr({'value': h + ':' + m});
  });
});

  function renderSignature(){
  $("img#rendered").attr("src",$('.signature-panel').jSignature('getData','default'));
  }

    function saveImage(e){ //This sends the image src to saveImages function
    var bytes = document.getElementById('rendered').src;
    console.log(bytes);
    var sign = {
      carrier: document.getElementsByName('carrier')[0].value,
      address: $('input[name="Address"]:checked').val(),
      dname: document.getElementsByName('drivername')[0].value,
      dnum: document.getElementsByName('drivernumber')[0].value,
      date: document.getElementsByName('date')[0].value,
      time: document.getElementsByName('time')[0].value,
      tractortruck: document.getElementsByName('tractortrucknum')[0].value,
      odom: document.getElementsByName('odometer')[0].value,
      aircompressor: $('input[name="AirCompressor"]:checked').val(),
      airlines: $('input[name="AirLines"]:checked').val(),
      BeltsandHoses: $('input[name="BeltsandHoses"]:checked').val(),
      Body: $('input[name="Body"]:checked').val(),
      BrakeAccessories: $('input[name="BrakeAccessories"]:checked').val(),
      BrakesParking: $('input[name="BrakesParking"]:checked').val(),
      BrakesService: $('input[name="BrakesService"]:checked').val(),
      Clutch: $('input[name="Clutch"]:checked').val(),
      CouplingDevices: $('input[name="CouplingDevices"]:checked').val(),
      DefrosterHeater: $('input[name="DefrosterHeater"]:checked').val(),
      DriveLine: $('input[name="DriveLine"]:checked').val(),
      Engine: $('input[name="Engine"]:checked').val(),
      Exhaust: $('input[name="Exhaust"]:checked').val(),
      FifthWheel: $('input[name="FifthWheel"]:checked').val(),
      FluidLevels: $('input[name="FluidLevels"]:checked').val(),
      FrameandAssembly: $('input[name="FrameandAssembly"]:checked').val(),
      FrontAxle: $('input[name="FrontAxle"]:checked').val(),
      FuelTanks: $('input[name="FuelTanks"]:checked').val(),
      Horn: $('input[name="Horn"]:checked').val(),
      Lights: $('input[name="Lights"]:checked').val(),
      Mirrors: $('input[name="Mirrors"]:checked').val(),
      Muffler: $('input[name="Muffler"]:checked').val(),
      OilPressure: $('input[name="OilPressure"]:checked').val(),
      Radiator: $('input[name="Radiator"]:checked').val(),
      RearEnd: $('input[name="RearEnd"]:checked').val(),
      Reflectors: $('input[name="Reflectors"]:checked').val(),
      SafetyEquipment: $('input[name="SafetyEquipment"]:checked').val(),
      Starter: $('input[name="Starter"]:checked').val(),
      Steering: $('input[name="Steering"]:checked').val(),
      SuspensionSystem: $('input[name="SuspensionSystem"]:checked').val(),
      TireChains: $('input[name="TireChains"]:checked').val(),
      Tires: $('input[name="Tires"]:checked').val(),
      Transmission: $('input[name="Transmission"]:checked').val(),
      TripRecorder: $('input[name="TripRecorder"]:checked').val(),
      WheelsandRims: $('input[name="WheelsandRims"]:checked').val(),
      Windows: $('input[name="Windows"]:checked').val(),
      WindshieldWipers: $('input[name="WindshieldWipers"]:checked').val(),
      Other: $('input[name="Other"]:checked').val(),
    };
    alert("saveImage successful");
    google.script.run.saveImage(bytes, sign);
    return
  }

var currentTab = 0; 
showTab(currentTab);

function showTab(n) {
  var x = document.getElementsByClassName("tab");
  x[n].style.height = "100%";
  x[n].style.overflow = "visible";
  if (n == 0) {
    document.getElementById("prevBtn").style.display = "none";
  } else {
    document.getElementById("prevBtn").style.display = "inline";
    document.getElementById("nextBtn").style.display = "inline";
  }
  if (n == (x.length - 1)) {
    document.getElementById("nextBtn").style.display = "none";landscapeCheck();
  } else {
    document.getElementById("nextBtn").innerHTML = "Next &raquo;";
  }
  fixStepIndicator(n)
}

function nextPrev(n) {
  var x = document.getElementsByClassName("tab");
  if (n == 1 && !validateForm()) return false;
  x[currentTab].style.height = "0";
  x[currentTab].style.overflow = "hidden";
  currentTab = currentTab + n;
  if (currentTab >= x.length) {
 return false;
  }
  showTab(currentTab);
  document.body.scrollTop = 0;
  document.documentElement.scrollTop = 0;
}

function validateForm() {
  var x, y, i, q, valid = true;
  x = document.getElementsByClassName("tab");
  y = x[currentTab].getElementsByTagName("input");
  q = document.getElementsByClassName(" invalid");
  for (i = 0; i < y.length; i++) {
   if (y[i].type !== "radio" && y[i].value == "") {
      y[i].className += " invalid";
      valid = false;
    }
    else if (y[i].type == "radio") {
    var z = y[i].name;
    if ($('input[name="'+ z + '"]').is(':checked') == false) {
    y[i].className += " invalid";
    valid = false;
    }
   }  
  }
  // If the valid status is true, mark the step as finished and valid:
if (valid) {
    document.getElementsByClassName("step")[currentTab].className += " finish";
  }
else {
$('html, body').animate({
    scrollTop: ($('input.invalid').first().offset().top)
},500);
}
  return valid;
} 
function fixStepIndicator(n) {
  var i, x = document.getElementsByClassName("step");
  for (i = 0; i < x.length; i++) {
    x[i].className = x[i].className.replace(" active", "");
  }
  x[n].className += " active";
}

$(".signature-panel").bind(
    "change"
    , function(event){
        var d = $(event.target).jSignature("getData", "native")
        if ( d.length > 2 || ( d.length === 1 && d[0].x.length > 10 ) ){
            // $(event.target).unbind('change')
            $(".Submit").removeAttr("disabled")
        } else {
            $(".Submit").attr("disabled", true)
        }
    }
)


</script>

</body>
</html>

代码是从我发现的或帮助创建的代码中拼凑而成的，所以我理解其中的大部分内容，但还不足以进行调试。

最佳答案

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

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

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

关于javascript - 将表单数据收集到 Google 表格时遇到更多麻烦，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/58278696/

文章推荐： javascript - react redux 打印 Prop 的方式

文章推荐： javascript - 使用 d3-tip.js 在悬停时显示工具提示

文章推荐： javascript - <# 在 HTML 中是什么意思？

文章推荐： javascript - Vuetify 在焦点上打开选择/自动完成/组合框菜单

android - 当我们使用 SQLite 时，当我们使用 content provider 时，当我们使用 Shared preference 时
SQLite、Content provider 和 Shared Preference 之间的所有已知区别。但我想知道什么时候需要根据情况使用 SQLite 或 Content Provider 或
Backbone.js 模型验证仅在 set->save 时(不是在 fetch 时)
警告:我正在使用一个我无法完全控制的后端，所以我正在努力解决 Backbone 中的一些注意事项，这些注意事项可能在其他地方更好地解决......不幸的是，我别无选择，只能在这里处理它们! 所以，我的
jquery - 使用 “prefetch” 时 Twitter 预输入没有结果，但使用 “remote” JSON 时
我一整天都在挣扎。我的预输入搜索表达式与远程 json 数据完美配合。但是当我尝试使用相同的 json 数据作为预取数据时，建议为空。点击第一个标志后，我收到预定义消息“无法找到任何内容...”，结果
java - repaint() 时 JTextArea 不显示，但 revalidate() 时 Graphics 不更新？
我正在制作一个模拟 NHL 选秀彩票的程序，其中屏幕右侧应该有一个 JTextField，并且在左侧绘制弹跳的选秀球。我创建了一个名为 Ball 的类，它实现了 Runnable，并在我的主 Draf
java - java中将时间戳转换为特定格式(年、月、周、日、时、时、分、秒)
这个问题已经有答案了: How can I calculate a time span in Java and format the output? (18 个回答) 已关闭 9 年前。这是我的代码
设置 header 时 AJAX 请求失败，但没有设置 header 时 AJAX 请求会成功
我有一个 ASP.NET Web API 应用程序在我的本地 IIS 实例上运行。 Web 应用程序配置有 CORS。我调用的 Web API 方法类似于: [POST("/API/{foo}/{ba
android - 用户输入年、月、日、时、分与系统年、月、日、时、分的区别
我将用户输入的时间和日期作为: DatePicker dp = (DatePicker) findViewById(R.id.datePicker); TimePicker tp = (TimePic
algorithm - 在处理 Tabu Search Optimization 时，当所有相邻解决方案都是 tabu 时，通常的做法是什么？
放宽“邻居”的标准是否足够，或者是否有其他标准行动可以采取？最佳答案如果所有相邻解决方案都是 Tabu，则听起来您的 Tabu 列表的大小太长或您的释放策略太严格。一个好的 Tabu 列表长度是
c++ - 为什么我需要传递一个比较器来构造一个 priority_queue，当它是 lambda 时，而不是当它是 std::greater 时？
我正在阅读来自 cppreference 的代码示例: #include #include #include #include template void print_queue(T& q)
javascript - 当触发器为 'click' 时，Bootstrap 3 工具提示表现得很奇怪，当触发器为 'manual' 时，则不起作用
我快疯了，我试图理解工具提示的行为，但没有成功。 1. 第一个问题是当我尝试通过插件(按钮 1)在点击事件中使用它时 -> 如果您转到 Fiddle，您会在“内容”内看到该函数' 每次点击都会调用该属
javascript - 使用 useContext 时，数据首先加载为空数组，当我应用 .map() 或 .find() 时，我收到一条错误消息
我在功能组件中有以下代码: const [ folder, setFolder ] = useState([]); const folderData = useContext(FolderContex
swift - 使用 NSURLSession 时 GET 成功，但使用 AFHTTPSessionManager 时 GET 失败
我在使用预签名网址和 AFNetworking 3.0 从 S3 获取图像时遇到问题。我可以使用 NSMutableURLRequest 和 NSURLSession 获取图像，但是当我使用 AFHT
java - 当池生命周期为 LIFE_CYCLE_FAILED 时，使用 UCP 管理器调用 closeConnections() 时 UCP 连接是否关闭？
我正在使用 Oracle ojdbc 12 和 Java 8 处理 Oracle UCP 管理器的问题。当 UCP 池启动失败时，我希望关闭它创建的连接。当池初始化期间遇到 ORA-02391:超过
ios - 当我点击 "Run"时，应用程序崩溃，但是当我点击 "Stop"然后 "Run"时，应用程序崩溃
关闭。此题需要details or clarity 。目前不接受答案。想要改进这个问题吗？通过 editing this post 添加详细信息并澄清问题. 已关闭 9 年前。 Improve
css - 我有一个笨蛋。当我在全局范围内定义我的 css 时，它起作用了。当我在我的组件中定义我的 css 时，它失败了。这是怎么回事？
引用这个plunker: https://plnkr.co/edit/GWsbdDWVvBYNMqyxzlLY?p=preview 我在 styles.css 文件和 src/app.ts 文件中指定
python - 当宽度 <1.0 时，Matplotlib 周线太细；当宽度>=1.0 时，周线太粗
为什么我的条形这么细？我尝试将宽度设置为 1，它们变得非常厚。我不知道还能尝试什么。默认厚度为 0.8，这是应该的样子吗？ import matplotlib.pyplot as plt import
当我使用 RIGHT JOIN 时，MYSQL 无法识别字段，但当我使用 NATURAL JOIN 时，MYSQL 可以识别字段
当我编写时，查询按预期执行: SELECT id, day2.count - day1.count AS diff FROM day1 NATURAL JOIN day2; 但我真正想要的是右连接。当
python - 在 pandas 中读取时间值(时、分、秒、日、月、年)时，如何指定先到先得？
我有以下时间数据: 0 08/01/16 13:07:46,335437 1 18/02/16 08:40:40,565575 2 14/01/16 22:2
javascript - 当我使用 axios POST 时，Req.body 为空，但当我使用 'request' 时，它工作正常
一些背景知识 -我的 NodeJS 服务器在端口 3001 上运行，我的 React 应用程序在端口 3000 上运行。我在 React 应用程序 package.json 中设置了一个代理来代理对端
javascript - 使用 AngularJs 时，当 img 标签具有 src attr 时，如何在其上设置 data-src
我面临着一个愚蠢的问题。我试图在我的 Angular 应用程序中延迟加载我的图像，我已经尝试过这个2: 但是他们都设置了 src attr 而不是 data-src，我在这里遗漏了什么吗？保留 d

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城