CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
user1482800
user1482800

Reputation: 83

From Google Sheets | HTTP Request API to pass edited cell past and new value

I am trying to call an HTTP API from google sheets ,

function atEdit(eventObj) {
//eventObj.range
    callCell(eventObj.range.getValue());
}

so the eventObj gives me current cell value but how to get the past value or in other words the value just before the edit was made.

Upvotes: 0

Views: 140

Answers (1)

Wicket
Wicket

Reputation: 38200

If atEdit is a function called by on edit installable trigger, then eventObj is the edit event object, in such case you could use eventObj.oldValue

Reference

Upvotes: 1

Related Questions