title: set data validation for column in google doc including new rows
body: <p>I have a column in a google doc with data validation, that makes a drop down menu available when editing existing rows. Occasionally though contributors create new rows at the bottom of the doc and this validation is lost.</p>
  
  <p>I would like to keep this validatation in the column even in newly created rows (excluding the header row).</p>
  
  <p>I have seen much of this discussion throughout stackoverflow and google help forums, but still cannot find a clear answer.</p>
  
  <p>My hunch is that this would involve Google App Acript using an onEdit trigger and then either paint formatting or a combination of the confusing class DataValidationBuilder. (<a href="https://developers.google.com/apps-script/reference/spreadsheet/data-validation-builder" rel="nofollow">https://developers.google.com/apps-script/reference/spreadsheet/data-validation-builder</a>) but I'm not sure beyond that.</p>
  
  <p>If someone could provide the code, or a link to where I can find it, I would be grateful - thanks.</p>