Is there a way to disable Ctlr+Z (or “undo”) in a specific sheet in Google Sheets?
I have a script that creates an additional sheet in my file called "Changelog" which tracks changes from another sheet (but same file) called "Source". It appends a new row with information specified in the script, however, if I were to undo something in the source sheet, it also undoes and removes the appended row in the Changelog sheet, which is not the ideal behavior.
Is there a way to disable Ctrl+Z in just my Changelog sheet? Or should I just make my script create a separate Google Sheet file altogether and make that my Changelog? I'm trying to avoid the latter because I want to have that information easily accessible to the users using the source file without having to refer to two separate files. Protecting the sheet also does not make it immune to when I undo something in the source file.
Would love to hear your thoughts!
google-apps-script google-sheets
asked Nov 14 '18 at 23:17
denielleannedenielleanne
132
add a comment |
I have a script that creates an additional sheet in my file called "Changelog" which tracks changes from another sheet (but same file) called "Source". It appends a new row with information specified in the script, however, if I were to undo something in the source sheet, it also undoes and removes the appended row in the Changelog sheet, which is not the ideal behavior.
Is there a way to disable Ctrl+Z in just my Changelog sheet? Or should I just make my script create a separate Google Sheet file altogether and make that my Changelog? I'm trying to avoid the latter because I want to have that information easily accessible to the users using the source file without having to refer to two separate files. Protecting the sheet also does not make it immune to when I undo something in the source file.
Would love to hear your thoughts!
google-apps-script google-sheets
asked Nov 14 '18 at 23:17
denielleannedenielleanne
132
add a comment |
I have a script that creates an additional sheet in my file called "Changelog" which tracks changes from another sheet (but same file) called "Source". It appends a new row with information specified in the script, however, if I were to undo something in the source sheet, it also undoes and removes the appended row in the Changelog sheet, which is not the ideal behavior.
Is there a way to disable Ctrl+Z in just my Changelog sheet? Or should I just make my script create a separate Google Sheet file altogether and make that my Changelog? I'm trying to avoid the latter because I want to have that information easily accessible to the users using the source file without having to refer to two separate files. Protecting the sheet also does not make it immune to when I undo something in the source file.
Would love to hear your thoughts!
google-apps-script google-sheets
asked Nov 14 '18 at 23:17
denielleannedenielleanne
132
I have a script that creates an additional sheet in my file called "Changelog" which tracks changes from another sheet (but same file) called "Source". It appends a new row with information specified in the script, however, if I were to undo something in the source sheet, it also undoes and removes the appended row in the Changelog sheet, which is not the ideal behavior.
Is there a way to disable Ctrl+Z in just my Changelog sheet? Or should I just make my script create a separate Google Sheet file altogether and make that my Changelog? I'm trying to avoid the latter because I want to have that information easily accessible to the users using the source file without having to refer to two separate files. Protecting the sheet also does not make it immune to when I undo something in the source file.
Would love to hear your thoughts!
google-apps-script google-sheets
google-apps-script google-sheets
asked Nov 14 '18 at 23:17
denielleannedenielleanne
132
asked Nov 14 '18 at 23:17
denielleannedenielleanne
132
asked Nov 14 '18 at 23:17
denielleannedenielleanne
132
asked Nov 14 '18 at 23:17
denielleannedenielleanne
132
asked Nov 14 '18 at 23:17
denielleannedenielleanne
132
132
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
No way to disable feature like Undo.
Spreadsheet is not a good instrument to use it as a add-only log. If you already logging events through Google Apps Script, I recommend you to use console.log(...) instead, because it is faster than SpreadSheet updating and data is logged to Logging service.
It can contain much more data and it can filter and search faster.
Resources:
- Class
consoledocumentation
answered Nov 15 '18 at 1:35
JakubBoucekJakubBoucek
93569
Well the idea is to eventually use the Changelog sheet to import into ChartIO and it would be sort of our "events" table. Is that possible using the logging service?
– denielleanne
Nov 15 '18 at 17:38
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53310203%2fis-there-a-way-to-disable-ctlrz-or-undo-in-a-specific-sheet-in-google-sheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
No way to disable feature like Undo.
Spreadsheet is not a good instrument to use it as a add-only log. If you already logging events through Google Apps Script, I recommend you to use console.log(...) instead, because it is faster than SpreadSheet updating and data is logged to Logging service.
It can contain much more data and it can filter and search faster.
Resources:
- Class
consoledocumentation
answered Nov 15 '18 at 1:35
JakubBoucekJakubBoucek
93569
Well the idea is to eventually use the Changelog sheet to import into ChartIO and it would be sort of our "events" table. Is that possible using the logging service?
– denielleanne
Nov 15 '18 at 17:38
add a comment |
No way to disable feature like Undo.
Spreadsheet is not a good instrument to use it as a add-only log. If you already logging events through Google Apps Script, I recommend you to use console.log(...) instead, because it is faster than SpreadSheet updating and data is logged to Logging service.
It can contain much more data and it can filter and search faster.
Resources:
- Class
consoledocumentation
answered Nov 15 '18 at 1:35
JakubBoucekJakubBoucek
93569
Well the idea is to eventually use the Changelog sheet to import into ChartIO and it would be sort of our "events" table. Is that possible using the logging service?
– denielleanne
Nov 15 '18 at 17:38
add a comment |
No way to disable feature like Undo.
Spreadsheet is not a good instrument to use it as a add-only log. If you already logging events through Google Apps Script, I recommend you to use console.log(...) instead, because it is faster than SpreadSheet updating and data is logged to Logging service.
It can contain much more data and it can filter and search faster.
Resources:
- Class
consoledocumentation
answered Nov 15 '18 at 1:35
JakubBoucekJakubBoucek
93569
No way to disable feature like Undo.
Spreadsheet is not a good instrument to use it as a add-only log. If you already logging events through Google Apps Script, I recommend you to use console.log(...) instead, because it is faster than SpreadSheet updating and data is logged to Logging service.
It can contain much more data and it can filter and search faster.
Resources:
- Class
consoledocumentation
answered Nov 15 '18 at 1:35
JakubBoucekJakubBoucek
93569
answered Nov 15 '18 at 1:35
JakubBoucekJakubBoucek
93569
answered Nov 15 '18 at 1:35
JakubBoucekJakubBoucek
93569
answered Nov 15 '18 at 1:35
JakubBoucekJakubBoucek
93569
93569
Well the idea is to eventually use the Changelog sheet to import into ChartIO and it would be sort of our "events" table. Is that possible using the logging service?
– denielleanne
Nov 15 '18 at 17:38
add a comment |
Well the idea is to eventually use the Changelog sheet to import into ChartIO and it would be sort of our "events" table. Is that possible using the logging service?
– denielleanne
Nov 15 '18 at 17:38
Well the idea is to eventually use the Changelog sheet to import into ChartIO and it would be sort of our "events" table. Is that possible using the logging service?
– denielleanne
Nov 15 '18 at 17:38
Well the idea is to eventually use the Changelog sheet to import into ChartIO and it would be sort of our "events" table. Is that possible using the logging service?
– denielleanne
Nov 15 '18 at 17:38
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53310203%2fis-there-a-way-to-disable-ctlrz-or-undo-in-a-specific-sheet-in-google-sheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
