Google Apps Script, calling function once when document is copied












0















I have been playing around with Google Script Editor and I've gotten heaps of use out of it.



The next task that I am looking at is automatic formatting and text insertion/replacement when copying a Template.



An example use case is as follows: Within my organisation I have submitted a Doc to the template gallery. When creating a copy of the template I want it to automatically insert today's date and the current time (rounded to the nearest hour).



This is a question about the Triggers. The text replacement bit is easy and done. Not to mention this is just one of the basic use cases, I'll be attempting many more similar behaviours with things like timesheets and the like.



The problem that I am running into is that I can't seem to get the triggers to work as I'd like them to.



2 of the Triggers that I thought I could try and use: onOpen(e) and onInstall(e).



onOpen(e), though it works, it works "too well". That is, it also replaces the text on the original template as well, proving a nuisance when updating info in these templates.



onInstall(e), I thought this would work as creating a copy of the Doc also "installs" the script as well. However this function doesn't seem to run at all.



Any ideas about getting a trigger to happen once and only once when a Doc is created from a template?



Cheers,
Bricktron










share|improve this question



























    0















    I have been playing around with Google Script Editor and I've gotten heaps of use out of it.



    The next task that I am looking at is automatic formatting and text insertion/replacement when copying a Template.



    An example use case is as follows: Within my organisation I have submitted a Doc to the template gallery. When creating a copy of the template I want it to automatically insert today's date and the current time (rounded to the nearest hour).



    This is a question about the Triggers. The text replacement bit is easy and done. Not to mention this is just one of the basic use cases, I'll be attempting many more similar behaviours with things like timesheets and the like.



    The problem that I am running into is that I can't seem to get the triggers to work as I'd like them to.



    2 of the Triggers that I thought I could try and use: onOpen(e) and onInstall(e).



    onOpen(e), though it works, it works "too well". That is, it also replaces the text on the original template as well, proving a nuisance when updating info in these templates.



    onInstall(e), I thought this would work as creating a copy of the Doc also "installs" the script as well. However this function doesn't seem to run at all.



    Any ideas about getting a trigger to happen once and only once when a Doc is created from a template?



    Cheers,
    Bricktron










    share|improve this question

























      0












      0








      0








      I have been playing around with Google Script Editor and I've gotten heaps of use out of it.



      The next task that I am looking at is automatic formatting and text insertion/replacement when copying a Template.



      An example use case is as follows: Within my organisation I have submitted a Doc to the template gallery. When creating a copy of the template I want it to automatically insert today's date and the current time (rounded to the nearest hour).



      This is a question about the Triggers. The text replacement bit is easy and done. Not to mention this is just one of the basic use cases, I'll be attempting many more similar behaviours with things like timesheets and the like.



      The problem that I am running into is that I can't seem to get the triggers to work as I'd like them to.



      2 of the Triggers that I thought I could try and use: onOpen(e) and onInstall(e).



      onOpen(e), though it works, it works "too well". That is, it also replaces the text on the original template as well, proving a nuisance when updating info in these templates.



      onInstall(e), I thought this would work as creating a copy of the Doc also "installs" the script as well. However this function doesn't seem to run at all.



      Any ideas about getting a trigger to happen once and only once when a Doc is created from a template?



      Cheers,
      Bricktron










      share|improve this question














      I have been playing around with Google Script Editor and I've gotten heaps of use out of it.



      The next task that I am looking at is automatic formatting and text insertion/replacement when copying a Template.



      An example use case is as follows: Within my organisation I have submitted a Doc to the template gallery. When creating a copy of the template I want it to automatically insert today's date and the current time (rounded to the nearest hour).



      This is a question about the Triggers. The text replacement bit is easy and done. Not to mention this is just one of the basic use cases, I'll be attempting many more similar behaviours with things like timesheets and the like.



      The problem that I am running into is that I can't seem to get the triggers to work as I'd like them to.



      2 of the Triggers that I thought I could try and use: onOpen(e) and onInstall(e).



      onOpen(e), though it works, it works "too well". That is, it also replaces the text on the original template as well, proving a nuisance when updating info in these templates.



      onInstall(e), I thought this would work as creating a copy of the Doc also "installs" the script as well. However this function doesn't seem to run at all.



      Any ideas about getting a trigger to happen once and only once when a Doc is created from a template?



      Cheers,
      Bricktron







      google-apps-script






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 20 '18 at 4:33









      BricktronBricktron

      154




      154
























          1 Answer
          1






          active

          oldest

          votes


















          1














          First of all, Trigger onInstall(e) works only for Add-ons.
          Now coming to onOpen(e), in my opinion you can use Google Apps Script Property's Services to store one flag which helps your code identifying whether this file has been opened or not.



          So for very first time onOpen(e) runs, assign property eg: propertyService.setProperty("opened","TRUE") and next time you can check by accessing the property whether it has been already "opened" or not.



          Example:



          var openedFlag=propertyService.getProperty("opened");
          if(openedFlag=="TRUE"){
          //Document has been modified
          //Do not run the modifiable code again
          }else {
          //First time
          //Edit the file
          //Set the propertyService to "TRUE"
          }





          share|improve this answer























            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
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53386288%2fgoogle-apps-script-calling-function-once-when-document-is-copied%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









            1














            First of all, Trigger onInstall(e) works only for Add-ons.
            Now coming to onOpen(e), in my opinion you can use Google Apps Script Property's Services to store one flag which helps your code identifying whether this file has been opened or not.



            So for very first time onOpen(e) runs, assign property eg: propertyService.setProperty("opened","TRUE") and next time you can check by accessing the property whether it has been already "opened" or not.



            Example:



            var openedFlag=propertyService.getProperty("opened");
            if(openedFlag=="TRUE"){
            //Document has been modified
            //Do not run the modifiable code again
            }else {
            //First time
            //Edit the file
            //Set the propertyService to "TRUE"
            }





            share|improve this answer




























              1














              First of all, Trigger onInstall(e) works only for Add-ons.
              Now coming to onOpen(e), in my opinion you can use Google Apps Script Property's Services to store one flag which helps your code identifying whether this file has been opened or not.



              So for very first time onOpen(e) runs, assign property eg: propertyService.setProperty("opened","TRUE") and next time you can check by accessing the property whether it has been already "opened" or not.



              Example:



              var openedFlag=propertyService.getProperty("opened");
              if(openedFlag=="TRUE"){
              //Document has been modified
              //Do not run the modifiable code again
              }else {
              //First time
              //Edit the file
              //Set the propertyService to "TRUE"
              }





              share|improve this answer


























                1












                1








                1







                First of all, Trigger onInstall(e) works only for Add-ons.
                Now coming to onOpen(e), in my opinion you can use Google Apps Script Property's Services to store one flag which helps your code identifying whether this file has been opened or not.



                So for very first time onOpen(e) runs, assign property eg: propertyService.setProperty("opened","TRUE") and next time you can check by accessing the property whether it has been already "opened" or not.



                Example:



                var openedFlag=propertyService.getProperty("opened");
                if(openedFlag=="TRUE"){
                //Document has been modified
                //Do not run the modifiable code again
                }else {
                //First time
                //Edit the file
                //Set the propertyService to "TRUE"
                }





                share|improve this answer













                First of all, Trigger onInstall(e) works only for Add-ons.
                Now coming to onOpen(e), in my opinion you can use Google Apps Script Property's Services to store one flag which helps your code identifying whether this file has been opened or not.



                So for very first time onOpen(e) runs, assign property eg: propertyService.setProperty("opened","TRUE") and next time you can check by accessing the property whether it has been already "opened" or not.



                Example:



                var openedFlag=propertyService.getProperty("opened");
                if(openedFlag=="TRUE"){
                //Document has been modified
                //Do not run the modifiable code again
                }else {
                //First time
                //Edit the file
                //Set the propertyService to "TRUE"
                }






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 20 '18 at 11:02









                SIDMISHSIDMISH

                56110




                56110
































                    draft saved

                    draft discarded




















































                    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.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53386288%2fgoogle-apps-script-calling-function-once-when-document-is-copied%23new-answer', 'question_page');
                    }
                    );

                    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







                    Popular posts from this blog

                    Guess what letter conforming each word

                    Port of Spain

                    Run scheduled task as local user group (not BUILTIN)