Skip to content

Instantly share code, notes, and snippets.

@brunosan
Created May 18, 2012 19:42
Show Gist options
  • Select an option

  • Save brunosan/2727260 to your computer and use it in GitHub Desktop.

Select an option

Save brunosan/2727260 to your computer and use it in GitHub Desktop.
Update Info
function updateInfo(row,reply,column,fieldanswer) {
var current= sheet.getRange(row.id+2, column).getValue();
var updated= (fieldanswer || current);
if (current != updated) {
// update field
sheet.getRange(row.id+2, column).setValue(updated);
sheet.getRange(row.id+2, column).setBackgroundColor('green');
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment