Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit(e) {
- const ui = SpreadsheetApp.getUi()
- const sheetname = e.range.getSheet().getName()
- const column = e.range.getColumn()
- const row = e.range.getRow()
- const value = e.value
- if (sheetname == 'Data' && row >= 2 && column == 3) {
- switch (value) {
- case 'TRUE':
- e.range.offset(0, 1).setValue(Utilities.formatDate(new Date(), Session.getScriptTimeZone(), 'dd/MM-yyyy hh:mm'));
- break;
- case 'FALSE':
- const res = ui.alert('Youre sure?', '', ui.ButtonSet.YES_NO)
- if (res == ui.Button.YES) {
- e.range.offset(0, 1).clearContent();
- } else {
- e.range.setValue(true)
- }
- break;
- default:
- e.range.insertCheckboxes()
- if (!e.range.offset(0, 1).isBlank()) {
- e.range.setValue(true)
- }
- break;
- }
- }
- }
Add Comment
Please, Sign In to add comment