title: What's the best way to make an inventory spreadsheet that can be updated with Google Forms?
body: <p>This is my first time playing with Google Script. I'm somewhat familiar with JavaScript but the problem I ran into is way bigger than my knowledge about programming.</p>
  
  <p>I'm trying to make an inventory list for my dealership that can be updated with a Google Form.
  The form obviously would import the data entries to a spreadsheet. And I'd like to transfer the entries to another sheet so that I can make it look nicer and share it with everyone at the dealership.</p>
  
  <p>There's only 4 columns : Stock number, Model of the car, Trim, and the status of the stock (Available, Sold, etc).</p>
  
  <p>The problem is, for example if a car comes in (stock number 11), I'd fill the form and add it as available. but later when it gets sold, as I fill in the form again to mark it as sold, it would add a duplicate entry with the same stock number and different status. </p>
  
  <p>I've been trying everything I found on the internet to make it overwrite the old data, but I don't seem to be able to make it happen. I'll add an example file down below. Please let me know where to start.</p>
  
  <p>I also though about writing a google script file to take all the entries on form submit and save it in a variable, and then search for the stock number in the second sheet. if the car was already on the list, it would overwrite the status on the old data. If not, it would simply add a new row for the new entry.</p>
  
  <p>However, like I said earlier, I'm really an amateur when it comes to coding. I can understand a little bit of JavaScript. But I find google script way too overwhelming to work with.</p>
  
  <p>I'll appreciate if anyone could help me out with a solution. Thanks!</p>
  
  <ul>
  <li><p><a href="https://docs.google.com/spreadsheets/d/1wnZJs619yVmKWpWHC3OXfnANEE5cVvDxEkMJDH5xL2I/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1wnZJs619yVmKWpWHC3OXfnANEE5cVvDxEkMJDH5xL2I/edit?usp=sharing</a></p></li>
  <li><p><a href="https://docs.google.com/forms/d/e/1FAIpQLSesWysntKIKaYf4dz7KEJhWyZ1x9OiLxKhHzZ0IyPh4D2rrsg/viewform?usp=sf_link" rel="nofollow noreferrer">https://docs.google.com/forms/d/e/1FAIpQLSesWysntKIKaYf4dz7KEJhWyZ1x9OiLxKhHzZ0IyPh4D2rrsg/viewform?usp=sf_link</a></p></li>
  </ul>