How to Add Timestamp Automatically When Cell Change by using Apps Script-Part 2 in Hindi
2.1 هزار بار بازدید -
4 سال پیش
-
In this video we can
In this video we can learn how to apply timestamp in google sheet automatically when cell change
Google Sheets - Add Timestamp When Cell Changes - Apps Script-Part 1 Video
Link
Google Sheets Apps Script - Add Times...
Automatically Insert Date and Time Using a Script
Code here
function onEdit(e) {
var s = e.source.getActiveSheet(),
watchcols = [6],
offsetcols = [-1],
ind = watchcols.indexOf(e.range.columnStart)
if (s.getName() !== "Sheet1" || ind === -1) return ;
e.range.offset(0,offsetcols[ind])
.setValue(!e.value ? null : Utilities.formatDate(new Date(),Session.getScriptTimeZone(), "MM/dd/yyyy HH:mm"))
}
Google Sheets - Add Timestamp When Cell Changes - Apps Script-Part 1 Video
Link
Google Sheets Apps Script - Add Times...
Automatically Insert Date and Time Using a Script
Code here
function onEdit(e) {
var s = e.source.getActiveSheet(),
watchcols = [6],
offsetcols = [-1],
ind = watchcols.indexOf(e.range.columnStart)
if (s.getName() !== "Sheet1" || ind === -1) return ;
e.range.offset(0,offsetcols[ind])
.setValue(!e.value ? null : Utilities.formatDate(new Date(),Session.getScriptTimeZone(), "MM/dd/yyyy HH:mm"))
}
4 سال پیش
در تاریخ 1399/10/14 منتشر شده
است.
2,124
بـار بازدید شده